多項(xiàng)選擇題

Which of the following cannot be used as input to the SQL Tuning Advisor？（）

A. A single SQL statement provided by a user
B. An existing SQL Tuning Set （STS）
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources

你可能感興趣的試題

單項(xiàng)選擇題

You want to set the following Initialization parameters for your database Instance
LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch
LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch
LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch
LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch
Identify the statement that correctly describes this setting.（）

A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

多項(xiàng)選擇題

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）

A. redo logs
B. control file
C. temporary files of temporary tablespace
D. the latest backup of only the damaged data file
E. the latest backup of all the data files In the USERS tablespace

Which of the following cannot be used as input to the SQL Tuning Advisor？（）

你可能感興趣的試題

Which of the following cannot be used as input to the SQL Tuning Advisor？（）