Oracle Database 12c Essentials

Here you have the best Oracle 1z0-497 practice exam questions

You have 150 total questions to study from
Each page has 5 questions, making a total of 30 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 22, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 150

Which statement about CDB architecture is true?

Oracle-supplied metadata resides only in the root container.

A seed PDB can sometimes be opened for particular operations.

Multiple PDBs with the same name can reside in the same CDB.

A CDB can have an infinite number of PDBs.

You can create common users in PDBs.

Correct Answer: A

Question 2 of 150

As part of your Oracle Database 12c post-installation tasks, you run these commands:

Cd $ORACLE_HOME/bin -
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?

It enables the Oracle Data Mining option in your Oracle binary files.

It creates the Fast Recovery Area disk group.

It generates Client Static Library.

It configures one of the Oracle user accounts.

It configures Oracle Net Services.

It configures Oracle Messaging Gateway.

Correct Answer: A

Question 3 of 150

Exhibit below:
Exam 1z0-497: Question 3 - Image 1

Which three statements are true about terminating a session?

Without any error, you can terminate the active session by executing:SQL> ALTER SYSTEM KILL SESSION '7, 15';

You can terminate the active session by executing:SQL> ALTER SYSTEM KILL SESSION "7, 15';But you also get the error message:ORA-00028: your session has been killed

You cannot terminate the active session. You have to wait until that session becomes inactive.

Without any error, you can terminate the inactive session by executing:SQL> ALTER SYSTEM KILL SESSION '12, 63';

When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED. The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again.

You cannot terminate the inactive session. You have to wait until that session becomes active again.

Correct Answer: B, D, E

Question 4 of 150

Which targets can be managed by using Enterprise Manager Cloud Control?

Hosts and databases

Hosts, databases, and application servers

Application servers and web applications

Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)

Databases, application servers, and web applications

Hosts, databases, application servers, web applications, OMS, and OMR

Correct Answer: F

Question 5 of 150

Which two statements are true regarding SQL*Plus?

It has commands for performing database administration operations.

It can be used in interactive but not batch mode for SQL commands.

It has to be installed separately after the Oracle Database 12c installation.

Operating system commands can be executed from the SQL*Plus command prompt.

Correct Answer: A, D