搜题

【单选题】

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 algorithm consumes more CPU resources than the BZIP2 compression algorithm.

C、The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.

D、Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

查看正确答案

更多“You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）”相关的问题

第1题

[多选题] You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

A、The backup piece size will be limited to 300 MB B、The RMAN uses multiplexing to perform backup C、The operation is accomplished using the default channel available D、The RMAN parallelizes the backup although the parallelism is not set for a channel

点击查看答案

第2题

[] You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

A、A. rman TARGET / NOCATALOG B、B. rman TARGET sys/password C、C. rman TARGET sys/password AS SYSDBA D、D. rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

点击查看答案

第3题

[单选题] You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?（）

A、Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE B、Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE C、Use compression when performing tape backups D、Configure multiple SBT channels

点击查看答案

第4题

[单选题] You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?（）

A、Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE B、Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE C、Use compression when performing tape backups D、Configure multiple SBT channels

点击查看答案

第5题

[多选题] In which three cases would you use the USING clause?（）

A、You want to create a nonequijoin. B、The tables to be joined have multiple NULL columns. C、The tables to be joined have columns of the same name and different data types. D、The tables to be joined have columns with the same name and compatible data types. E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

点击查看答案

第6题

[单选题] In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

A、using only the RMAN SWITCH command to set the new location for the data file B、placing the database in the MOUNT state for the restore and recovery operations. C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command. D、configuring two channels: one for the restore operation and the other for the recovery operation

点击查看答案

第7题

[单选题] Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

点击查看答案

第8题

[单选题] In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）

点击查看答案

第9题

[单选题] 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 algorithm consumes more CPU resources than the BZIP2 compression algorithm. C、The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm. D、Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服