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

Oracle Database 12c 1z0-063 Syllabus Exam Questions Answers

Page: 10 / 10
Total 276 questions

Oracle Database 12c: Advanced Administration Questions and Answers

Question 37

Your database is in ARCHIVELOG mode and is open.

You issue this command successfully:

Which two are true? (Choose two.)

Options:

A.

Online logs are backed up.

B.

The backup becomes obsolete after one day.

C.

The restore point is automatically deleted after one day.

D.

The restore point TESTDB06 is created.

E.

The existing restore point TESTDB06 is updated.

F.

Archived redo logs are backed up.

Question 38

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.

One of the data files is corrupted and the current online redo log file is lost because of a media failure.

Which action must you take for recovery?

Options:

A.

Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

B.

Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

C.

Restore all the data files, recover them by using the recover database command, and open the database.

D.

Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Question 39

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

Options:

A.

Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.

B.

Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.

C.

Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

D.

Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

E.

Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Question 40

Which two statements are true about RMAN duplexed backups? (Choose two.)

Options:

A.

It is only supported for backups to tape via the media management interface.

B.

It is not supported for image copies.

C.

For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

D.

Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

E.

Duplex backups can contain only data files and control files.

Page: 10 / 10
Total 276 questions