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

相关问题推荐

• What is the purpose of the catalog command？（）  

  A、 To review RMAN control file and recovery catalog metadata and ensure that its correct

  B、 To delete RMAN backup-related metadata from the recovery catalog

  C、 To create metadata in the control file and the recovery catalog related to backup set pieces 

  D、 To create a report that lists database backups

  E、 To rebuild the recovery catalog

  查看答案

• Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

  A

   The user has dropped an important table that needs to be recovered.

  B

   The database files are corrupted when the database is open.

  C

   You are not able to start up the database instance because the required database files are missing.

  D

   The archived log files are missing for which backup is not available.

  查看答案

• Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：   ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；   What would be the outcome of this command？（）

  A、 It produces an error because data already exists in the table.

  B、 It produces an error because compression can be enabled at table creation only.

  C、 It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

  D、 It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.

  查看答案

• What happens when you run the SQL Tuning Advisor with limited scope？（）  

  A、 Access path analysis is not performed for SQL statements.

  B、 SQL structure analysis is not performed for SQL statements.

  C、 SQL Profile recommendations are not generated for SQL statements.

  D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

  查看答案

• Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）

  A、It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

  B、It will be successful only if the memory is available from the auto tuned components

  C、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

  D、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

  查看答案