问题：多选题In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
查看答案
问题：多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen ...
问题：单选题You run the SQL Tuning Advisor （STA） to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement，which recommends that you accept the profile. Which statement is true when you accept the sug...
问题：单选题What is the default AU size of an ASM disk group？ What is the maximum AU size in an ASM disk group？（）A 100KB default， 10TB maximumB 256KB default， 1024MB maximumC 10MB default， 126PB maximumD 64KB default， 1EB maximumE 1MB default， 64MB maximum...
问题：单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_A...
问题：单选题What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media？（）A crosscheckB list backupC confirmD resyncE backup validate...
问题：Evaluate the following command and its output： SQL>SELECT ...
问题：多选题Which three are the valid statements in relation to SQL plan baselines？（）AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are sto...
问题：You are using Recovery Manager （RMAN） with a recovery catalo...
问题：单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = ...
问题：单选题What is the correct order of steps to perform an online database backup？（） a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileA a， b， c， d， eB e...
问题：单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 OR...
问题：When running the tablespace point-in-time command recover ...
问题：The Database Resource Manager is automatically enabled in th...
问题：You want to enable resumable space allocation at the instanc...
问题：View the following SQL statements： Transaction T1 INSERT I...
问题：单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How...
问题：单选题Given the script create script db_backup_datafile_script {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；} What is the result of running this command？（）A The script will fail since...
问题：In what order would you execute the following steps to creat...
问题：To view the results of the most recent Automatic SQL Tuning ...
