Create a free account to browse all 20 sample questions. The full practice test includes 264 questions. Use the simulator for timed and flashcard mode.
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.)
Correct answers: D, E
D,E
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Correct answers: A, B, E
A,B,E
Identify three benefits of unified auditing.
Correct answers: A, B, E
A,B,E
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?
Correct answers: C, D
C,D--Explanation:
sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=\”DD-MON-YYYY HH24:MI:SS\” References: oracle-base, com/articles/12c/sql-loader-enhancements-12cr1 ">https://oracle-base.com/articles/12c/sql-loader-enhancements-12cr1
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?
Correct answer: C
C
Which two statements are true about Flashback Version Query?
Correct answers: C, D
C,D--Reference:
https://docs.oracle.com/cd/E11882 01/appdev.112/e41502/adfns flashback.htm#ADFNS01004
Which two statements are true regarding SecureFile lobs?
Correct answers: B, D
B,D--Explanation:
References: docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46">http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46
You want to back up a database such that only formatted blocks are backed up.
Which statement is true about this backup operation?
Correct answer: D
D--Explanation:
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement References: docs, oracle. com/database/121/DBSEG/audit_config.htm#DBSEG459">https://docs. oracle. com/database/121/DBSEG/audit_config.htm#DBSEG459
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.)
Correct answer: A
A
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.
Correct answer: B
B
Register free to unlock 10 more sample questions
Create a free account to continue with the rest of the 1z0-067 sample set.
Own this practice test forever.
Any 2 exams per month.
Any 4 exams per month.
Any 12 exams over 3 months.
