OracleDBA啟動和關(guān)閉例程筆試題
q. 1 : the database 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 database
2. oracle returns a warning message and does not open the database
3. oracle returns a warning message and starts the database recovery
4. oracle ignores those files and functions normally
2
q. 3 : the restricted session system privilege should be given to
1. users, who need extra security while transfering 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 above
4. none of the above
2
q. 4 : when starting up a database, 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 database
2. oracle returns a warning message and mounts the database
3. oracle ignores those files and functions normally
4. oracle returns a warning message and starts database 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 use to force a shutdown on the server
1. normal
2. abort
3. immediate
4. none
2
【OracleDBA啟動和關(guān)閉例程筆試題】相關(guān)文章:
Oracle DBA啟動和關(guān)閉例程精選試題及答案09-23
OracleDBA面試題匯總10-12
OracleDBA回滾段管理試題08-12
盤點國外公司的OracleDBA試題08-12
PostgreSQL服務(wù)器啟動及關(guān)閉方法10-01
如何打開和關(guān)閉Oracle游標(biāo)10-12
華為2017筆試題08-16
360筆試題目07-11
爵士舞蹈彈力例程的學(xué)習(xí)步驟和注意事項10-04
華為2017筆試試題08-10