站内搜索
1Z0-053 问题列表
问题
单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity？（）A
ASM_POWER_LIMITB
ASM_DISKSTRINGC
ASM_DISKGROUPSD
INSTANCE_TYPE
问题
单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）A
recoverB
duplicateC
restoreD
copyE
None of the above
问题
多选题Which two statements are true about encrypting RMAN backup？（）AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the password while creating and restoring backupDIf transparent encryption is configured， you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups
问题
多选题To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME
问题
单选题You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC？（）A
A base catalog existsB
The recovery catalog is emptyC
The base recovery catalog must be droppedD
A target database is registered in the recovery catalog
问题
单选题You run the following commands： RMAN list expired backup； RMAN delete expired backup； What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）A
They will be renamed.B
Nothing will happen to them. The backup set pieces do not exist.C
They will be deleted immediately since they are not in the flash recovery area.D
You will need to manually remove the physical files listed in the output of the commands.E
They will become hidden files and removed 10 days later.
问题
多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
问题
单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）A
Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B
Just back up the database datafiles without shutting down the database.C
You will have to wait until you can shut down the database to perform the backup.D
Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E
Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
问题
单选题Which command creates an image copy？（）A
backup as copyB
backup copyC
copy as backupD
copy back
问题
多选题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 on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
问题
单选题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 suggested SQL profile？（）A
The tuned plan is not added to the SQL plan baseline.B
The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C
The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D
The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
问题
多选题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 the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost
问题
单选题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
问题
多选题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 stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.EFor the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.
问题
多选题In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations