当前分类: 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...
查看答案
问题:多选题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...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题: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 ...
问题:To set the history retention period for either window loggin...
问题:多选题Which two statements regarding the Flashback Table feature are correct?()AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statem...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()A Issue the grant command from the SYS user (or equivalent) of the target database.B Issue the grant command from the SYS user (or equiva...
问题:You are tuning RMAN to optimize performance. You want tape I...
问题:You realize that the control file is damaged in your product...
问题:单选题Which command do you use to generate a report of database incarnations?()A list incarnation of databaseB report incarnation of databaseC list database incarnationD database incarnation listE report database incarnation...
问题:After executing the command alter diskgroup disk group2 drop...
问题:单选题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...
问题:多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Iden...
问题:单选题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...
问题:多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view ...
问题:Examine the following command that is used to duplicate a da...
问题:You run the following commands: RMAN> list expired backup;...