博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

2007年6月20日

Oracle DBA 用户管理试题

摘要： 注：答案在选项后面 Q. 1 : The default tablespace clause in the create user command sets the location for 1. Database Objects created by the user 2. Temporary Objects Created By the User 3. System Ob... 阅读全文

posted @ 2007-06-20 17:46 徐正柱- 阅读(399) 评论(0) 推荐(0)

Oracle DBA 审计数据库试题

摘要： Q. 1 : What feature in oracle allows you to monitor Suspicious Activity on the Datbase 1. Replication 2. Auditing 3. Monitoring 4. Tuning Q. 2 : Auditing can be turned on by setting this... 阅读全文

posted @ 2007-06-20 17:40 徐正柱- 阅读(332) 评论(0) 推荐(0)

Oracle DBA启动和关闭例程试题

摘要： 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 n... 阅读全文

posted @ 2007-06-20 17:38 徐正柱- 阅读(563) 评论(0) 推荐(0)

Oracle DBA创建数据库试题

摘要： Q. 1 : This symbol, When you put infront of a line in the parameter file, signifies a comment 1. $ 2. @ 3. # 4. ! 3 Q. 2 : When you change a parameter value in the parameter file, when wil... 阅读全文

posted @ 2007-06-20 17:37 徐正柱- 阅读(348) 评论(0) 推荐(0)

Oracle DBA回滚段管理试题

摘要： Q. 1 : What system privilege is required to create a rollback segment ? 1. Create database 2. Create rollback segment 3. Alter database 4. Create segment 2 Q. 2 : Oracle recommends ... 阅读全文

posted @ 2007-06-20 17:35 徐正柱- 阅读(309) 评论(0) 推荐(0)

Oracle DBA 逻辑备份试题

摘要： Q. 1 : What option of Exporting allows quicker data extractions 1. Grants =y 2. Consistent =y 3. Direct = true 4. Direct=y 4 : Direct=y option bypasses the SQL layer to allow quicker data ex... 阅读全文

posted @ 2007-06-20 17:33 徐正柱- 阅读(411) 评论(0) 推荐(0)

Oracle DBA结构试题1

摘要： Q. 1 : Physical Disk Resources in an Oracle Database are 1. Control Files 2. Redo Log Files 3. Data Files 4. All of the above 4 Q. 2 : What is a Schema 1. A Physical Organization of Obje... 阅读全文

posted @ 2007-06-20 17:30 徐正柱- 阅读(432) 评论(0) 推荐(0)

Oracle DBA 存储试题

摘要： Q. 1 : Oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows. 1. True 2. False 2 Q. 2 : Which of the following... 阅读全文

posted @ 2007-06-20 17:29 徐正柱- 阅读(352) 评论(0) 推荐(0)

一份DBA试题

摘要： 一份DBA试题注：以下题目，可根据自己情况挑选题目作答，不必全部作答您也可以就相关问题直接找负责面试人员面述而不笔答 一：SQL tuning 类1:列举几种表连接方式 hash join/merge join/nest loop(cluster join)/index join 2:不借助第三方工具，怎样查看sql的执行计划 set autot on explain plan set st... 阅读全文

posted @ 2007-06-20 17:24 徐正柱- 阅读(657) 评论(0) 推荐(0)

调用存储过程示例

摘要： 问：我建了一存储过程，名为：may_user,传入参数为：@user varchar(20),@passw varchar(20);不知在asp.net下如何调用它？谢______________________________________________________________________________________________答1：SqlConnection nwin... 阅读全文

posted @ 2007-06-20 10:38 徐正柱- 阅读(373) 评论(0) 推荐(0)