Free Oracle 1Z0-497 Exam Actual Questions

The questions for 1Z0-497 were last updated On May 3, 2024

Question No. 1

Which statement about CDB architecture is true?

Show Answer Hide Answer
Correct Answer: A

http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235

Question No. 2

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?

Show Answer Hide Answer
Correct Answer: A

http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)

Question No. 3

Exhibit below:

Which three statements are true about terminating a session?

Show Answer Hide Answer
Correct Answer: B, D, E

B (not A, Not C):

* You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The following statement terminates the session whose system identifier is 7 and serial number is 15:

* Terminating an Active Session

If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:

ORA-00028: your session has been killed

ALTER SYSTEM KILL SESSION '7,15';

E (not F): Terminating an Inactive Session

If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA-00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session.

When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.


Oracle Database Administrator's Guide, Terminating Sessions

URL: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192

Question No. 4

Which two statements are true about shared server sessions?

Show Answer Hide Answer
Correct Answer: B, D

Oracle Database Concepts, 12c, Memory Architecture

Question No. 5

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

Show Answer Hide Answer
Correct Answer: F

http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-best-practicesv2-1493383.pdf (page 3, second bulleted point, last couple of sentences)