单项选择题
A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
单项选择题 WhatistheadvantageofsettingtheASM-preferredmirrorreadfortheStretchclusterconfiguration?()
单项选择题 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?()
单项选择题 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?()