Free 1Z0-497 Practice Test Questions and Answers (2026) | Cert Empire Practice Questions

You can include CONTAINER=CURRENT in the CREATE ROLE statement to specify the role as a local

role.

Reference:

Oracle Database Security Guide , Creating a Local Role

By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this

PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the

transportable tablespace technique.

A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to

an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

Explanation:

Reference:

Benefits of the Multitenant Architecture for Database Consolidation

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

https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035

https://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI7749

https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL4334

Reference:

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

http://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb-12cr1.php

since 11g the syntax got changed to

RMAN> validate [check logical] database;

Example:

DGMGRL> validate database verbose d1

output include:

Block Corruptions found

NO

NO

Reference:

https://bugs.kde.org/show_bug.cgi?id=111460

https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1005

Reference:

http://musingdba.wordpress.com/2013/07/05/new-in-oracle-database-12c-a/

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.

Explanation:

Reference:

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

Recovery Advisor

Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT802

http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10563

Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/undo.htm#ADMIN11463

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.

Explanation:

Reference:

Oracle Database SQL Language Reference 12c , CREATE TABLE

http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10552

http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG817