当前分类： 1Z0-053
问题：单选题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...
查看答案
问题：多选题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...
问题：单选题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 a Database Replay workload capture， what client request information is gathered？（）ASQL textBShared server requests （Oracle MTS）CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations...
问题：单选题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 running the tablespace point-in-time command recover ...
问题：You have lost all your RMAN backup set pieces due to a disk ...
问题：单选题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...
问题：多选题You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)AThe KEEP option overrides the configured retention policyBThe KEEP option is an attribute of an individual backup pieceCThe back...
问题：单选题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 methods are available to recover lost control files？（）ABackup control file.BEmergency control file.CThe create controlfile command.DThe restore controlfile SQL*Plus command.ENo backup is required. The database will re-create the control file when ...
问题：多选题In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
问题：多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you eff...
问题：You plan to control idle sessions that are blocking other se...
问题：多选题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 ...
问题：单选题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...
问题：单选题Examine the following PL/SQL block： SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob； BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END； Which statement describes the effect of the execution of the above P...
问题：单选题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 Sou...
问题：You are managing an Oracle 11g database with ASM storage， fo...
