单选题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？（）ASet the BACKUP_TAPE_IO_SLAVES parameter to FALSEBSet the BACKUP_TAPE_IO_SLAVES parameter to TRUECUse compre

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

相似考题

1.——() ? —— I want to buy a pair of shoes.A. What are you doing?B. What can I do for you?C. How can I help you?D. How can I do for you?

2.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 FALSEB.Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC. Use compression when performing tape backupsD. Configure multiple SBT channels

3.You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

4.If you want to go, I would give you my advice that you take an umbrella.

更多“You are tuning RMAN to optimize performance. You want tape I”相关问题

  • 第1题：

    “你们可以按我指定的时间把礼物送到吗?” 翻译错误的是( )。

    A.Can you deliver my present the time I want?

    B.Can you deliver my present at time I want?

    C.Can you deliver present at the time I want?

    D.Can you deliver my present at the time I want?


    正确答案：ABC

  • 第2题：

    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

    正确答案:A,C

  • 第3题：

    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 the RMAN. To accomplish the backup， you issued the following RMAN command：   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；   Which two statements are true regarding the execution of the above command？（）

    • A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
    • B、 The backup piece size will be limited to 300 MB.
    • C、 The operation is accomplished using the default channel available.
    • D、 Three channels for the tape drive must be configured by setting the parallelism to three.

    正确答案:B,C

  • 第4题：

    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

  • 第5题：

    单选题
    —Lily, what are you going to do after you graduate?—I’m thinking of becoming a computer programmer.—_____—Well, my parents want me to be a doctor, but I don’t want to do that.
    A

    Do you know what I want to become?

    B

    Why do you want to be a doctor?

    C

    You said you would go to a medical school.

    D

    Thanks for your advice.


    正确答案： C
    解析：
    根据上下文意思，空格处应为C项，意为“你曾经说过你会去读医学院”，这才有后面的“我的父母希望我成为一名医生，但我不想做医生”。

  • 第6题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


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

  • 第7题：

    单选题
    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


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

  • 第8题：

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


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

  • 第9题：

    单选题
    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
    A

     multiplexed control files

    B

     RMAN obsolete backups

    C

     multiplexed online redo log files

    D

     archived redo logs that have not been copied to tape


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

  • 第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题：

    单选题
    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）
    A

    Database replay

    B

    SQL Tuning Advisor

    C

    SQL Access Advisor

    D

    SQL Performance Analyzer

    E

    Automatic Workload Repository compare reports


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

  • 第12题：

    单选题
    You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）
    A

    Save the baseline in the database

    B

    Save the baseline in the Database Control Home Page

    C

    Create a procedure to read and apply the baseline to disk I/O metrics

    D

    Apply the baseline to the disk I/O metrics in the Mange Metrics page

    E

    Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd


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

  • 第13题：

    You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）

    • A、 Use SQL Server Profiler to identify missing indexes.
    • B、 Use the Database Engine Tuning Advisor to identify missing indexes.
    • C、 Use a Dynamic Management View to analyze query plans.
    • D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

    正确答案:C

  • 第14题：

    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

    • A、 SQL Tuning Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第15题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第16题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）

    • A、Top SQL
    • B、snapshots
    • C、SQL Tuning sets
    • D、index access path
    • E、optimizer statistics
    • F、materialized view logs

    正确答案:A,B,C

  • 第17题：

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


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

  • 第18题：

    单选题
    You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）
    A

    The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

    B

    The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

    C

    The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

    D

    The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1


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

  • 第19题：

    多选题
    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 the RMAN. To accomplish the backup， you issued the following RMAN command：   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；   Which two statements are true regarding the execution of the above command？（）
    A

    The RMAN parallelizes the backup although the parallelism is not set for a channel.

    B

    The backup piece size will be limited to 300 MB.

    C

    The operation is accomplished using the default channel available.

    D

    Three channels for the tape drive must be configured by setting the parallelism to three.


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

  • 第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题：

    单选题
    （）? -I am your agent. I want to see the captain.
    A

    What are you?

    B

    What can I do for you?

    C

    Where are you from?

    D

    What are you doing?


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第24题：

    单选题
    You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）
    A

     Run Segment Advisor

    B

     Run the SQL Tuning Advisor （STA）

    C

     Run the Automatic Workload Repository （AWR） report

    D

     Run the SQL Access Advisor with a hypothetical workload


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

相关内容