Question 1

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 2

Choose three. Which three are true about recovering tables using RMAN?

Options :

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

Question 3

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

Options :

A : Create SQL plan directives for each of the regressed statements.

B : Use The SQL Tuning Advisor for each of the regressed statements.

C : Create an adaptive execution plan for each of the regressed statements

D : Use the SQL Access Advisor for each of the regressed statements.

Answer: B

Question 4

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

Options :

A : A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database-s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

B : Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

C : Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.

D : A target database-s persistent RMAN configuration settings are always stored in the target-s control file

Answer: C,D

Question 5

Choose three. Which three are true about the Oracle Optimizer?

Options :

A : It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B : It obeys all hints.

C : It considers object statistics when generating execution plans for SQL statements.

D : It updates stale object statistics in the Data Dictionary.

E : It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

F : It can re-optimize execution plans after previous executions detect suboptimal plans.

Answer: A,D

Smartly Prepare Exam with Free Online 1Z0-083 Practice Test

Buying Options: