问题:单选题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...
查看答案
问题:单选题When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()A INCLUDING DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above...
问题:Which of the following is a valid way of putting a tablespac...
问题:单选题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...
问题:多选题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 ...
问题:单选题Which of the following methods can be used to detect block corruption?()A ANALYZE operationsB dbvC SQL queries that access the potentially corrupt blockD RMANE All of the above...
问题:单选题Consider the following command: Backup database plus archivelog delete input; How many backup sets would be created by this command if the following were true:() Control-file a NN uto backups were enabled. NN The size of backup sets was not restric...
问题:单选题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...
问题:多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZ...
问题:多选题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...
问题:View the following SQL statements: Transaction T1 INSERT I...
问题:单选题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 ...
问题:单选题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...
问题:单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configu...
问题:多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a suc...
问题:You run the following commands: RMAN> list expired backup;...
问题:单选题What is an obsolete backup set?()A A backup set that is missing one or more backup set piecesB A backup that has exceeded the retention criteria and is no longer neededC A backup set that does not include archived redo logsD A backup set that can n...
问题:多选题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...