1Z0-497 Online Practice Questions and Answers

Correct Answer: BDE

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 ORA00028 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.

Reference: Oracle Database Administrator's Guide, Terminating Sessions URL: http://docs.oracle.com/cd/ B28359_01/server.111/b28310/manproc008.htm#ADMIN11192

Correct Answer: AC

Correct Answer: A

Reference: http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1)

Correct Answer: E

Creating a PDB by Plugging an Unplugged PDB into a CDB

An unplugged PDB consists of an XML file that describes the PDB and the PDB's files (such as the data files and wallet file). You can use the CREATE PLUGGABLE DATABASE statement to plug in an unplugged PDB. To do so, you must include a USING clause that specifies the XML file that describes the PDB.

The source CDB is the CDB from which the PDB was unplugged. The target CDB is the CDB into which you are plugging the PDB. The source CDB and target CDB can be the same CDB or different CDBs.

Correct Answer: AD

A (not B): In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Not C: Data Recovery Advisor is not supported for pluggable databases (PDBs).

D: A failure is detected either automatically by the database or through a manual check such as the VALIDATE command. You can use the LIST FAILURE command to view problem statements for failures and the effect of these failures on database operations. Each failure is uniquely identified by a failure number. In the same RMAN session, you can then use the ADVISE FAILURE command to view repair options, which typically include both automated and manual options.

Reference: Oracle Database Backup and Recovery User's Guide, 12c, Diagnosing and Repairing Failures with Data Recovery Advisor

Correct Answer: B

Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch9.htm#o instance

Correct Answer: AC

Correct Answer: BD

B: A NOT NULL constraint is put on the primary key.

D:

*

To enable a unique or primary key constraint, you must have the privileges necessary to create an index on the table. You need these privileges because Oracle Database creates an index on the columns of the unique or primary key in the schema containing the table.

*

TABLESPACE Specify the tablespace in which Oracle Database creates the table, object table OIDINDEX, partition, LOB data segment, LOB index segment, or index-organized table overflow data segment. If you omit TABLESPACE, then the database creates that item in the default tablespace of the

owner of the schema containing the table.

Reference: Oracle Database SQL Language Reference 12c , CREATE TABLE

Correct Answer: BE

B: A network may contain multiple local and remote listeners.

E: Oracle Net Listener is a separate process that runs on the database server. It receives incoming client connection requests and manages the traffic of these requests to the database server.

Incorrect:

Not A: Because the configuration parameters have default values, it is possible to start and use a listener

with no configuration. This default listener has a name of LISTENER, supports no services on startup, and

listens on the following TCP/IP protocol address:

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

Correct Answer: BC

B: The synchronous redo transport mode transmits redo data synchronously with respect to transaction commitment. A transaction cannot commit until all redo generated by that transaction has been successfully sent to every enabled redo transport destination that uses the synchronous redo transport mode. Note that although there is no limit on the distance between a primary database and a SYNC redo transport destination, transaction commit latency increases as network latency increases between a primary database and a SYNC redo transport destination.

C: An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.

Far sync instances are part of the Oracle Active Data Guard Far Sync feature, which requires an Oracle Active Data Guard license.

Reference: