1. ASM supports all but which of the following file types? (Choose all that apply).
2.  After executing the command
alter diskgroup disk group2 drop disk dg2a;
you issue the following command from the ASM instance:
Select group_number, count(*) from v$asm_operation; What is the implication if the query against V$ASM_OPERATION returns zero rows?
3. What is the net effect of the following command?
alter diskgroup dgroup1 drop disk abc;
4. Which of the following is not a configurable attribute for an individual disk group?
5. What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?
6. You are peer reviewing a fellow DBA’s backup plan for his NOARCHIVELOG mode database, as shown here:
1. Put the tablespaces in backup mode.
2. Back up the datafiles for all tablespaces
3. Take the tablespaces out of backup mode.
4. Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?
7. Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?
8. When you create a backup control file, where is the resulting file written to?
9. If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?
10. You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost.
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.
11. Which command is used to open the database after an incomplete recovery?
12. Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database?
13. Which of the following files cannot be backed up by RMAN? (Choose all that apply.)
14. Which of the following RMAN structures can data from a datafile span?
15. Which RMAN backup command is used to create the block-change tracking file?
16. A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?
17. What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
18. RMAN provides more granular catalog security through which feature?
19. True of false? You can back up the RMAN recovery catalog with RMAN.
20. What RMAN command must you use before you can back up a database using the recovery catalog?
21. You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
‘C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA’
Using RMAN, how would you respond to this error?
22. While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?
23. What is the purpose of the until change option of the restore command?
24. What is the purpose of the recover command? (Choose all that apply.)
25. What is an obsolete backup set?
26. What is the purpose of the list expired backup command?
27. What is the purpose of the catalog command?
28. Which of the following commands will fail?
29. What are the two different types of database duplication? (Choose two.)
30. When you’re performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)
31. Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)
32. What RMAN command is used to execute a tablespace point-in-time recovery?
33. A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?
34. A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?
35. In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.)
36. Which of the following are true concerning block media recovery? (Choose all that apply.)
37. The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?
38. You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate?
39. Which of the following are not disabled by default?
40. You notice that a job in a chain has not completed on a nonconstrained RAC database.Which of these are valid reasons why that might occur?
41. The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?
42. The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)
43. What are three benefits of using ASM? (Choose three.)
44. What components are present in an ASM instance? (Choose three.)
45. Which of the following is a benefit of ASM fast disk resync?
46. What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?
47. What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?
48. Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?
49. When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instance’s disk groups?
50. When starting up your ASM instance, you receive the following error:
SQL> startup pfile=?/dbs/init+ASM.ora
ASM instance started
Total System Global Area 104611840 bytes
Fixed Size 1298220 bytes
Variable Size 78147796 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for disk group
“DGROUP3”
ORA-15063: ASM discovered an insufficient number of disks for disk group
“DGROUP2”
ORA-15063: ASM discovered an insufficient number of disks for disk group
“DGROUP1”

In trying to determine the cause of the problem, you issue this query:
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- -------------------------_
asm_allow_only_raw_disksboolean FALSE
asm_diskgroups string DGROUP1, DGROUP2, DGROUP3
asm_diskstring string
asm_power_limit integer 1
What is the cause of the error?
51. As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum in data redundancy?
52. You want to migrate your database to ASM, so you’ve done a clean shutdown, made a closed backup of the entire database, noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?
1. STARTUP NOMOUNT
2. ALTER DATABASE OPEN RESETLOGS
3. SQL “ALTER DATABASE RENAME ‘logfile1 path’ TO ‘+dgrp4 ‘“ # plus all other logfiles
4. SWITCH DATABASE TO COPY
5. BACKUP AS COPY DATABASE FORMAT ‘+dgrp4’
6. ALTER DATABASE MOUNT
7. RESTORE CONTROLFILE FROM ‘controlfile_location’
53. How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has not yet completed?
54. To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace. Which of the following is a valid ASM filename for this ASM file?
55. Which background process coordinates the rebalance activity for disk groups?
56. On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2. Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?
57. Which type of database file is spread across all disks in a disk group?
58. How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has already completed?
59. Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation? 60. If you use ALTER DISKGROUP … ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group? 61. You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do? 62. As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.) SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED
63. Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don’t want you to shut down the database to perform the backup. What options are available to you?
64. When performing an online backup, what is the proper order of the following steps?
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.
65. You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?
66. You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?
67. What are the different logging modes available in Oracle Database 11g? (Choose two.)
68. Which is the correct command to put the database in ARCHIVELOG mode?
69. What is the correct order of steps to perform an online database backup?
a. alter database begin backup;
b. alter database end backup;
c. Back up the database datafiles.
d. Back up the archive log files.
e. alter system switch logfile;
70. Which command will result in a trace file being created with the create controlfile command contained in it?
71. Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?
73. Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?
74. Which is not a valid way of backing up a control file?
75. Which of the following parameters defines the location where Oracle should create archived redo logs?
76. True or false? Archived redo logs can be copied to more than one destination by Oracle.
77. What will be the result of the following configuration?
Log_archive_dest_1=’location=c:\oracle\arch\mydb’
Log_archive_dest_2=’location=z:\oracle\arch\mydb’
78. Which view provides information on the backup status of the datafiles in the database?
79. Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?
80. What is the proper command to shut down the database in a consistent manner?
81. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, What will be the result when you issue the command alter database archivelog?
82. Your archive-log destination directory runs out of space. What is the impact of this on the database?
83. How many individual archive-log destination directories are supported by Oracle Database 11g?
84. Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called USERS. The database is still running. Which answer properly describes the order of the steps that you would use to recover from this error?
a. Shut down the database.
b. Take the users_01.dbf datafile offline with the alter database command.
c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all users tablespace-related datafiles from backup media.
e. Issue the recover tablespace users command.
f. Issue the recover datafile users_01.dbf command.
g. Start up the database.
h. Bring the users_01.dbf datafile online with the alter database command.
85. As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?
86. You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed. What would be the appropriate order of operations to correct the situation?
a. Mount the database with the startup mount command.
b. Take the SYSTEM datafile offline with the alter database command.
c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all SYSTEM tablespace–related datafiles from backup media.
e. Issue the recover tablespace SYSTEM command.
f. Issue the recover datafile SYSTEM_01.dbf command.
g. Open the database with the alter database open command.
h. Open the database with the alter database open resetlogscommand.
87. You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?
a. Shut down the database.
b. Restore a control-file copy from backup media.
c. Use the create control file command to create a new control file.
d. Copy the backup control file into place.
e. Create a new copy of the control file from one of the surviving control files.
f. Recover the database using the recover database using backup controlfile command.
g. Start up the database.
88. Which files will you need to perform a full recovery of a database backed up in
NOARCHIVELOG mode? (Choose all that apply.)
89. Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a. Issue a checkpoint.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.
90. What methods of point-in-time recovery are available? (Choose all that apply.)
91.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)
92. What is the proper procedure to recover a lost tempfile?
SQL> startup
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size 1298640 bytes
Variable Size 146804528 bytes
Database Buffers 20971520 bytes
Redo Buffers 2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1

You can choose from the following steps:
a. Restore the database datafiles.
b. Issue the alter database clear unarchived logfile group 1 command.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using point-in-time recovery.
f. Issue the Startup Mount command to mount the database.
g. Back up the database.
Which is the correct order of these steps in this case?
94. A user sends you an email with the following error message:
create table idtable(id number)
*
ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
You can choose from the following steps:
a. Restore the missing database datafiles.
b. Take the missing datafile offline.
c. Shut down the database.
d. Issue the recover tablespace USERS command.
e. Issue the Startup Mount command to mount the database.
f. Bring the USERS tablespace online.
g. Issue the alter database open command.
Which is the correct order of these steps in this case?
95. You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?
96. Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?
97. What methods are available to recover lost control files? (Choose all that apply.)
98. Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:
a. Restore the three database datafiles that were lost.
b. Issue the Startup Mount command to mount the database.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using the recover database command.
f. Recover the datafiles with the recover datafile command.
g. Take the datafiles offline.
Which is the correct order of these steps in this case?
99. You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.
SQL> startup
ORACLE instance started.
Total System Global Area 167395328 bytes
Fixed Size 1298612 bytes
Variable Size 142610252 bytes
Database Buffers 20971520 bytes
Redo Buffers 2514944 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
SQL> alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
What steps must you take to resolve the error?
a. Issue the recover database redo logs command.
b. Issue the Startup Mount command to mount the database.
c. Restore the last full database backup.
d. Perform a point-in-time recovery, applying all archived redo logs that are available.
e. Restore all archived redo logs generated during and after the last full database backup.
f. Open the database using the alter database open resetlogs command.
g. Issue the alter database open command.
100. What does the SCN represent?
101. You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?
102. You are trying to recover your database. During the recovery process, you receive the following error:
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40
ORA-00289: suggestion :
/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file
‘/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_10_4bj6wnqm_.arc’ no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
‘/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
How do you respond to this error? (Choose two.)
103. During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)
104. How is block-change tracking enabled?
105. What type of backup is stored in a proprietary RMAN format?
106. Consider the following command:
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
Control-file a NN uto backups were enabled.
NN The size of backup sets was not restricted.
NN One channel was allocated.
107. Which command creates an image copy?
108. Compressed backups work with which of the following commands?
109. Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?
110. Which of the following best describes a full backup?
111. Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?
112. Which type of backup must be performed first with an incremental backup?
113. Which backup option defines a user-defined name for a backup?
114. Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
a. shutdown immediate from RMAN
c. startup mount from RMAN
d. backup database
e. alter database open
f. backup database plus archivelog delete input
115. Which of the following most closely represents an image copy?
116. Which dynamic view displays the status of block-change tracking?
117. What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?
118. What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?
119. The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
120. Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?
a. backup archivelog all;
b. backup database all;
c. backup controlfile;
d. backup archivelog, database, controlfile delete input;
e. backup database plus archivelog delete input
121. Which of the following statements are true about the BACKUP command? (Choose all that apply.)
122. Which command is used to configure RMAN to perform a compressed backup for every backup executed?
123. You issue the following command:
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?
124. What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
125. What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)
126. Which command do you use to create a recovery-catalog schema?
127. If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)
128. You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?
129. In what order would you execute the following steps to create a recovery catalog?
a. Issue the create catalog command.
b. Create the recovery-catalog database.
c. Create the recovery-catalog user.
d. Grant the recovery_catalog_ownerprivilege to the recovery-catalog user.
e. Issue the register database command from the target database.
130. How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?
131. The RVPC user can do which of the following? (Choose all that apply.)
132. Given the script
create script db_backup_datafile_script
{backup datafile &1, &2 plus archivelog delete input;}
what is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}
133. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is  configured for the ORCL database. (Choose all that apply.)
134. What command would you issue to enable automated backups of control files?
135.Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.
a. restore database;
b. recover database;
c. shutdown immediate
d. startup
e. restore archivelog all;
f. alter database open
136. Which commands are used for RMAN database recovery? (Choose all that apply.)
137. Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?
a. restore controlfile
b. restore database
c. restore spfile
d. recover database
e. alter database open
falter database open resetlogs
138. If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?
139. Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?
140. What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag=’gold_copy’ plus archivelog
tag=’gold_copy’ delete input;
Backup database tag=’silver_copy’ plus archivelog
tag=’silver_copy’ delete input;
141. You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?
142. True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.
143. You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?
a. restorecontrolfile until time
‘09/30/2008:18:00:00’;
b. restore database until time
‘09/30/2008:18:00:00’;
c. restorespfile until time
‘09/30/2008:18:00:00’;
d. recover database until time
‘09/30/2008:18:00:00’;
e. alter database open resetlogs;
f. alter database open;
144. What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?
a. sql ’alter database datafile 4 online’;
b. restore datafile 4;
c. recover datafile 4;
d. sql ’alter database datafile 4 offline’;
e. startup
f. shutdown
145. Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
146. Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)
147. Which of the following does the recover command not do?
148. You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to “roll back” the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)
149. You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?
150. If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_ CORRUPT, what RMAN command would you run to correct the problem? 151. What will be the end result of this set of RMAN commands? shutdown abort startup mount restore datafile 4 until time ‘09/30/2008:15:00:00’; recover datafile 4 until time ‘09/29/2008:15:00:00’; alter database open resetlogs; 152. Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS? 153. David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order? a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN. 154. Which command would you use to determine what database backups are currently availablefor restore? 155. What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media? 156. You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? 157. You want to make sure that your database backup does not exceed 10 hours in length.What command would you issue that would meet this condition? 158. You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape. What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again? 159. You run the following commands: RMAN> list expired backup; RMAN> delete expired backup; What will happen to the backup set pieces associated with the backups that appear in the list expired backup command? 160. Why would you run the delete obsolete command? (Choose all that apply.) 161. What does it mean if a backup is expired? 162. If a backup set is expired, what can you do to correct the problem? 163. How long will this backup be allowed to run? Backup as compressed backupset duration 2:00 minimize load database 164. What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.) Backup as compressed backupset duration 2:00 partial minimize load database ; 165. In what view are you likely to see the following output? SID SERIAL# EVENT SECONDS_IN_WAIT ---------- ---------- ------------------------------ --------------- 121 269 RMAN backup & recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client 8 166. What view might you use to try to determine how long a particular backup will take? 167. What is the impact of the results of the output of the following command? RMAN> report unrecoverable database; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name ---- ----------------------- ----------------------------------- 4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF 168. What does the output on this report indicate? RMAN> report need backup; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of files with less than 1 redundant backups File #bkps Name ---- ----- ------------------------------------------ 5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF 169. What does the minimize load database parameter mean when backing up a database? 170. What is the result of this command? RMAN> Report need backup days 3; 171. Why would you execute the report obsolete command? 172. What information does the report schema command not provide? (Choose all that apply.) 173. If a backup is expired, which of the following is true? 174. True or false: tablespace point-in-time recovery is possible only with RMAN. 175. Which command is used to begin a tablespace point-in-time recovery? 176. When you’re performing active database duplication, a backup of what kind is required? 177. Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database? 178. How many database instances are used during a database-duplication process? 179. What command is used to reset a database to a previous incarnation? 180. What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery? 181. When performing a full database disaster recovery with RMAN, in what order would you execute these steps? a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c. Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f. Open the database with the alter database open command. 182. When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location? 183. Which command would correctly start a TSPITR of the USERS tablespace? 183. True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode. 185. When running the tablespace point-in-time command recover tablespace users until time ‘10/06/2008:22:42:00’ auxiliary destination ‘c:\oracle\auxiliary’; you receive the following error: RMAN-00571: ======================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ======================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name “USERS” What is the likely cause of the error? 186. Which of the following restrictions are not true with respect to tablespace point-in-time recovery? (Choose all that apply.) 187. If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR? 188. You’re performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true? 189. When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter? 190. What is the end result of the following commands? recover tablespace users until time ‘10/06/2008:22:42:00’ auxiliary destination ‘c:\oracle\auxiliary’; sql ’alter tablespace users online’; recover tablespace users until time ‘10/06/2008:20:40:00’ auxiliary destination ‘c:\oracle\auxiliary’; sql ’alter tablespace users online’; 191. Why should you back up a duplicated tablespace after a TSPITR is complete? 192. In what state are the datafiles of a tablespace after a TSPITR has been successfully completed? 193. Which command do you use to generate a report of database incarnations? 194. Which of the following Oracle features utilize the undo tablespace? (Choose all that apply) 195. Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.) Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name, and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list? 197. A user named Arren is executing this query: select table_name, operation, undo_sql from flashback_transaction_query t, (select versions_xid as xid from employees versions between scnminvalue and maxvalue where employee_id = 123) e where t.xid = e.xid; When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem. Which of the following SQL statements will correct this problem? 198. AUM has been retaining about 15 minutes’ worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes’ worth of undo. What is the problem? 199. In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.) 200. Users notify you that their application is failing every time they try to add new records.Because of poor application design, the actual ORA error message is unavailable. What might be the problem? (Choose the best answers.) 201. Which of the following statements best describes Flashback Versions Query? 202. Which pseudo column could you use to identify a unique row in a Flashback Versions Query? 203. Which of the following can be used in conjunction with a Flashback Versions Query to filter the results? (Choose all that apply.) 204. At the request of a user, you issue the following command to restore a dropped table: flashback table “BIN$F2JFfMq8Q5unbC0ceE9eJg==$0” to before drop; Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem? 205. Which of the following statements is true regarding the VERSIONS BETWEEN clause? 206. Which of the following statements is true regarding implementing a Flashback Table recovery? 207. You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456; The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation? 208. Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.) 209. Flashback Database relies on which technologies to recover to a point in time? 210. The _______ writes the Flashback Database logs in the flash recovery area. 211. Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.) 212. When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.) 213. To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do? 214. Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.) 215.Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST? 216Which of these formats represents the correct hierarchy for the ADR? 217. Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.) 218. Which of the following tasks does the tool Incident Packaging Service (IPS) perform? 219. Choose the correct order to package and upload data for an incident to Oracle Support. 220. Which of the following is not an advantage of block media recovery (BMR)? 221. Which of the following methods can be used to detect block corruption? 222. Which of the following are correct about block media recovery? (Choose all that apply.) 223. While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block? 224. To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow? 225. When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values? 226. To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take? 227. Which of these appropriately describes the results of a manual SQL Tuning Advisor task? 228. Which of the following is a potential performance tuning recommendation from the SQL Access Advisor? 230. Which of the following represents the correct sequence of events for Database Replay? 231. Which of these recommendations should be followed before capturing a workload? (Choose all that apply.) 232. Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database? 233. Performance divergence indicated in the Workload Replay report is most likely due to what? 234. Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter? 235. By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options? 236. For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features? 237. To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.) 238. When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect? 239. Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.) 240. In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management? 241. Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.) 242. When tuning Automatic PGA Memory Management, which of the following views will provide the information specified? 243. To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value? 244. Which of the following describes how a distributed resumable transaction behaves? 245. Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view? 246. Which of the following are included in a transportable tablespace set? (Choose all that apply.) 247. The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.) select d.platform_name “Source”, t.platform_name “Compatible Targets”, endian_format from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v\$database d
where d.platform_name = t.platform_name);
248. When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?
249. Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
250. Which of the following supplied functions is used to identify external tables, directories, and BFILES?
251. Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?
252. Which of the following options describes Segment Shrink?
253. For which of the following can you use Segment Shrink? (Choose all that apply.)
254. When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?
255. Which of these represent the main components of Database Resource Manager? (Choose all that apply.)
256. Every resource plan must contain an allocation to which consumer group?
257. Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?
258. Within a resource-plan definition, what differentiates a top-level plan from a subplan?
259. When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?
260. Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
261. Which of the following is not a valid calendaring syntax element?
262. Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)
263. A schedule defined entirely within the confines of a Scheduler job object is known as a(n)
264. Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)
265. What is the default value for the ENABLED attribute of a job or program when it is created?
266. To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
267. Consider the following code snippet:
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => ‘lne_job1’,
attribute => ‘job_priority’,
value => 1);
END;
/
If this code were executed, which of the following statements would be true?
268. Which of the following calendaring syntax expressions would evaluate to the last day of every month?
269. Which of the following tasks is not performed by the job coordinator?
270. Which of the following objects can be directly referenced by a window object? (Choose all that apply.)
271. Which of the following are valid program types for a lightweight job? (Choose all that apply.)
272. Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?
273. Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)
274. What is the danger associated with stopping a running job by using the STOP_JOB procedure?
275. If a job references a schedule that has been disabled, what will be the result?
276. When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)
277. Which of the following is true about job chains?
278. If two windows overlap, which window attribute will determine whether one should be chosen over the other?
279. Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?
280. What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)
281. Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)
282. The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)
283. Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?
284. Which of the following datatypes store time-zone information in the database?
285. Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)
286. NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle’s order of precedence:
a. Default setting
b. Client environment variable
c. Explicit ALTER SESSION statement
d. Inside SQL function
e. Server initialization parameter
287. What can you determine about the following linguistic sorts based only on their names?
1. GERMAN
2. FRENCH_M
288. In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?
289. Automatic data conversion will occur if which of the following happens?
290. Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
291. Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?
292. Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?
293. Which is not a valid locale definition file type?
294. How many different calendars does Oracle 11g support?
295. Which NLS parameter directly governs linguistic searches?
296. True or false? Case-insensitive sorts are always accent insensitive by default.
297. What is the name of the file that identifies the set of available locale definitions?
298. Which of the following is not a valid linguistic sort element?