black

1Z0-042

登录

单项选择题

Exhibit:
View the Exhibit to see the information on existing tablespaces of the PROD database. 
You observe that a large volume of INSERTs and DELETEs are happening on the TRANS table residing in the USERS tablespace, and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find the information about table fragmentation?()

A.Memory Advisor
B.Segment Advisor
C.SQL Tuning and Access Advisors
D.Automatic Workload Repository (AWR)
E.Automatic Database Diagnostic Monitor (ADDM)

相关考题

单项选择题 WhilerunningtheOracleUniversalInstalleronaUnixplatformtoinstallOracleDatabase10gsoftware,youarepromptedtorunorainstRoot.shscript.Whatdoesthisscriptaccomplish?()

单项选择题 WhilecreatingadatabaseusingDatabaseConfigurationAssistanttool,youcreatedadatabasedefaulttemporarytablespace.Whichactivitywouldcausethedefaulttemporarytablespaceofthedatabasetobeused?()

单项选择题 Your alert log file has the following information: Tue May 25 17:43:38 2004  ORA-00060: Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064