You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this?()
A Run Segment Advisor
B Run the SQL Tuning Advisor (STA)
C Run the Automatic Workload Repository (AWR) report
D Run the SQL Access Advisor with a hypothetical workload
正确答案
答案解析
相似试题
(单选题)
You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()
(单选题)
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this?()
(单选题)
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
(单选题)
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()
(单选题)
You are working on the Certkiller database. What is the default name of the alert log file in this database?()
(多选题)
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
(多选题)
You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
(单选题)
View the Exhibit and examine the output of the query. What do you infer from this()
(单选题)
Exhibit, error You work as a database administrator for Supportcenter.cn. When you try to connect to the database, you get an error (See exhibit). What could be the possible reason for getting such an error?()
(单选题)
You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()