RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which two statements are true about the backup performed by the command? (Choose two.)
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Identify three benefits of unified auditing.
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: S>sqlldrhr/hr@pdb table=employees Which two statements are true about the command?
You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘7disk/%U’; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘7disk/%U’; RMAN> BACKUP DATABASE; Which statement is true about the backup set created by the BACKUP command?
Which two statements are true about Flashback Version Query?
Which two statements are true regarding SecureFile lobs?
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool. What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)
Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’); 2. SELECT * FROM customers AS OF SCN 123456; 3. FLASHBACK TABLE customers TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’); 5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; 6. ALTER TABLE customers FLASHBACK ARCHIVE; Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.