Oracle DBA启动和关闭例程试题及答案

1、Oracle DBA启动和关闭例程试题及答案Q. 1 : The Database must be in this mode for the instance to be started1. MOUNT2. OPEN3. NOMOUNT4. None3Q. 2 : When Oracle startups up, what happens if a datafile or redo log file not available or corrupted due to O.S Problems1. Oracle returns a warning message and opens the da

2、tabase2. Oracle returns a warning message and does not open the database3. Oracle returns a warning message and starts the database recovery4. Oracle ignores those files and functions normally2Q. 3 : The RESTRICTED SESSION system privilege should be given to1. Users, who need extra security while tr

3、ansfering the data between client and the server through SQL*NET or NET8.2. DBAs, who perform structural maintenance exports and imports the data.3. All of the above4. None of the above2Q. 4 : When Starting up a database, If one or more of the files specified in the CONTROL_FILES parameter does not

4、exist, or cannot be opened1. Oracle returns a warning message and does not mount the database2. Oracle returns a warning message and mounts the database3. Oracle ignores those files and functions normally4. Oracle returns a warning message and starts database recovery1Q. 5 : Bob tried to shutdown no

5、rmal, Oracle said it was unavailable, and when he tried to starup, oracle said that it was already started. What is the best mode that bob can use to force a shutdown on the server1. NORMAL2. ABORT3. IMMEDIATE4. NONE2Q. 6 : Tom issued a command to startup the database. What modes does the Instance a

6、nd Database pass through to finally have the database open1. OPEN, NOMOUNT, MOUNT2. NOMOUNT, MOUNT, OPEN3. NOMOUNT, OPEN, MOUNT4. MOUNT, OPEN, NOMOUNT2Q. 7 : Diane is a new dba and issued a shutdown command while her server is being used. After a while she figures that oracle is waiting for all the

7、users to sign off. What shutdown mode did she use1. NORMAL2. ABORT3. IMMEDIATE4. NONE1Q. 8 : Which script file creates commonly used data dictionary views1. sql.bsq2. catalog.sql3. utlmontr.sql4. catproc.sql2Q. 9 : In order to perform a full media recovery, the Database must be¡­1. Mounted

8、 and Opened using RESETLOG option2. Mounted but not Opened3. Mounted and Opened using ARCHIVELOG option4. You cannot perform a full media recovery2Q. 10 : When is the parameter file read during startup1. When opening the Database2. When mounting the Database3. During instance startup4. In every stag

9、e3Q. 11 : What is the default mount option for an Oracle Database1. SHARED2. PARALLEL3. EXCLUSIVE4. RETRY3Q. 12 : You cannot start a database instance if you are connected to the database via a shared server process.1. TRUE2. FALSE3. Depends on the O.S4. Depends on the O.S and Network Protocol1Q. 13

10、 : The shutdown mode that requires instance recovery at next startup is1. NORMAL2. ABORT3. IMMEDIATE4. None of the above2 : Uncommitted transactions are not rolled back. So the instance needs recovery.Refer to Shutting Down instance.Q. 14 : Which command only mounts the database1. STARTUP OPEN2. STA

11、RTUP NOMOUNT3. STARTUP FORCE4. STARTUP MOUNT3Q. 15 : Which shutdown mode shuts down the instance but does not go through the dismount phase1. NORMAL2. ABORT3. IMMEDIATE4. NONE2Q. 16 : Which startup mode should you use to start up an instance for maintenance1. OPEN2. MOUNT3. NOMOUNT4. FORCE2 : The da

12、tabase must be closed when you add, drop, rename the redo log files rename the datafiles perform full database recovery. Refer to Starting up an instanceQ. 17 : Which command should you use to open a database for normal use while it is already mounted1. ALTER DATABASE OPEN2. ALTER SYSTEM OPEN DATABA

13、SE3. STARTUP DATABASE4. STARTUP OPEN1Q. 18 : Which shutdown mode waits for all users to disconnect before completing the shutdown1. ABORT2. IMMEDIATE3. FORCE4. NORMAL4Q. 19 : Which mount should you use if multiple instances will be allowed to access the database1. RETRY2. EXCLUSIVE3. PARALLEL4. NONE3Q. 20 : What is the fastest mode to shutdown the