单项选择题

A.The Advisory is on and will capture both CPU and memo……

Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？（）

A.The Advisory is on and will capture both CPU and memory overhead.
B.The Advisory is on but the memory for the Advisory is not allocated.
C.The Advisory is off and the memory for the Advisory is not allocated.
D.The Advisory is off but the memory for the Advisory remains allocated.

<上一题目录下一题>

热门试题

单项选择题Abitmapjoinindexisdefinedas（）.

A.An index used to join two bitmap indexes on a table.
B.A bitmap index created for the join of two or more tables.
C.A bitmap index created on the join of two or more indexes.
D.A bitmap index created on the join of two or more indexed-organized tables.

单项选择题Examine the statement： DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）

A.A
B.B
C.C
D.D

单项选择题Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）

A.It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table.
B.It creates a natural join of tables T1 and T2 for all columns that have the same name.
C.It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.
D.For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

多项选择题WhichtwodatatypescanbeconvertedtoLOBsusinganALTERTABLE…MODIFYcommand？（）

A.RAW
B.LONG
C.VARCHAR
D.LONG RAW

多项选择题Onlineindexrebuildfunctionalityhasbeenextendedtoincludewhichfourindexstructures？（）

A.Bitmap indexes.
B.Reverse key indexes.
C.Function-based indexes.
D.Key-compressed indexes on regular tables.
E.Key-compressed indexes on IOT （including secondary indexes）