最新的Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z0-034免費考試真題
問題1
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
正確答案: C,F
問題2
The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?
正確答案: E
問題3
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題4
Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?
正確答案: B
問題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.)
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.)
正確答案: B,E
說明：（僅 VCESoft 成員可見）
問題6
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?
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?
正確答案: C
問題7
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
正確答案: A,D
問題8
Evaluate the following block of code:
What is the outcome of the above code?
What is the outcome of the above code?
正確答案: A
