Oracle 1z0-067 問題集

質問 1：
For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backups of tablespaces
D. backup sets and image copies that are obsolete
E. backups that are marked obsolete according to the current retention policy
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?
A. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
D. A resumable statement can be suspended and resumed only once during execution.
E. A suspended statement will report an error if no corrective action has taken place during a timeout period.
正解：A,E

質問 3：
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?
A. The backup as copy can only be taken to disk
B. Backup will constitute all used and unused blocks in the database
C. Backup can be performed only when the instance is shutdown
D. The backup as copy can only be taken to tape
正解：A,B

質問 4：
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS('SH', 'CUSTOMERS')from dual statement.
2.Execute the dbms_stats.seed_col_usage (null,'SH',500) procedure.
3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage('SH', 'customers') from dual statement.
Identify the correct sequence of steps.
A. 4, 1, 3, 2
B. 2, 3, 4, 1
C. 3, 2, 4, 1
D. 3, 2, 1, 4
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about Consolidated Database Replay?
A. The workload capture and replay systems must have the same operating system (OS).
B. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
C. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
D. A subset of the captured workload can be replayed.
E. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
A. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files
B. Restore the control file from the backup by using the CATALOG options, restore the data files by using the SET NEWNAME command, and recover the data files
C. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files
D. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location
正解：A

質問 7：
You administer a database that was created using Oracle Database 10g.
The default tablespace type property was not changed. You execute this statement to create a tablespace, mytbs:
CREATE TABLESPACE mytbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two.)
A. It is a locally managed tablespace with uniform size of 8m
B. It is a dictionary-managed tablespace
C. It is a bigfile tablespace
D. It is a smallfile tablespace
E. It is a locally managed tablespace with autoallocate
正解：D,E