<strike id="kca9h"></strike>

單項(xiàng)選擇題

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）

A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.

你可能感興趣的試題

單項(xiàng)選擇題

You have a very large table that your users access frequently.
Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）

A. The Automatic Memory Manager （AMM）
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor

單項(xiàng)選擇題

View the following SQL statements：
Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；
Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；
Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；
You want to back out transaction T2.
Which option would you use？（）

A. It is possible，but transaction T3 also backs out.
B. It is possible with the NOCASCADE_FORCE option.
C. It is possible with the NONCONFLICT_ONLY option.
D. It is not possible because it has conflicts with transaction T3.

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）

你可能感興趣的試題

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）

You have a very large table that your users access frequently.
Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）