Free Oracle 1Z0-497 Exam Questions

Become Oracle Certified with updated 1Z0-497 exam questions and correct answers

Page: 1 / 31

Total 155 Questions | Updated On: Dec 05, 2025

Add To Cart

Question 1

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

A : only from the server, if the database instance is not up

B : from either a client or server, even if the database instance is not up

C : from either a client or server, only if the database instance is up, and the command connects the session to the instance

D : from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Answer: B

Question 2

Which statement about the Queryable Patch inventory feature is false?

A : It is used to retrieve installed patch information from a SQL prompt.

B : It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers

C : DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D : It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

Answer: A

Question 3

What must you do to an application for it to take advantage of partitioning?

A : recompile it

B : rewrite its SQL queries

C : relink

D : rework the applications schema

E : nothing; it is transparent

Answer: E

Question 4

YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?c

A : FULL

B : SCHEMAS

C : TRANSFORM

D : REMAP_SCHEMA

E : REMAP_TABLESPACE

Answer: D

Question 5

Which two statements about Database Express are true?

A : It uses internal infrastructure components, such as XDB and SQL*Net.

B : It can perform actions outside the database.

C : It has background tasks and processes that periodically collect information via FTP.

D : It has two new features: Performance Hub and Composite Active Reports.

E : cIt is not supported on Standard Edition (SE) and Express Edition (XE).

Answer: A,D

Page: 1 / 31

Total 155 Questions | Updated On: Dec 05, 2025

Add To Cart