问题:多选题Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B...
查看答案
问题:Another DBA issues a shutdown abort command on a database on...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:单选题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 ...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:多选题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...
问题:You are peer reviewing a fellow DBAs backup plan for his NOA...
问题:单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()A Opening the database in RESTRICTED modeB Opening the d...
问题:单选题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...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs...
问题:You run the following commands: RMAN> list expired backup;...
问题:You performed the RMAN database backup having a backupset ke...
问题:多选题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...
问题:Which of these represent the main components of Database Res...
问题:To set the history retention period for either window loggin...
问题:单选题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...
问题:多选题Which two statements are correct about database transportation?()AThe source and target platforms must be the sameBRedo logs,control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:You are managing a 24*7 database. The backup strategy for th...