| 1: | Which two commands start up the instance and leave the database mounted and normal users unable to log in? [Select two answers] A. startup nomount B. startup restrict C. startup mount D. startup open E. STARTUP read-only
|
| A1: | Answers B and C are correct. STARTUP MOUNT allows the DBA to perform certain types of maintenance that cannot be accomplished when the database is open, and STARTUP RESTRICT opens the database yet allows the DBA to perform other types of maintenance that cannot be accomplished when users are logged in. Both require special privileges to allow the user to connect. Answer A starts the instance but does not mount the database. Answer D is the default and allows any user to log in and manipulate data in the database. Answer E allows users to connect but not to perform any action that would cause a redo to be generated. |
| 2: | If you have a parameter file named initmydb1.ora, and you are logged in as SYS, what would the following code sample accomplish? CREATE SPFILE FROM PFILE; A. It would create the initmydb1.ora SPFILE and place it in the default location. B. It would create the SPFILE initmydb1.ora and put it in a user-defined location. C. It would fail because you don't have any parameters specified. D. It would create the SPFILE initmydb1.ora and place it in the default location.
|
| A2: | Answer D is correct. If you were to issue the command as given while logged in as a user with SYSDBA privileges, you would create the SPFILE spfilemydb1.ora from the existing parameter files. Answer A is incorrect because the initmydb1.ora file is a parameter file, and Oracle won't create the SPFILE with that name unless instructed specifically to do so; however, because no path is specified, the default location for all files is inferred. Answer B is incorrect for the same reason that Answer A is incorrect; Oracle will not create the SPFILE with the same name as the PFILE, and there is no custom location provided for either file. Answer C is incorrect because the syntax is correct as long as the person issuing the command is logged in as someone with SYSDBA privileges; any parameters are optional for the CREATE SPFILE option and are used to allow you to customize your implementation. |
| 3: | Which of the following describes the parameter file? [Select all that apply] A. A binary file editable only by Oracle B. A flat text file alterable in any text editor C. The default file that Oracle looks for first when starting the instance D. A file that is read-only when the instance is started E. A file that contains dynamically alterable parameters for the database F. A file that allows you to customize the parameters that you want to set to the nondefault settings for your instance and database
|
| A3: | Answers B, D, and F are correct. The parameter file, or PFILE, is a simple text file that is alterable in any text editor, is read-only when the instance is starting, and also allows you to customize settings for your database instance. Answer A is incorrect; the SPFILE is the binary file editable only by Oracle. Answer C is incorrect because in Oracle 9i, Oracle first looks for the SPFILE in the default location before it looks for the parameter file. Answer E is incorrect because the PFILE contains static parameters; the SPFILE contains dynamically alterable parameters. |
| 4: | Which of the following are valid places where initialization parameters can be found for use when the database is starting up? [Select all that apply] A. control01.ctl B. initmydb1.ora C. system01.dbf D. spfilemydb1.ora
|
| A4: | Answers B and D are correct. Oracle looks in the SPFILE and the INIT file for its initialization parameters. Answer A is a control file and provides useful information to the database and instance, but does not contain initialization parameters. Answer C is a data file, not a parameter file. |
| 5: | Which is not an initialization parameter used for the Oracle Managed File System? |
| A5: | Answer B is correct. DB_CREATE_REDO_LOG is not a valid OMF initialization parameter. Answer A designates where Oracle should place its data files. Answer C is the location where Oracle puts one copy of multiplexed log and control files. Answer D is the location where Oracle puts another copy of the multiplexed log files. |
| 6: | What two tools can be used for starting up and shutting down the Oracle instance and database? [Select two] A. SQL Plus B. Server Manager C. Enterprise Manager D. PL/SQL
|
| A6: | Answers A and C are both tools that can be used for starting up and shutting down the database. Answer B is incorrect; Server Manager used to be a tool that you could use, but it is no longer available with Oracle 9i. Answer D is incorrect; PL/SQL cannot be used to shut down and start up the database. |
| 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: | Which pair of words complete the following statement? When you issue the STARTUP NOMOUNT command, the Oracle instance is _____________, and the Oracle database is ______________? |
| A8: | Answer A is correct. When you use STARTUP NOMOUNT, the instance is started, and the database is not mounted. Answer B is incorrect because NOMOUNT means that the database has not been mounted. Answer C is incorrect because the database is neither mounted nor opened. Answer D is incorrect because the instance is started, and the database is not mounted. |
| 9: | It seems to be taking longer to start the instance after it has been shut down with the SHUTDOWN ABORT command. Why might this be the case? A. You are anxious to get on to something else, and it just feels longer. B. Oracle has to check to make sure that all the data files, control files, and redo log files are in a consistent state while it is starting back up. C. Oracle just wants you to use SHUTDOWN ABORT in appropriate times and has built in a delay mechanism to make sure that you do. D. It takes Oracle longer to open files after a SHUTDOWN ABORT has occurred.
|
| A9: | Answer B is correct, Oracle must ensure that the database is in a consistent state before it finally opens, and, after a SHUTDOWN ABORT, this can take an extended period of time. Answer A is incorrect; although it may be true that you want to get on to something else, it is also true that Oracle takes longer to restart in a SHUTDOWN ABORT situation. Answer C is incorrect; there is no delay mechanism to make sure that you don't use a shutdown type. Answer D is incorrect. It takes Oracle the same amount of time to open the files; ensuring consistent state takes the extra time. |
| 10: | Under normal circumstance, which of the following SHUTDOWN methods can take the longest time? |
| A10: | Answer D is correct. SHUTDOWN TRANSACTIONAL can take a lot longer if you have many users on the database and they aren't logging out. Answer A is incorrect. ABORT is the fastest because it does no checking; it just stops. Answer B is incorrect. SHUTDOWN IMMEDIATE doesn't wait for anyone, but disconnects users and shuts down gracefully. Answer C is incorrect; there is no SHUTDOWN AT TIME command. |
