当前分类: 1Z0-053
问题:多选题You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation o...
查看答案
问题:单选题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...
问题:单选题Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() ...
问题:单选题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...
问题:单选题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...
问题:单选题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 managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()AThe database must be opened in restricted mode.BThe database must be configured ...
问题:单选题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 Oracle 11g, which recommendations does the SQL Access Advisor generate?()Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
问题:单选题Which mode of database shutdown requires an instance recovery at the time of the next database startup?()A ABORTB NORMALC IMMEDIATED TRANSACTIONAL...
问题:View the following SQL statements: Transaction T1 INSERT I...
问题:The following query will provide what information about tran...
问题:单选题You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use?()A The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.B The ZLIB compression ...
问题:单选题What RMAN command must you use before you can back up a database using the recovery catalog?()A create catalogB install databaseC catalog databaseD merge Catalog with databaseE register database...
问题:单选题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...
问题:单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()A statistics recommendationsB SQL Pro...
问题:When running the tablespace point-in-time command recover ...
问题:多选题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 statements are true regarding the Rec...
问题:多选题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...