多項選擇題

You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：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.

你可能感興趣的試題

單項選擇題

You work as a database administrator for Certkiller .com. 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？（）

A.The advisory memory has been turned off.
B.The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C.The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D.The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E.The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

多項選擇題

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）

A.This clause is not valid for a temporary or undotablespace.
B.If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.
C.Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.
D.Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）