当前分类： 1Z0-053
问题：多选题Which two statements about the SQL Management Base （SMB） are true？（）AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the S...
查看答案
问题：单选题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...
问题：多选题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...
问题：When running the tablespace point-in-time command recover ...
问题：单选题You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database comple...
问题：单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of t...
问题：多选题In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
问题：单选题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...
问题：During the installation of Oracle Database 11g，you do not se...
问题：The ORACLE_SID environment variable is set to +ASM. ASMLIB i...
问题：单选题You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppr...
问题：单选题Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）A only the control file, the current SPFILE, and data filesB onl...
问题：单选题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...
问题：多选题Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（）AADR diagnostic filesBall the optimizer statisticsCinitialization parameter settingsDPL/SQL functions，procedures，and ...
问题：When an ASM instance receives a SHUTDOWN NORMAL command，what...
问题：多选题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 ...
问题：our database instance is running. You are not able to access...
问题：单选题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...
问题：View the following SQL statements： Transaction T1 INSERT I...
问题：单选题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...
