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 16, 2025

Add To Cart

Question 1

Which two statements about Automatic Data Optimization (ADO) are true?

A : ADO policies can automatically compress data when it qualifies.

B : ADO policies can automatically move segments when necessary.

C : ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D : You cannot compress at block level, but you can compress at segment level.

E : You can compress at row level only for QUERY LOW.

Answer: D,E

Question 2

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 3

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 4

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

Question 5

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

Page: 1 / 31

Total 155 Questions | Updated On: Dec 16, 2025

Add To Cart