最新的Oracle Database 11g: New Features for 9i OCPs - 1Z0-055免費考試真題
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
正確答案: B,C
View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?
There are no data files on raw devices. What is the reason for this error?
正確答案: A
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
正確答案: C
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)
正確答案: C,D
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
正確答案: D
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?
正確答案: C
View the Exhibit to examine the output for the V$DIAG_INFO view.
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
正確答案: A,B,C
Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
正確答案: A,E
View the Exhibit for some of the parameter settings.
You start a session and issue the following command: SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE; What is the outcome of the above command?
You start a session and issue the following command: SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE; What is the outcome of the above command?
正確答案: B
Which two statements are true with respect to the maintenance window? (Choose two.)
正確答案: A,D
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
正確答案: B