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

Changed 1z0-063 Exam Questions

Page: 4 / 10
Total 276 questions

Oracle Database 12c: Advanced Administration Questions and Answers

Question 13

Which two are true about RMAN image copies? (Choose two.)

Options:

A.

The can only be written to disk.

B.

They are the only backup option available for database in NOARCHIVELOG mode.

C.

They can be encrypted using Transparent Data Encryption (TDE).

D.

They can be used as a level 0 incremental backup.

Question 14

You take your database backups by using the RMAN media management interface (MMI).

Which two are true about the use of the RMAN MMI? (Choose two.)

Options:

A.

You can use it to create image copies for entire file systems.

B.

You can use it to create image copies for database files.

C.

You can use it to create backup sets for database files.

D.

You can use it to create proxy copies for database files.

E.

You can use it to create proxy copies for entire file systems.

Question 15

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

Options:

A.

to report on the database schema at an earlier point in time

B.

to store backups that would cause the controlfile to become too large

C.

to allow database duplication without a connection to the target instance

D.

to allow database duplication without a connection to the auxiliary instance

E.

to store backup metadata that would cause the controlfile to become too large

Question 16

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods for recovering the truncated table data? (Choose two.)

Options:

A.

Table Point-in-Time Recovery

B.

Database Point-in-Time Recovery

C.

Tablespace Point-in-Time Recovery

D.

Flashback Database

E.

Flashback Transaction Backout

Page: 4 / 10
Total 276 questions