单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor
单选题
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）
A
Segment Advisor
B
SQL Access Advisor
C
Undo Advisor
D
SQL Tuning Advisor
参考解析
解析：
暂无解析
相关考题：
多选题Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
单选题If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string， what happens to disks that are already a part of the same or another disk group？（）A The command fails unless you specify the FORCE option.B The command fails unless you specify the REUSE option.C The command must be reissued with a more specific discovery string.D The other disks， already part of the disk group，are ignored.
单选题A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow. 1） Restore the corrupted redo log group. 2） Restore from a whole database backup. 3） Perform incomplete recovery. 4） Relocate by renaming the member of the damaged online redo log group to a new location. 5） Open the database with the RESETLOGS option. 6） Restart the database instance. 7） Issue a checkpoint and clear the log. Identify the option with the correct sequential steps to accomplish the task efficiently（）.A 1，3，4，and 5B 7，3，4. and 5C 2，3，4，and 5D 7，4，3，and 5E Only 6 is required
单选题You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.Aa， c， f， gBb， d， e， hCa， b， c， f， gDd， a， e， gEb， c， f， e， g
多选题Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN ？（）ALimiting the input/output （I/O） bandwidth consumptionBSpecifying the size of backup sets and backup piecesCSpecifying vendor-specific information for a media managerDSpecifying the parallelism for backup and restore operations
单选题Examine the following RMAN script： RMAN run { debug on； allocate channel c1 type disk； backup datafile 5； } Which statement describes the purpose of the script？（）A The data file is checked for physical corruption and backed up if found clean.B The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
多选题Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）A The VERSIONS BETWEEN clause may be used in DML statements.B The VERSIONS BETWEEN clause may be used in DDL statements.C The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A The dependent materialized view should have a complete refresh performed after the online table redefinition process.B Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C Referential integrity constraints must be manually enabled after the online table redefinition process.D The materialized log should be dropped before the online table redefinition process.
单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）ARestore the backup control file and open the database with RESETLOGS option.BPerform point-in-time recovery because flashback cannot be performed again on this tableCExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
多选题When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan, and not performance regression, are detected.