Oracle 1z0-067 問題集

質問 1：
Which two statements are true regarding an Automatic Storage Management (ASM) instance?
(Choose two.)
A. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
B. An ASM instance mounts an ASM control file
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
D. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
正解：A,C

質問 2：
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
A. Oracle Data Pump
B. Oracle Real Application Security
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Recovery Manager (RMAN)
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in 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?
A. coalesce the indexes tablespace
B. drop and re-create the index
C. rebuild the index online moving it to another tablespace that has enough free space for the index
D. perform an on line table rebuild using dbns_redefir.ition.
E. coalesce the orders index
正解：C,E

質問 4：
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?
A. taking a new snapshot and comparing it with a preserved snapshot
B. AWR Compare Period report
C. Compare Period ADDM report
D. Active Session History (ASH) report
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A. SYSAUX
B. EXAMPLE
C. SYSTEM
D. USERS
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3. Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set DBID for the database.
Identify the required steps in the correct order.
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 2, 4, 5, 7, 6
C. 8, 3, 2, 4, 5, 7, 6
D. 8, 1, 3, 2, 4, 5, 6
E. 1, 3, 2, 4, 8, 5, 6, 7
正解：C

質問 7：
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?
A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
B. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
C. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
D. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
E. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)