1z1-063 무료 덤프문제 온라인 액세스

The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
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_EVOVLE_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, 4, 5
• B.1, 2, 4, 5
• C.1, 2, 3, 4, 5
• D.2, 1, 4, 3, 5

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

• A.PFILE and password file in MOUNT state
• B.online redo log files while the database is open
• C.data blocks in data files that have changed since the previous backup
• D.data files while the database is in NOMOUNT state
• E.data files while the database is open

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

• A.The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• B.The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
• C.The PDB does not close and starts by using the default temporary tablespace defined for the CDB.
• D.The PDB is closed and requires media recovery at the PDB level.

You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)

• A.The pga_aggregate_target and sga_target parameters are automatically set to zero.
• B.The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.
• C.The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• D.The memory_max_target parameter is automatically set to 500 MB.
• E.The value of the memory_max_target parameter remains zero for the database instance.

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:

Which two tasks are performed as part of the import? (Choose two.)

• A.Imported databases are unregistered from the RC11 catalog.
• B.All databases registered in the RC11 catalog are registered in the RC12C catalog.
• C.Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
• D.Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• E.Recovery catalog is resynchronized with the control files of the registered databases.