OracleDBA启动和关闭例程试选题
来源:互联网 发布:小说日文翻译软件 编辑:程序博客网 时间:2024/05/29 07:23
OracleDBA启动和关闭例程试选题
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
q. 6 : tom issued a command to startup the database. what modes does the instance and database pass through to finally have the database open
1. open, nomount, mount
2. nomount, mount, open
3. nomount, open, mount
4. mount, open, nomount
2
q. 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 users to sign off. what shutdown mode did she use
1. normal
2. abort
3. immediate
4. none
1
q. 8 : which script file creates commonly used 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 database must be?-
1. mounted and opened using resetlog option
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 database
2. when mounting the database
3. during instance startup
4. in every stage
3
- OracleDBA启动和关闭例程试选题
- OracleDBA启动和关闭例程试选题
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- main函数和启动例程
- oracle启动和关闭
- 数据库启动和关闭
- 启动和关闭 mysql
- oracle启动和关闭
- TimesTen启动和关闭
- oracle启动和关闭
- 启动和关闭数据库
- Linux进程通信---学习笔记(二)
- 职场电邮礼仪
- 解决Ubuntu启动时的Routine check检查时间过长
- C#读取文本文件和C# 写文本文件
- 如何应对ORACLE数据库的部分面试题目
- OracleDBA启动和关闭例程试选题
- 基础IRP 和I/O Stack location 的关系
- OracleDBA启动和关闭例程试选题
- delphi执行一个外部程序,当外部程序结束后,delphi程序立即响应
- 多表连接查询
- 忆龙2009:WLAN IDS介绍
- 软件工程
- freemarker eval 的作用
- 毕业半年了