1Z1-060 Exam Question 46
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)
1Z1-060 Exam Question 47
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
1Z1-060 Exam Question 48
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
1Z1-060 Exam Question 49
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

Which three are prerequisites for successful execution of the command? (Choose three.)
1Z1-060 Exam Question 50
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?