CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Legit 1z0-067 Exam Download

Page: 9 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 33

Examine the command to duplicate a database:

RMAN> DUPLICATE TARGET DATABASE TO cdb

PLUGGABLE DATABASE pdb1, pdb5;

Which two statements are true about the DUPLICATE command?

Options:

A.

The SPFILE is copied along with the data files of the pluggable databases (PDBs).

B.

The root and the seed database in the container database (CDB) are also duplicated.

C.

A backup of pdb1 and pd5 must exist before executing the command.

D.

The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

E.

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Question 34

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

Options:

A.

It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.

B.

It fails and reports an error because the container=all clause is not used.

C.

It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.

D.

It fails and reports an error because the comtainer=current clause is not used.

Question 35

You want RMAN to make duplicate copies of data files when using the backup command.

What must you set using the RMAN configure command to achieve this?

Options:

A.

MAXSETSIZE TO 2;

B.

DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

C.

CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';

D.

DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Question 36

Which three statements are true about the database instance startup after an instance failure?

Options:

A.

The RECO process recovers the uncommitted transactions at the next instance startup.

B.

Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

C.

Uncommitted changes are rolled back to ensure transactional consistency.

D.

The SMON process automatically performs the database recovery.

E.

Media recovery is required to complete the database recovery.

F.

Changes committed before the failure, which were not written to the data files, are re-applied.

Page: 9 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF