1z0-063 Oracle Exam Lab Questions

Oracle Database 12c: Advanced Administration Questions and Answers

Question 5

Examine this query:

SELECT cust_name, amt_due

FROM customers

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

WHERE cust_no = 'AYR2011';

Which two requirements guarantee that the query will execute successfully? (Choose two.)

Options:

Row movement must be enabled for CUSTOMERS.

Automatic Undo Management must be configured.

FLASHBACK must be ON for the database.

Undo retention guarantee must be enabled.

The database must be in ARCHIVELOG mode.

Supplemental logging must be enabled.

Question 6

You execute the commands to configure settings in RMAN:

Then, you issue the following command to take a backup:

Which statement is true about the execution of these commands?

Options:

The backup terminates because the backup destination for disk is not specified in the BACKUP command.

It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.

It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Question 7

Which three RMAN persistent settings can be set for a database? (Choose three.)

Options:

backup retention policy

default backup device type

default section size for backups

default destinations for backups

multiple backup device types for a single backup

Question 8

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

Options:

The PDB is closed and the temp file is re-created automatically when the PDB is opened.

The PDB is closed and requires media recovery at the PDB level.

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

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

Oracle Database 12c: Advanced Administration Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce