优酷-数据库类：笔试题目1（最全）

不定项选择：
一、9i中的数据保护模式包括有？
A. MAXIMIZE PROTECTION
B. MAXIMIZE AVAILABILITY
C. MAXIMIZE QUANTITY
D. MAXIMIZE PERFORMANCE

二、SQL Server支持哪几种备份？
A. 数据库备份
B. 事务日志备份
C. 差异备份
D. 文件和文件组备份

三、SQL语言的数据操纵语句包括SELECT、INSERT、UPDATE、DELETE等。其中最重要的，也是使用最频繁的语句是（） 。
A. SELECT
B. INSERT
C. UPDATE
D. DELETE

四、View the Exhibit and examine the data in the PROJ_TASK_DETAILS table.

The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them.
The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on the completion of any other tasks.
You need to generate a report showing all task IDs, the corresponding task ID they are dependent on, and the name of the employee in charge of the task it depends on.
Which query would give the required result?

A. SELECT p.task_id， p.based_on， d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.based_on = d.task_id);

B. SELECT p.task_id， p.based_on， d.task_in_charge
FROM proj_task_details p LEFT OUTER JOIN proj_task_details d
ON (p.based_on = d.task_id);

C. SELECT p.task_id， p.based_on， d.task_in_charge
FROM proj_task_details p FULL OUTER JOIN proj_task_details d
ON (p.based_on = d.task_id);

D. SELECT p.task_id， p.based_on， d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.task_id = d.task_id);

五、A table CANNOT have one or more of the following index configurations.
A. No indexes
B. A clustered index
C. clustered index and many non-clustered indexes
D. Many clustered index

六、下面哪些方法可以用来诊断oracle IO、CPU、性能状况。
A. v$sqlarea(disk_reads)
B. statspack
C. sql_trace
D. v$session_wait

七、在关系数据库有表 S（S＃，SNAME，SAGE），C（C＃，CNAME），SC（S＃，C＃，GRADE）。其中S＃是学生号，SNAME是学生姓名，SAGE是学生年龄， C＃是课程号，CNAME是课程名称。要查询选修“ACCESS”课的年龄不小于20的全体学生姓名的SQL语句是SELECT SNAME FROM S，C，SC WHERE子句。这里的WHERE子句的内容是（）。

A. S.S# = SC.S# and C.C# = SC.C# and SAGE>=20 and CNAME=‘ACCESS’
B. S.S# = SC.S# and C.C# = SC.C# and SAGE in>=20 and CNAME in ‘ACCESS’
C. SAGE in>=20 and CNAME in ‘ACCESS’
D. SAGE>=20 and CNAME=’ ACCESS’

八、Which of the following is(are) true about providing security to database servers ? Select all that apply

A. Do not host a database server on the same server as your web server
B. Do not host a database server on a server based system
C. Do not use blank password for SA account
D. Employ a centralized administration model