单项选择题
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？（）
A.renaming of data files
B.dropping the database user
C.renaming of control files
D.multiplexing of control files
E.configuring the database in ARCHIVELOG mode -
多项选择题
YourdatabaseisinNOARCHIVELOGmode.Afterwhichtwooperationsyoushouldtakethebackupofcontrolfile？（）
A.adding a new user to the database
B.dropping a user from the database
C.dropping a table from the database
D.dropping a data file from a tablespace
E.adding a new tablespace to the database -
多项选择题
Auserwantstoconnecttothedatabaseinstancefromanapplicationthatisrunningonaremotemachine.WhichtoolsshouldtheDBAusetoestablishtherequiredconfigurationtoensurethattheuserisabletoconnecttothedatabaseinstance？（）
A.Data Pump
B.Oracle Net Manager
C.Oracle Enterprise Manager
D.Oracle Universal Installer （OUI）
E.Database Configuration Assistant （DBCA）
