Online 1Z0-083 Practice Test

Question 1

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Options :

A : Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B : Recovery catalog is resynchronized with the control files of the registered databases.

C : Imported databases are unregistered from the RC11 catalog.

D : Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E : All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer: A,D

Question 2

Which two are true about Oracle Flashback features? (Choose two.)

Options :

A : FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B : FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C : FLASHBACK TABLE can undrop a column.

D : FLASHBACK DROP can undrop an index when undropping a table.

E : After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Answer: A,D

Question 3

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

Options :

A : the data dictionary in CDB$ROOT

B : the log writer process (LGWR)

C : SYSAUX tablespaces

D : temporary tablespaces

E : the Process Monitor Process (PMON)

F : undo tablespaces

Answer: A,B

Question 4

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

Options :

A : It is enabled for all users having SELECT privilege on SH.SALES.

B : Only successful queries of SH.SALES are written to the audit trail.

C : It is only enabled for user SH.

D : Audit records are always stored in an external audit file.

Answer: A

Question 5

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

Options :

A : FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B : FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C : FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D : FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E : FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F : FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer: A,B

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST