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

题目
单选题
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；   What configuration should be effected to accomplish faster and optimized backups by using the above command？（）
A

 The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1

B

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

C

 The SBT channel must be configured， with the parallelism setting for the SBT device set to 3

D

 The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB

相似考题

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

2.多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）AALTER DATABASE FLASHBACK ONBGRANT SELECT any transaction TO scottCGRANT EXECUTE ON dbms_flashback TO scottDALTER DATABASE ADD SUPPLEMENTAL LOG DATAEALTER TABLESPACE undots1 RETENTION GUARANTEEFALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

3.单选题Which statement about recovering from the loss of a redo log group is true?（）A If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B If the lost redo log group is CURRENT, you must clear the log file.C If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

4.多选题Which two statements regarding a SQL profile are true？（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“You are managing an Oracle Database 11g database. You want t”相关问题

  • 第1题：

    多选题
    You are trying to recover your database. During the recovery process， you receive the following error：   ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ：  /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log  file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17  /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log  ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3   How do you respond to this error？（）
    A

    Restore the archived redo log that is missing and attempt recovery again.

    B

    Recovery is complete and you can open the database.

    C

    Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.

    D

    Recover the entire database and apply all archived redo logs again.

    E

    Recovery is not possible because an archived redo log has been lost.


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

  • 第2题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
    A

     The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

    C

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

    D

     If you restart the database，the database will not be opened.


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

  • 第3题：

    单选题
    The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
    A

     The materialized view should have a complete refresh performed after the online table redefinition is completed.

    B

     The materialized view should have a fast refresh performed after the online table redefinition is completed.

    C

     The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

    D

     The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.


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

  • 第4题：

    多选题
    Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）
    A

    A must contain all of the characters defined in B

    B

    A must be Unicode

    C

    The encoded values in A must match the encoded values in B for all characters defined in B

    D

    A must be a multibyte character set

    E

    The encoded values in A must match the encoded values in B for all numeric and alphabetic character


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

  • 第5题：

    单选题
    What view might you use to try to determine how long a particular backup will take？（）
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SESSION_LONGOPS


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

  • 第6题：

    单选题
    If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
    A

     Complete database recovery.

    B

     Incomplete database recovery.

    C

     Approximate database recovery.

    D

     Archived database recovery.

    E

     The database could not be recovered with RMAN.


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

  • 第7题：

    多选题
    Which three functions are performed by the SQL Tuning Advisor？（）
    A

    Building the SQL profile

    B

    Recommending optimization of materialized views

    C

    Checking query objects for missing and stale statistics

    D

    Recommending bitmap， function-based， and B-tree indexes

    E

    Recommending restructuring SQL queries that are using bad plans


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

  • 第8题：

    多选题
    Which three statements are true about windows？（）
    A

    Only one window can be open at any given time

    B

    Consumer groups are associated with windows

    C

    Windows work with job classes to control resource allocation

    D

    The database service name must be provided during windows creation

    E

    Windows can automatically start job or change resource allocation among jobs for various time periods.


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

  • 第9题：

    单选题
    You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）
    A

    Implement job classes

    B

    Implement Scheduler windows

    C

    Implement the mapping rule for the consumer groups

    D

    Set the SWITCH_TIME resource plan directive for both the resource plans


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

  • 第10题：

    多选题
    Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
    A

    Flash recovery area must be defined

    B

    Undo retention guarantee must be enabled.

    C

    Database must be running in archivelog mode.

    D

    Automatic undo management must be enabled.

    E

    The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


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

  • 第11题：

    多选题
    Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）
    A

    Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.

    B

    Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.

    C

    Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

    D

    Health Monitor checks are always initiated manually when there is some critical error.


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

  • 第12题：

    多选题
    Which three statements correctly describe the features of the I/O calibration process？（）
    A

    Only one I/O calibration process can run at a time

    B

    It automates the resource allocation for the Automated Maintenance Tasks

    C

    It improves the performance of the performance-critical sessions while running

    D

    It can be used to estimate the maximum number of I/Os and maximum latency time for the system

    E

    The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE


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

  • 第13题：

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）
    A

     ADD DIRECTORY

    B

     DROP DISK

    C

     RESIZE DISK

    D

     REBALANCE

    E

     ADD FAILGROUP


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

  • 第14题：

    单选题
    Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）
    A

     It contains data till the last backup

    B

     It contains all data from target database until the current time

    C

     It contains all data from only the committed transactions in the target database

    D

     It contains all data except that which is used by the transactions in the current online redo file of target database


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

  • 第15题：

    多选题
    Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）
    A

    SET_ATTRIBUTE_NULL

    B

    ALTER_JOB

    C

    ALTER_JOB_PARAMETERS

    D

    ALTER

    E

    SET_ATTRIBUTE


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

  • 第16题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）
    A

     The Oracle database will perform block checking for the index blocks only

    B

     The Oracle database will not perform block checking for any of the data blocks

    C

     The Oracle database will perform block checking for the default permanent tablespace only

    D

     The Oracle database will perform block checking for the data blocks in all user tablespaces

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only


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

  • 第17题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第18题：

    单选题
    Which of these appropriately describes the results of a manual SQL Tuning Advisor task？（）
    A

     A list of SQL statements and recommendations for tuning

    B

     A list of SQL statements that have been tuned by the Advisor，with before and after metrics 

    C

     Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes

    D

     All of the above


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

  • 第19题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


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

  • 第20题：

    单选题
    Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）
    A

     It creates a task and workload， and executes the task.

    B

     It creates a task and workload but does not execute the task.

    C

     It produces an error because a template has not been created.

    D

     It produces an error because the SQL Tuning Set has not been created.


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

  • 第21题：

    单选题
    Evaluate the following block of code：   BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl =>  ’mycompany-com-permissions.xml’， principal => ’ACCT_MGR’， is_grant => TRUE， privilege => ’connect’）；  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl => ’mycompany-com-permissions.xml’， host => ’*.mycompany.com’）； END；   What is the outcome of the above code？（）
    A

     It produces an error because a fully qualified host name needs to be specified.

    B

     It produces an error because the range of ports associated with the hosts has not been specified.

    C

     It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and  RESOLVE privileges.

    D

     It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.


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

  • 第22题：

    单选题
    You enable block change tracking. You issue the following command：   BACKUP INCREMENTAL LEVEL 0 DATABASE；   The next day，you issue the following command：   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which statement about the use of the change tracking file is true？（）
    A

     RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

    B

     RMAN reads the block change tracking file when it performs both incremental backups.

    C

     RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

    D

     RMAN does not read the block change tracking file when it performs either incremental backup.


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

  • 第23题：

    单选题
    The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
    A

    Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

    B

    Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

    C

    Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

    D

    Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.


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

  • 第24题：

    多选题
    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    redo logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


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

相关内容