单选题

You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）

AThe advisory memory has been turned off.

BThe DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

CThe STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

DThe TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

EThe STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

正确答案

答案解析

略

相似试题

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 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 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 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 are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
多选题查看答案
You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files. How would you recover the database from this situation？（）
单选题查看答案
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？（）
多选题查看答案
You need to rename a data file of a tablespace. How would you perform this？（）
单选题查看答案
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？（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析