1Z0-032 - Oracle9i Database: Fundamentals II

Go back to Oracle

Example Questions

You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery- You receive this prompt: ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion : /disk1/archive/arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} What is the correct response? Which statement is true regarding RMAN components? Which of the following would you use to enable automatic media recovery for a database? You are working on a database in which due to an instance failure all the transactions are terminated. As soon as the database opens, you want to access a row that is locked by a transaction, which was terminated. You want to access the row without waiting for all parts of the terminated transaction to be rolled back. How do you configure this phase of instance recovery? You database runs in ARCHIVELOG mode, and is backed up every Sunday. The archive logs are copied to tape, and then removed every night. The database consists of 10 redo log groups. On Wednesday afternoon the server has an unscheduled shutdown. Upon restarting the database, corruption in the SYSTEM tablespace data file is reported. You also notice that there have been 17 log switches since Sunday. Which solution should you use in order to minimize both down time and data loss? What should you look at first to compute the number of undo blocks written per second to disk? When importing a table into a database, the import process performs these tasks: 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap, functional, and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed? You are working on the PDDB database. You find that a tablespace is full, so you add a data file to the tablespace. You are using RMAN to perform backup and recovery of the database. You used recovery catalog to connect to RMAN and executed the following command to perform the backup: RMAN>backup database; Which statement regarding this command is true? Which of the following dynamic view would you query to identify the online CURRENT redo log group? Which of the following file should be configured for dynamic service registration? You are archiving to four destinations as shown below: LOG_ARCHIVE_DEST_1 = 'LOCATION = /DB01/u01/archive' MANDATORY LOG_ARCHIVE_DEST_2 = 'LOCATION = /DB01/u02/archive' LOG_ARCHIVE_DEST_3 = 'LOCATION = /DB01/u03/archive' MANDATORY LOG_ARCHIVE_DEST_4 = 'LOCATION = /DB01/u04/archive' You want to ensure that the archiver successfully archives to at least three of these locations. However, you do not want the system to halt if it cannot write to all four destinations. Which option would you use to accomplish this task? Some data storage and transfer media have fixed-length physical records. When the data records are short, more then one can be stored in a single, physical record to use the storage space efficiently. Consider this data: 1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas Which two statements can you use to load the data into the EMP table? (Choose two) Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible? Which one of the following statements about the TNSPING utility is correct? Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository? You are performing an online backup of a data file. During the backup, the database writer is in the middle of updating a block when RMAN tries to read the same block. What would RMAN do? Which of the following shut down options should not be used before performing a consistent whole database backup? You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.) For which two tasks would it be best NOT to use the utility SQL*Loader? (Choose two) You are working on a database and instance failure has occurred due to a power outage. You want to bring the instance up. From what point in the redo log file does instance recovery begin and where does it end? Using the command shown here, what time format must you specify to recover the database until a point-in-time? SQL> RECOVER DATABASE UNTIL TIME '<time format>'; Which initialization parameter must you set to enable automatic archiving? What is the new Oracle Shared Server? Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance? Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three) Which statement is true regarding the Archiver (ARCn) process, archived log files, and recovery? When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two) In a shared server configuration, which two describe the actions that the listener can take to service a client request? (Choose two) You experienced a loss of data files in your database. You did not lose any of your control files. You are going to use RMAN to restore and recover the database. Currently, your instance is shut down. Which sequence of commands is correct to restore and recover your database? You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types? You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT '/BACKUP/df_%d_%s_%p.bus' DATABASE filesperset = 2; Which components are included in the backup? Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords? Examine the statement: SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully? (Choose two) You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database: SET UNTIL TIME = '2000-12-09:11:44:00'; RESTORE DATABASE; RECOVER DATABASE; How should the commands be executed? You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback? (Choose two) You can control instance recover performance by setting parameters to define targets for ______. When you use the Oracle Net Configuration Assistant to specify the naming method, which file is updated? You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that users are unable to access the USERS tablespace. On investigation, you find that all the data files that belong to the USERS tablespace are corrupted and you do not have any logical back up of the database. Which two options could you use to recover the tablespace along with the data, without affecting other data files? (Choose two.) Your database is configured for shared server. A particular client requires a dedicated server. Select two actions that you can perform to configure the client to use a dedicated server. (Choose two.) Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this? Which of the following packages maintains information in the recovery catalog? Which of the following statement is incorrect regarding RMAN? In which three cases does a checkpoint occur? (Choose three) Which statement regarding the RMAN repository stored in the control file is true? You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message: CREATE TABLESPACE tbsl; ORA-02199: missing DATAFILE/TEMPFILE clause oerr ora 2199 02199, 00000, "missing DATAFILE/TEMPFILE clause" *Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action: specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace? You are configuring a listener by using Oracle Net Manager. You want the listener to be stopped by an authorized user only. What would you do? Which statement correctly describes RMAN backup and recovery? In your database, there is a large transaction modifying very crucial data. A hardware problem caused instance failure and the instance went down before all the writes to the data files were completed. Which statement is true? Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file? Online index rebuild functionality has been extended to include which four index structures? (Choose four)

Study Guides