Online Access Free 1Z1-060 Practice Test

You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? (Choose two.)

• A.SCOTT, SYS and SYSTEM
• B.Only for successful executions
• C.SYS and SYSTEM, but not SCOTT
• D.Both successful and failed executions
• E.SCOTT, but not SYS and SYSTEM
• F.Only for failed executions

Which two statements are true concerning Information Lifecycle Management (ILM) policies?

• A.Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.
• B.Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.
• C.ILM policy functions return a Boolean value.
• D.Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.
• E.Segment-level policies override row-level policies.

Which three statements are true about using flashback database in a multitenant container database (CDB)?

• A.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
• B.Individual PDBs can be flashed back without flashing back the entire CDB.
• C.To enable flashback database, the CDB must be mounted.
• D.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• E.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

You use a recovery catalog for maintaining your database backups.
You execute the following command:

Which two statements are true? (Choose two.)

• A.Checks are performed to confirm whether all database files exist in correct locations
• B.Backup sets containing both data files and archive logs are created.
• C.Corrupted blocks, if any, are repaired.
• D.Checks are performed for physical corruptions.
• E.Checks are performed for logical corruptions.

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.

• A.Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
• B.Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
• C.Shut down the database instance and then restart the CDB and PDBs.
• D.Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• E.Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.