<strong id="p5cs1"></strong>

<kbd id="p5cs1"></kbd>

多項(xiàng)選擇題

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table

你可能感興趣的試題

多項(xiàng)選擇題

The following are the details of your database：
Instance name：test
Host name：tech1.us.oracle.com
IP address：145.33.230.186
Enterprise Manager Console HTTP Port number：5500
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）

A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em

單項(xiàng)選擇題

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

你可能感興趣的試題

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）