题目内容

You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective?()

A. Rebuild the index.
B. Coalesce the index.
C. Drop and re-create the index in the new tablespace.
D. Relocate the index using the ALTER INDE..MOVE statement.

查看答案
更多问题

尾水事故闸门检修工作前,应关闭进水闸门(或进水阀)和上游检修闸门,并做好防止开启隔离措施,做好其他防止突然来水措施。

A. 正确
B. 错误

表是由()组成的。

A. 记录和窗体
B. 查询和字段
C. 字段和记录
D. 报表和查询

()是指拥有数据库技术支持的计算机系统,它可以实现有组织地、动态地存储大量相关数据,提供数据处理和信息资源共享服务。

A. 数据库系统
B. 数据库管理系统
C. 数据库技术
D. 数据库设计

什么叫干燥?选择使用干燥剂时应注意什么?

答案查题题库