Oracle 1z0-063 問題集

質問 1：
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?
A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
B. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
C. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system
正解：B

質問 2：
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?
A. because pga_aggregate_target is not set
B. because sga_target and memory_target are both set
C. because memory_target and memory_max_target cannot be equal
D. because statistics_level is set to basic
正解：D

質問 3：
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?
A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
B. It fails and returns an error because a connection is not made by using the SYSDBA privilege.
C. It succeeds and displays all the tablespaces that belong to the root database.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
正解：A

質問 4：
You issued these commands for one of your databases:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE '/mydir/rman_change_track.f';
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two are true? (Choose two.)
A. The cumulative incremental level 1 database backup fails.
B. Future incremental level 0 database backups will reference the block change tracking file.
C. Future cumulative incremental level 1 database backups will reference the block change tracking file.
D. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.
E. The cumulative incremental level 1 database backup ignores the block change tracking file.
正解：C,D

質問 5：
Identify two scenarios in which the RMAN CROSSCHECK command can be used. (Choose two.)
A. when listing backups that are required for recovery operations
B. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
C. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
D. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
E. when checking for backups that are not required as per the retention policy
正解：A,C

質問 6：
Which three are true about RMAN duplexed backup sets or image copies? (Choose three.)
A. A backup set may be duplexed so that one copy is written to sbt and the other to disk.
B. An image copy on sbt can be copied to disk.
C. A backup set may be duplexed with both copies written to sbt.
D. An image copy on disk can be copied to sbt.
E. An image copy on disk can be copied to disk.
F. A backup set may be duplexed with both copies written to disk.
正解：A,C,F

質問 7：
Which four are true about Consolidated Database Replay? (Choose four.)
A. The workload capture and replay servers must run the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously.
C. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
D. A single replay schedule can be defined for a consolidated replay.
E. A subset of the captured workload can be replayed.
F. A superset of the captured workload can be replayed.
G. Multiple replay schedules can be defined for a consolidated replay.
正解：B,D,E,G

質問 8：
Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)
A. coalesce the indexes tablespace
B. drop and re-create the index
C. perform an on line table rebuild using dbms_redefinition
D. rebuild the index online moving it to another tablespace that has enough free space for the index
E. coalesce the order.ind index
正解：D,E