You&ensp;work&ensp;as&ensp;a&ensp;data...

单项选择题X 纠错

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.
Which advisory component would you refer to， in order to determine the appropriate indexes？（）

A.Memory Advisors
B.Segment Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository （AWR）
E.Automatic Database Diagnostic Monitor （ADDM）

参考答案：

进入题库练习

单项选择题

Two database users， Jack and Bill， are accessing the Certkiller STAFF table of the Certkiller DB database. When Jack modifies a value in the table， the new value is invisible to Bill.
Which is the modified value invisible to Bill？（）

A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the Certkiller STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.

点击查看答案进入题库练习

单项选择题

You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the
Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table.
How does this change affect the index？（）

A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates

点击查看答案进入题库练习

多项选择题

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

A.use enterprise manager
B.use DBMS_SQL package
C.use DBMS_AWR package
D.use PRVT_WORKLOAD package
E.query the AWR snapshot repository objects
F.use DBMS_WORKLOAD_REPOSITORY package

点击查看答案进入题库练习

单项选择题

You are working on the Certkiller database.
What is the default name of the alert log file in this database？（）

A.alert_ Certkiller .log
B.alertlog_ Certkiller .log
C.alert_log_ Certkiller .log
D.Certkiller _alert_log.log
E.log_alert_： Certkiller .log
F.trace_alert_ Certkiller .log

点击查看答案进入题库练习

单项选择题

You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

A.The trace file
B.The fixed views
C.The data dictionary views
D.The operating system log fields
E.The dynamic performance views.

点击查看答案进入题库练习

单项选择题

You work as a database administrator for Certkiller .com. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

A.The instance would hang.
B.The instance needs to be shut down.
C.The instance would be in the open state.
D.The instance would abort in such cases.
E.The instance would be in the open and invalid state.
F.The instance would in the open state， but all the background processes will be restarted.

点击查看答案进入题库练习

多项选择题

You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

A.By multiplexing the control files
B.By multiplexing the redo log files
C.By decreasing the size of redo log files
D.By configuring mean time to recover （MTTR） to a lower value
E.By setting the UNDO_RETENTION parameter to a higher value

点击查看答案进入题库练习

单项选择题

You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

A.Increase the undo return
B.Create more undo segments
C.Create another undotablespace
D.Increase the size of the undotablespace

点击查看答案进入题库练习

单项选择题

You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

A.Restart the database instance and run the job
B.Truncate the Certkiller STAFF table and run the job
C.Delete all rows from the Certkiller STAFF table and run the job
D.Increase the size of the USERStablespacethe and run the job
E.Increase the size of the database default permanenttablespaceand run the job

点击查看答案进入题库练习

单项选择题

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

A.The source PL/SQL code will be stored in native machine code.
B.The source PL/SQL code will be stored in interpreted byte code.
C.The compiled PL/SQL code will be stored in native machine code.
D.The compiled PL/SQL code will be stored in interpreted byte code.

点击查看答案进入题库练习