Question No. 1

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

AYou cannot do this, because you can only clone PDBs into another CDB .

BYou can clone only one PDB (either PDB1 or PDB2) into the same CDB.

CCloning a PDB can use the source files copy method to the target PDB files.

DCloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

Show Answer

Correct Answer: C

Question No. 2

Which statement regarding Oracle Active Data Guard 12c is false?

AAny application compatible with a read-only database can run on an Oracle Active Data Guard standby.

BIt provides new support for DML to global temporary tables and the use of sequences in the standby database.

CIt repairs block corruptions detected in the primary or standby database.

DIt supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

EIt supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

Show Answer

Correct Answer: E

Question No. 3

View the current parameter settings shown in the output below.

NAMETYPEVALUE

db_file_multiblock_read_count integer 107

ddl_lock_timeout integer 60

Distributed_lock_timeout integer 60

dml_locks integer 748

lock_sga boolean FALSE

enab1e_dd1_1ogging boolean FALSE

resumable_timeout integer 0

A user logs in to the hrschema and issues the following commands:

SQL > CREATE TABLE emp

(empno NUMBER(3),

enamo VARCHAR2(20),

sal NUMBER (8, 2));

SQL > INSERT INTO emp (empno, ename) VALUES(1, 'JAMES');

At this moment, a second user also logs in to the hrschema and issues the following command:

SQL > ALTER TABLE emp MODIFY salNUMBER(10, 2);

What happens in this scenario?

AThe second user's session immediately produces a 'resource busy' error.

BThe second user's command executes successfully.

CThe second user's session waits for a time before producing a 'resource busy' error.

DA deadlock is created.

Show Answer

Correct Answer: C

Question No. 4

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

Athe CDB as the ROOT user

Bthe CDB as the CDBADMIN user

Cthe PDB as the ROOT user

Dthe PDB as the PDB Admin user

Show Answer

Correct Answer: D

https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV81511

Question No. 5

Which three statements represent the benefits of multitenant architecture for database consolidation?

AYou can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.

BYou can consolidate shared database memory by combining multiple PDBs in a single CDB.

CPatching individual PDBs requires the same amount of time as patching individual databases.

DConsolidating separate databases into a single CDB requires the same amount of storage allocation.

EIn multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

Show Answer

Correct Answer: A, B, E

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.

Benefits of the Multitenant Architecture for Database Consolidation

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

Free Oracle 1Z0-497 Exam Actual Questions

The questions for 1Z0-497 were last updated On Jan 19, 2025