ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-30

042-30

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-14 13:58:37 0 删除 编辑
30. Users of HR schema complain about slower-than-normal performance. On investigation the DBA found that maintenance was recently performed on some of the tables. The DBA traced the query that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?
A) analyzed the EMPLOYEES table to collect the current statistics
B) moved the EMPLOYEES table in to a locally managed tablespace
C) moved the EMPLOYEES table to another location in the same tablespace
D) reorganized the associated indexes for the EMPLOYEES table that were in an unusable state
E) moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists
答案: D

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718507/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 042-29
下一篇: 042-034
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214031