1Z1-060 Exam Question 166
Which three can be performed on a Data Pump type external table? (Choose three.)
1Z1-060 Exam Question 167
You execute a DROP USER CASCADEon an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTStable to the OCP schema.
RECYCLE_BINwas enabled before the DROP USERwas executed and the OCP user has been granted the FLASHBACK ANY TABLEsystem privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTStable to the OCP schema?
RECYCLE_BINwas enabled before the DROP USERwas executed and the OCP user has been granted the FLASHBACK ANY TABLEsystem privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTStable to the OCP schema?
1Z1-060 Exam Question 168
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
1Z1-060 Exam Question 169
What are three purposes of the RMAN "FROM" clause?
1Z1-060 Exam Question 170
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS '+data/prod/myfile.dbf' FOR '+data.231.45678';
What is the result?
SQL > ALTER DISKGROUP data ADD ALIAS '+data/prod/myfile.dbf' FOR '+data.231.45678';
What is the result?