单项选择题

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）

单项选择题YoudefineanalerttoberaisedwhentheUSERStablespaceusagehasreached80%ofthetotalspace.Whichareawouldyoureferto，inordertoconfirmthatthealerthasbeenraisedduetheevent？（）

A.the alert.log file
B.the DBA_ALERTS view
C.the Database Control Home page
D.the Database Control performance page
E.the Database Control Maintenance page

多项选择题YourequiretheOracleservertomanagetheundosegmentsandspaceamongvariousactivesessionsautomatically.Youcreatedanundotablespace，UNDO_TBS1，inyourdatabase.Whichtwoadditionalstepswouldyouperformtoachievethis？（）

A.Set the UNDO_RETENTION parameter to 900 or more.
B.Create an initial undo segment in the undo tablespace.
C.Enable the retention guarantee for the undo tablespace.
D.Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E.Set the UNDO_MANAGEMENT initialization parameter to AUTO.