1Z0-060 試験問題を無料オンラインアクセス

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.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• C.To enable flashback database, the CDB must be mounted.
• D.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• E.Individual PDBs can be flashed back without flashing back the entire CDB.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A.It fails because no SQL *Loader data file location is specified.
• B.It fails because no SQL *Loader control file location is specified.
• C.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• D.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

• A.The local listener may spawn a now process and have that new process create a thread
• B.Thread creation must be routed through a dispatcher process
• C.Each multithreaded Oracle process has an SCMN thread.
• D.Each Oracle process runs an SCMN thread.
• E.The local listener may pass the request to an existing process which in turn will create a thread.

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?

• A.Open all the pluggable databases.
• B.Mount the container database (CDB) and restore the control file from the control file auto backup.
• C.Recover each pluggable database.
• D.Recover and open the CDB in NORMAL mode.
• E.Start the database instance in the nomount stage and restore the control file from control file auto backup.
• F.Mount the CDB and then recover and open the database, with the RESETLOGS option.

The following parameter are set for your Oracle 12c database instance:

You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK
function.
3. Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK
function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK
function.
Identify the correct sequence of steps:

• A.2, 1, 4, 3, 5
• B.2, 4, 5
• C.1, 2, 4, 5
• D.1, 2, 3, 4, 5