單項選擇題

Which statement is true about the plan being loaded into the SQL baseline by the above command?（）

A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D.It is not loaded with the ACCEPTED status.

你可能感興趣的試題

單項選擇題

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

Which statement describes the consequence?（）

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

單項選擇題

You need to create a partitioned table to store historical data and you issued the following command:

What is the outcome of the above command?（）

A. It returns an error because the range partitions P1 and P2 should be of the same range.
B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C.It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D. It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.

Which statement is true about the plan being loaded into the SQL baseline by the above command?（）

你可能感興趣的試題

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. Which statement describes the consequence?（）

You need to create a partitioned table to store historical data and you issued the following command: What is the outcome of the above command?（）

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

Which statement describes the consequence?（）

You need to create a partitioned table to store historical data and you issued the following command:

What is the outcome of the above command?（）