Oracle 1z0-034 問題集

質問 1：
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?
A. You must take the tools01.dbf data file offline before you start a block media recovery.
B. You must restore a backup control file to perform a block media recovery.
C. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.
D. You must ensure that the SALES database is mounted or open.
E. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
正解：C,D

質問 2：
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?
A. The statistics are treated as the current statistics by the optimizer for the current sessions only.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are stored in the pending statistics table in the data dictionary.
D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
正解：C

質問 3：
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:

A. The COMMIT order in the captured workload is preserved during replay.
B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
正解：A,D,E

質問 4：
Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It checks whether the alias metadata directory and the file directory are linked correctly.
B. It repairs blocks that have read disk I/O errors.
C. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
D. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
正解：B,C

質問 5：
You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs 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.
B. It is a smallfile tablespace.
C. It is a bigfile tablespace (BFT).
D. It is a dictionary-managed tablespace.
E. It is a default bigfile tablespace.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?
A. Because row IDs may change during the flashback operation
B. Because the table is moved forward and back to a temporary during the flashback opertion
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the object number changes after the flashback operation
正解：A

質問 7：
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.
A. To store the backup information of multiple database
B. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
C. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
D. To restrict the amount of space that is used by the backups
正解：A,C

質問 8：
You executed the following command In Recovery Manager {RMAN):
RMAN>REPORTNEEDBACKUPdays 3;
What is the output of this command?
A. a list of files requiring more than 3 days of archive logs to apply
B. a list of files that require a backup within three days
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them
正解：A
解説: (Topexam メンバーにのみ表示されます)