black

1Z0-042

登录

单项选择题

You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance?()

A.Run the SQL Access Advisor.
B.Run the SQL Tuning Advisor (STA).
C.Run the Automatic Workload Repository (AWR) report.
D.Run the Automatic Database Diagnostic Monitor (ADDM).

相关考题

多项选择题 WhichtwodatabaseoperationscanbeperformedattheMOUNTstageofdatabasestartup?()

多项选择题 YourdatabaseisinNOARCHIVELOGmode.Afterwhichtwooperationsyoushouldtakethebackupofcontrolfile?()

多项选择题 Auserwantstoconnecttothedatabaseinstancefromanapplicationthatisrunningonaremotemachine.WhichtoolsshouldtheDBAusetoestablishtherequiredconfigurationtoensurethattheuserisabletoconnecttothedatabaseinstance?()

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

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064