Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z0-034 Exam Practice Test
Examine the parameter settings in your database.
Which statement is correct about the database?
Which statement is correct about the database?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which four resources can directives be specified by using the Oracle Resource Manager?
Correct Answer: A,C,E,F
Vote an answer
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Examine the following command that is used to duplicate a database on the same host:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)
Correct Answer: C,D
Vote an answer
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)
Identify two prerequisites to perform the backups. (Choose two.)
Correct Answer: B,D
Vote an answer
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.)
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.)
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?
How would you achieve this?
Correct Answer: D
Vote an answer
Which three file types are managed by Data Pump jobs?
Correct Answer: B,D,E
Vote an answer
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.
Identify two scenarios in which you must have a recovery catalog.
Correct Answer: B,D
Vote an answer
Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications.
After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?
After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).