Oracle 1z0-034 問題集

質問 1：
You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.
A. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups.
B. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.
C. when there are already three backups, for the fourth backup RMAN removes the oldest backup.
D. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?
A. the RMAN REPORT command
B. the DBNEWID utility
C. the CHECK_OBJECT procedure of the DBMS_REPAIR package
D. the ANALYZE command
E. the DBVERIFY utility
F. the RMAN CROSSCHECK command
正解：E

質問 3：
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
A. Automatic checkpoint tuning will be enabled.
B. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
D. The MTTR advisor will be disabled.
正解：A,C

質問 4：
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 メンバーにのみ表示されます)

質問 5：
You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
A. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
B. ALTER TABLESPACE adtbs RESIZE 20G;
C. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
D. ALTER TABLESPACE adtbs ADD DATAFILE;
E. ALTER TABLESPACE adtbs AUTOEXTEND ON;
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 メンバーにのみ表示されます)

質問 7：
Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN. Which two statements are true about the backup of the USERS tablespace? (Choose two.)

A. It will not be backed up as a part of database backup on Wednesday.
B. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
C. It will be backed up as a part of database backup on Tuesday.
D. It will be backed up as a part of database backup on Friday.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Refer to the exhibit.

Examine the Following commands and their output:
View the Exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row?
A. Supplemental logging is not enabled for the database.
B. The database is not configured in ARCHIVELOG mode.
C. The changes made to the table are not committed.
D. Flashback logging is not enabled for the database.
正解：C