oracle database 10g:administration ii

1.Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two.)
A.drop and re-create the index
B.coalesce the ORDERS_IND index
C.coalesce the INDEXES tablespace
D.drop and re-create the ORDERS table
E.rebuild the index online and move it to another tablespace
Correct:B E
2.You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME '2004-08-05:12:10:03' 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?
A.A user table was lost at the specified time.
B.A redo log file was lost at the specified time.
C.The backup control file is on a faster disk than the current one.
D.The current control file has a different path compared with the intended time of recovery.
E.The current control file does not match the physical structure of the database at the intended time of recovery.
Correct:E
3.Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)
A.Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
B.You can flash back a dropped table provided row movement has been enabled on the table.
C.If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.
D.When you execute the DROP TABLESPACE INCLUDING CONTENTS command, the objects in the tablespace are placed in the recycle bin.
E.When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.
F.If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
Correct:A C
4.In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager (RMAN)?
A.The backup would be retained on the media for 31 days.
B.The backup would be maintained in the recovery catalog for 31 days.
C.The backup metadata would be retained in the control file for 31 days.
D.The backup metadata would be maintained in the recovery catalog for 31 days.
E.Automatic backups of the control file will be retained in the flash recovery area for 31 days.
Correct:C
5.You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RMAN> REPORT NEED BACKUP days 3; What would be the output of this command?
A.a list of files that require a backup within three days
B.a list of files that have not been backed up for 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 and may need a backup after three days
Correct:B
6.There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?
A.the DBNEWID utility
B.the DBVERIFY utility
C.the ANALYZE command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the CHECK_OBJECT procedure of the DBMS_REPAIR package
Correct:B
7.You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?
A.restore the tablespace from the backup
B.restore the tablespace from the backup, and then perform an incomplete recovery
C.restore the tablespace from the backup, and then apply all the redo information
D.restore all the data files in the database, and then perform an incomplete recovery
Correct:A
8.You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?
A.perform point-in-time recovery to recover the table
B.recover the table by using the Flashback Table feature
C.restore the entire database from the most recent backup and open it
D.use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
Correct:A
9.Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? (Choose three.)
A.archival
B.log writer
C.database writer
D.system monitor
E.process monitor
F.change tracking writer
Correct:A B C
10.In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct? (Choose two.)
A.The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B.The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C.The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D.If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
E.If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
Correct:A E
11.Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process? (Choose two.)
A.open the database with the RESETLOGS option
B.open the database with the RESTRICTED option
C.recover all the data files to the same system change number (SCN)
D.recover to the required SCN only that data file in which the error occurred
Correct:A C
12.The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?
A.DB_CACHE_SIZE only
B.DB_8K_CACHE_SIZE only
C.DB_4K_CACHE_SIZE only
D.SGA_TARGET and DB_4K_CACHE_SIZE
E.DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
F.DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
Correct:C
13.View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the Flashback Versions Query, you find that the first two updates are not listed. What could be the reason?

A.The row movement is not enabled on the table.
B.The first two updates were not explicitly committed.
C.The Flashback Versions Query lists only the most recent update.
D.The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
Correct:D
14.In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?
A.Oracle Migration Assistant
B.Recovery Manager (RMAN)
C.Oracle Data Pump Export and Import
D.conventional Oracle Export and Import
E.operating system utilities to copy the files to the ASM instance
Correct:B
15.You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
A.loss of a tempfile
B.loss of a system data file
C.loss of one of the control files
D.loss of one of the tablespaces
E.loss of a member from each redo log group
F.loss of the only member of an unarchived redo log group
Correct:F
16.Consider the following configuration: /devices/D1 is a member of disk group dgroupA. /devices/D2 is a member of disk group dgroupA. /devices/D3 is a member of disk group dgroupA. You plan to add a new disk, /devices/D4, to the disk group dgroupA. You execute the following command: SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*'; Which task would be accomplished by the command?
A.The command adds the new disk, D4, to the disk group.
B.The command would result in an error because there is no disk by the name "/devices/D*".
C.The command will be ignored because disks starting with "D" are already members of the disk group.
D.The command would result in an error because no wildcard characters can be used in the disk name.
E.The command first detaches all the member disks starting with "D," and then reattaches them including the new disk.
Correct:A
17.In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup? (Choose two.)
A.shut down and restart the instance
B.add new tempfiles to the temporary tablespaces after recovery
C.perform a media recovery and open the database with the RESETLOGS option
D.perform a media recovery and bring the database to NOARCHIVELOG mode
Correct:B C
18.You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read-only. On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?
A.configure a default device for RMAN backups
B.temporarily disable the retention policy for RMAN backups
C.configure automatic channel allocation for RMAN backups
D.use the CONFIGURE command to reconfigure the recovery window to 60 days
Correct:B
19.You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?
A.LogMiner
B.the DBNEWID utility
C.the DBVERIFY utility
D.the ANALYZE command
E.the RMAN REPORT command
F.the RMAN CROSSCHECK command
G.the RMAN BLOCKRECOVER command
Correct:D
20.In which two conditions are resumable statements suspended? (Choose two.)
A.when a user session is terminated
B.when a user exceeds the space quota
C.when a user manually suspends the statement
D.when the maximum extents of a segment is reached
E.when a table that is being accessed by the current transaction is not found
Correct:B D
21.Consider the recovery steps in each of the cases given below: Case 1: 1 Shut down the database and perform a backup. 2 Restore all the data files. 3 Mount the database. 4 Recover the database. 5 Without applying all the redo log files, open the database using the RESETLOGS option. 6 Back up the database. Case 2: 1 Shut down the database and perform a backup. 2 Restore only the data files of the tablespace where user error damaged the data. 3 Mount the database. 4 Recover the database. 5 Open the database with the RESETLOGS option. 6 Back up the database. Case 3: 1 Shut down the database 2 Restore the data files 3 Open the database 4 Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?
A.only case 1
B.only case 2
C.only case 3
D.case 1 and 2
E.case 2 and 3
F.case 1 and 3
G.all cases: case 1, case 2 and case 3
Correct:A
22.You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?
A.It would return information regarding only the last committed transaction.
B.It would return only the active transactions in all the undo segments in the database.
C.It would return only the committed transactions in all the undo segments in the database.
D.It would return both active and committed transactions in all the undo segments in the database.
E.It would return information regarding the transactions that began and were committed in the last 30 minutes.
Correct:D
23.You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*'; Which statement is true?
A.The location can be changed only if the flash recovery area is empty.
B.After executing the command, all new flash recovery area files will be created in the new location.
C.The command will generate an error because you cannot change the flash recovery area while the database is open.
D.All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
Correct:B
24.You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)
A.DATE
B.TIMESTAMP
C.INTERVAL YEAR TO MONTH
D.INTERVAL DAY TO SECOND
E.TIMESTAMP WITH LOCAL TIME ZONE
Correct:B E
25.Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two.)
A.You find that one of the redo log members in each redo log group is lost.
B.You find that a data file that belongs to the USERS tablespace is damaged.
C.You find that a data file that belongs to the SYSTEM tablespace is damaged.
D.You find that the current redo log group is damaged and is not available for recovery.
E.You realized while performing a recovery that an archived redo log file needed for recovery is lost.
Correct:D E
26.You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?
A.back up the control file to trace
B.bring database to the MOUNT state
C.open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
D.set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
Correct:C
27.In your production database, you observe that users' transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? (Choose three.)
A.CPU usage
B.degree of parallelism
C.number of open cursors
D.number of sorts performed
E.idle time for blocking sessions
F.number of disk I/O operations performed
G.number of memory I/O operations performed
Correct:A B E
28.Identify four uses of the Oracle Scheduler. (Choose four.)
A.enables you to execute jobs in a clustered environment
B.enables you to schedule the execution of jobs based on time
C.enables you to automate the management of the jobs that are created using the DBMS_JOB package
D.enables Oracle database to do patches according to a DBA-defined schedule
E.enables you to create a job that makes use of saved programs and schedules
F.enables you to periodically execute operating systemscript files located on the same server as the database
G.enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
Correct:A B E F
29.You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?
A.drop the read-only tablespace and re-create the tablespace after recovery
B.take data files from the read-only tablespace offline before performing a recovery
C.perform a recovery; status of the tablespace in control file will be changed automatically
D.recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
Correct:B
30.You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
A.backup pieces
B.control file autobackups
C.copies of all the parameter files
D.trace file generated using BACKUP CONTROLFILE TO TRACE
Correct:A B