OracleDBA启动和关闭例程试题及答案
Oracle DBA启动和关闭例程精选试题及答案
Q. 1 : The Databa must be in this mode for the instance to be started
1. MOUNT
2. OPEN
3. NOMOUNT
4. None
3
Q. 2 : When Oracle startups up, what happens if a datafile or redo log file not available or corrupted due to O.S Problems
1. Oracle returns a warning message and opens the databa
2. Oracle returns a warning message and does not open the databa
3. Oracle returns a warning message and starts the databa recovery
4. Oracle ignores tho files and functions normally
2
Q. 3 : The RESTRICTED SESSION system privilege should be given to
女人创业
1. Urs, who need extra curity while transfering the data between client and the rver through SQL*NET or NET8.
2. DBAs, who perform structural maintenance exports and imports the data.
3. All of the above
4. None of the above
是否的近义词
2
Q. 4 : When Starting up a databa, If one or more of the files specified in the CONTROL_FILES parameter does not exist, or cannot be opened
1. Oracle returns a warning message and does not mount the databa
2. Oracle returns a warning message and mounts the databa
3. Oracle ignores tho files and functions normally
4. Oracle returns a warning message and starts databa recovery
1
Q. 5 : Bob tried to shutdown normal, 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 u to force a shutdown on the rver
1. NORMAL
中国经济出版社2. ABORT
3. IMMEDIATE
4. NONE
2
Q. 6 : Tom issued a command to startup the databa. What modes does the Instance and Databa pass through to finally have the databa open
1. OPEN, NOMOUNT, MOUNT
2. NOMOUNT, MOUNT, OPEN
3. NOMOUNT, OPEN, MOUNT
4. MOUNT, OPEN, NOMOUNT
未来的学校作文400字2
Q. 7 : Diane is a new dba and issued a shutdown command while her rver is being u
d. After a while she figures that oracle is waiting for all the urs to sign off. What shutdown mode did she u
1. NORMAL
2. ABORT
3. IMMEDIATE
4. NONE结晶水合物
1
Q. 8 : Which script file creates commonly ud data dictionary views
1. sql.bsq
2. catalog.sql
3. utlmontr.sql
4. catproc.sql
2
Q. 9 : In order to perform a full media recovery, the Databa must be¡
1. Mounted and Opened using RESETLOG option32位怎么升级64位系统
2. Mounted but not Opened
3. Mounted and Opened using ARCHIVELOG option
4. You cannot perform a full media recovery
2
Q. 10 : When is the parameter file read during startup
1. When opening the Databa
2. When mounting the Databa
3. During instance startup
4. In every stage
3
Q. 11 : What is the default mount option for an Oracle Databa
1. SHARED
2. PARALLEL
3. EXCLUSIVE
4. RETRY
3
Q. 12 : You cannot start a databa instance if you are connected to the databa via a shared rver process.
1. TRUE
2. FALSE
3. Depends on the O.S
身边的科学4. Depends on the O.S and Network Protocol
1
Q. 13 : The shutdown mode that requires instance recovery at next startup is
1. NORMAL
2. ABORT
3. IMMEDIATE
4. None of the above
2 : Uncommitted transactions are not rolled back. So the instance needs recovery.Refer to Shutting Down instance.
Q. 14 : Which command only mounts the databa
1. STARTUP OPEN
2. STARTUP NOMOUNT
3. STARTUP FORCE
4. STARTUP MOUNT
3
Q. 15 : Which shutdown mode shuts down the instance but does not go through the dismount pha
1. NORMAL
2. ABORT
3. IMMEDIATE
4. NONE
央视购物网上商城
2
Q. 16 : Which startup mode should you u to start up an instance for maintenance
1. OPEN
2. MOUNT
