当前分类： 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 o...
查看答案
问题：单选题When you create a backup control file， where is the resulting file written to？（）A The database user dump destination directoryB The database diagnostic destination directoryC To $ORACLE_HOME/rdbmsD To $ORACLE_HOME/adminE To the directory and filen...
问题：多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop o...
问题：多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）Athe SQL textBthe execution planCthe execution contextDthe e...
问题：单选题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 ...
问题：单选题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 hap...
问题：多选题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 passwor...
问题：多选题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...
问题：What is the impact of the following backup if it exceeds the...
问题：单选题Which command creates an image copy？（）A backup as copyB backup copyC copy as backupD copy back...
问题：多选题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...
问题：To set the history retention period for either window loggin...
问题：单选题You want to set the following Initialization parameters for your database Instance LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/dis...
问题：You realize that the control file is damaged in your product...
问题：What RMAN command is used to execute a tablespace point-in-t...
问题：单选题Which statement about using RMAN stored scripts is true?（）A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is wri...
问题：You executed the following command in the Recovery Manager （...
问题：单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A Oracle Net ManagerB Listener Control utilityC...
问题：单选题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 ...
问题：多选题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...
