单选题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 algo

题目
单选题
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.

相似考题

1.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

2.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.

3.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. 

4.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 want to use RMAN to create compressed backups.Which stat”相关问题

  • 第1题：

    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

    • A、Use the introspect () command in WLST to gather the configuration information from the  original domain.
    • B、Use pack/unpack to transfer the domain from one machine to another.
    • C、Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.
    • D、Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.

    正确答案:C

  • 第2题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第3题：

    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.

    正确答案:A

  • 第4题：

    There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 

    • A、the DBNEWID utility
    • B、the DBVERIFY utility
    • C、the ANALYZE command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the CHECK_OBJECT procedure of the DBMS_REPAIR package

    正确答案:B

  • 第5题：

    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.

    正确答案:A

  • 第6题：

    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

    正确答案:B

  • 第7题：

    单选题
    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 exists

    B

     The recovery catalog is empty

    C

     The base recovery catalog must be dropped

    D

     A target database is registered in the recovery catalog


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）
    A

    A different procedure is required to restore a database from compressed backups

    B

    The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

    C

    Using this command to create backups minimizes the bandwidth consumed

    D

    Using this command to create backups improves the performance of the backup process


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）
    A

    SQL scripts

    B

    Recovery Manager （RMAN） script

    C

    Data Pump

    D

    SQL*Loader

    E

    Flashback database


    正确答案： E,D
    解析： 暂无解析

  • 第12题：

    单选题
    What RMAN command must you use before you can back up a database using the recovery catalog？（）
    A

     create catalog

    B

     install database

    C

     catalog database

    D

     merge Catalog with database

    E

     register database


    正确答案： E
    解析： 暂无解析

  • 第13题：

    What RMAN command must you use before you can back up a database using the recovery catalog？（）

    • A、 create catalog
    • B、 install database
    • C、 catalog database
    • D、 merge Catalog with database
    • E、 register database

    正确答案:E

  • 第14题：

    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

    • A、 SQL scripts
    • B、 Recovery Manager （RMAN） script
    • C、 Data Pump
    • D、 SQL*Loader
    • E、 Flashback database

    正确答案:A,C

  • 第15题：

    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）

    • A、RESYNC CATALOG；
    • B、REGISTER DATABASE；
    • C、CREATE CATALOG TABLESPACE rman_ts；
    • D、GRANT recovery_catalog_owner TO rman_db01；

    正确答案:C

  • 第16题：

    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、 rman TARGET / NOCATALOG
    • B、 rman TARGET sys/password
    • C、 rman TARGET sys/password AS SYSDBA
    • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

    正确答案:B

  • 第17题：

    You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

    • A、 A different procedure is required to restore a database from compressed backups
    • B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
    • C、 Using this command to create backups minimizes the bandwidth consumed
    • D、 Using this command to create backups improves the performance of the backup process

    正确答案:C

  • 第18题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第19题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    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

     rman TARGET / NOCATALOG

    B

     rman TARGET sys/password

    C

     rman TARGET sys/password AS SYSDBA

    D

     rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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 exists

    B

    The recovery catalog is empty

    C

    The base recovery catalog must be dropped

    D

    A target database is registered in the recovery catalog


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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. 


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）
    A

    RESYNC CATALOG；

    B

    REGISTER DATABASE；

    C

    CREATE CATALOG TABLESPACE rman_ts；

    D

    GRANT recovery_catalog_owner TO rman_db01；


    正确答案： C
    解析： 暂无解析

相关内容