| 1: | Your database currently has one control file. You, after careful consideration, decide that adding two more control files will provide better protection against a single point of failure at the control file level. To accomplish this, you edit the initSID.ora file to point to the new location. control_files='/mydatabases/mydb1/control_01.ctl', '/mydatabases02/mydb1/control_02.ctl', '/mydatabases03/mydb1/control_03.ctl'
You shut down your database normal and copy the control files to the new location. Cp /mydatabases/mydb1/control_01.ctl /mydatabases2/mydb1/control_02.ctl Cp /mydatabases/mydb1/control_01.ctl /mydatabases3/mydb1/control_03.ctl
When you restart your database using the altered PFILE, you receive the error ORA-00205: error in identifying control file
You look in the alert log, and determine that you specified the incorrect path for the control files. Which steps are required to resolve the problem and restart the database? A. Connect Internal. Shut down the database. Start up the database in NOMOUNT mode. Use the ALTER SYSTEM SET CONTROL_FILES command to correct the error. Shut down the database. Start up the database.
B. Connect as SYSDBA. Shut down the database. Start up the database in NOMOUNT mode. Use the ALTER SYSTEM SET CONTROL_FILES command to correct the error. Shut down the database. Start up the database.
C. Connect as SYSDBA. Shut down the database. Start up the database in MOUNT mode. Use the ALTER SYSTEM SET CONTROL_FILES command to correct the error. Shut down the database. Start up the database.
D. Connect as SYSDBA. Shut down the database. Fix the errant entries in the initSID.ora file. Start up the database.
|
| A1: | Answer D is correct. The questions states that you are using initSID.ora, meaning that you are using the PFILE. It does not indicate that there is an SPFILE for the database. Therefore, you need to fix the initSID.ora and restart the database. Answer A is incorrect because Connect Internal is not a valid way of connecting to an Oracle 9i database. Answer B is incorrect because you have not been told that you have an SPFILE connected to the database. Answer C in incorrect because you will not be able to MOUNT the database without valid paths to the control files. |
| 2: | You have decided that you want to use Oracle Managed Files for all the files in your database. Which parameter must you supply to allow Oracle to create and name the control files automatically? |
| A2: | Answer B is correct. The parameter that needs to be specified for Oracle to automatically create and name the control files in an OMF database is DB_CREATE_ONLINE_LOG_DEST_n. Answer A is incorrect because the DB_CREATE_FILE_DEST parameter specifies the location of the data files in the database for an OMF database. Answer C is incorrect because it is not a valid parameter. Answer D is incorrect because MAXHISTORY has nothing to do directly with an OMF database. |
| 3: | Which of the following statements provides information about the number, names, status, and location of the control files in your database? A. SELECT NAME, STATUS, LOCATION FROM V$PARAMETER; B. SELECT NAME, STATUS, LOCATION FROM V$CONTROLFILE; C. SELECT NAME, STATUS, LOCATION FROM V$CONTROL_FILES; D. SELECT NAME, STATUS, LOCATION FROM DICTIONARY;
|
| A3: | Answers B is correct. V$CONTROLFILE provides you with the status and name of the control file. You will have to count the number of rows returned to realize how many control files you have (although the query could be altered to provide this information), and the name includes the complete path to the control files, giving you their location. Answer A is incorrect because V$PARAMETER gives you only the name of the control file. Answer C is incorrect because V$CONTROL_FILES is not a valid data dictionary view. Answer D is incorrect because the DICTIONARY view only provides information on tables and their comments. |
| 4: | Which of the following statements are true about control files? [select all that apply] A. Control files can be multiplexed up to eight times. B. Control files are read at the MOUNT stage of startup. C. Control files are read at the NOMOUNT stage of startup. D. Control files are text files that should be edited in a text editor to define the desired state of the physical database. E. Control files maintain the integrity of the database. F. Loss of all the control file requires that the database be recovered. G. The control file cannot be re-created after database creation.
|
| A4: | Answers A, B, E, and F are correct. You can multiplex the control files up to eight times (and should multiplex them at least twice). The control files are read during the MOUNT stage of database startup. They are files tasked with maintaining the integrity of the database and, therefore, the loss of the only available (or all available) control file requires that the database be recovered. Answer C is incorrect; the control file is not read until the MOUNT phase of the startup. Answer D is incorrect. You should never attempt to alter the control file with a text editor; only Oracle should alter the contents of the control file. Answer G is incorrect; you can create the control file either from the file resulting from the ALTER DATABASE BACKUP CONTROL FILE TO TRACE command or through the CREATE CONTROLFILE command. |
| 5: | You have added several tablespaces to your database. Which of the following are valid ways to back up your control file to reflect these new changes? [select all that apply] A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE B. ALTER DATABASE BACKUP CONTROLFILE C. CREATE CONTROLFILE <controlfile name> D. DELETE CONTROLFILE <controlfile name> E. ALTER SYSTEM BACKUP CONTROL FILE to MYBACKUP_CONTROLFILE_01.ctl F. ALTER SYSTEM BACKUP CONTROLFILE TO TRACE
|
| A5: | Answer A is correct. ALTER DATABASE BACKUP CONTROLFILE TO TRACE is the only valid included command to back up the control file. Answer B is incorrect because it is syntactically incorrect, and it will expect you to tell it where to back it up to and what filename to use as the backup's name. Answer C will create a control file if you provide the correct parameters, but will not back up the current control file. Answer D will delete a control file, not back up the control file. Answer E is incorrect because BACKUP CONTROL FILE needs to be accompanied by the ALTER DATABASE command, not the ALTER SYSTEM command. Answer F is incorrect because the BACKUP CONTROLFILE TO TRACE needs to be accompanied by the ALTER DATABASE command, not the ALTER SYSTEM command. |
| 6: | After which of the following statements should you perform a backup of the control file? [select all that apply] |
| A6: | Answers B, E, F, and G are the correct answers. You should back up the control file after creating the database, creating a tablespace, adding a data file to an existing database, and making a tablespace read-only or read-write. Answer A is incorrect; nothing stored in the control file concerns the creation of users. Answer C is incorrect; nothing stored in the control file concerns creation of indexes. Answer D is incorrect; nothing stored in the control file concerns creation of tables. |
| 7: | You are creating a new control file to replace ones that have been deleted. Which of the following commands is the appropriate way to start the database? A. STARTUP NOMOUNT B. STARTUP READ-ONLY C. STARTUP OPEN D. STARTUP
|
| A7: | Answer A is correct. STARTUP NOMOUNT allows you to create a new control file without worrying about it attempting to access or open data files. Answer B is incorrect because the data files and control files have to be accessible and open for the queries in a read-only database to be processed. Answer C is incorrect because the control file has to be available to open the database. Answer D is simply a restatement of answer C and is therefore incorrect for the same reasons. |
| 8: | You have not multiplexed your control file. You are having intermittent problems with the drive on which the control file is located, so you decide to multiplex your control file onto multiple disk drives to head off catastrophe. You have taken the following steps: 1. | Make a copy of your control file using your operating system command.
| 2. | Add the new filename to the list of control files parameters in your PFILE.
| 3. | Shut down the instance.
| 4. | Start up the command to restart the instance.
|
Why does the mount of the database fail? A. You used the OS command to copy the control file. B. You copied the control file with the database up and operating. C. You should have started the database with the force option. D. You added the new control filename to the CONTROL_FILES parameter to the initSID.ora file before you shut down the database.
|
| A8: | Answer B is correct. The control file should not be copied until the database is shut down either immediate, normal, or transactional, when the database is consistent. Answer A is incorrect; you should use the OS copy command to copy the control file after the database is shut down. Answer C is incorrect because this only causes the instance to read the inconsistent control file in one step instead of two. Answer D is incorrect because the init.ora file is read from only when the database is started, so it doesn't matter when the text file is edited. |
| 9: | Keeping multiple active copies of a control file for redundancy purposes is called_________. A. Overkill B. Multiplexing C. Control file groups D. Redo log groups
|
| A9: | Answer B is correct; this is known as multiplexing. Answer A is incorrect; not only is it not known as overkill, it is wise management. Answer C is incorrect; there is no such thing as control file groups. Answer D is incorrect; these are control files, not redo log files. |
| 10: | Which of the following are ways that Oracle identifies how Oracle knows where the control files are supposed to be maintained? A. By the CONTROL_FILES parameter B. By the BACKGROUND_DUMP_DEST parameter C. In the V$DATABASE view D. Oracle just knows where they are
|
| A10: | Answer A is correct; the CONTROL_FILES parameter controls where the control files are placed. Answer B is incorrect; BACKGROUND_DUMP_DEST is where the alert logs and the background trace files are placed. Answer C is incorrect; the V$DATABASE view provides much information about control files but not their location. Answer D is incorrect; you have to tell Oracle where things are before it knows. |
