itgle.com

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

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

相似考题

1.多选题Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the SQL plan baselineEtuning each SQL statement in the order of importanceFgenerating baselines that include candidate SQLs for tuning

2.多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to ASM-managed storage

3.多选题What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture （OFA）-compliant？（）AORACLE_BASE should be set explicitly.BAn Oracle base should have only one Oracle home created in it.CFlash recovery area and data file location should be on separate disks.DFlash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management （ASM） setup.

4.单选题Which components are needed for successful and most efficient recovery.（）AThe backup RB3 and the current online redo log filesBthe backup RB2 and the archived redo log files after the log sequence number 15622CBackup R81 and the archived redo log hies after the log sequence number 12871DThe backup RB3 and the archived redo log files after the log sequence number 16721

更多“You create two resource plans, one for data warehouse loadin”相关问题

  • 第1题：

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


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

  • 第2题：

    单选题
    You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy：   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   Which statement is true？（）
    A

     The command fails because you cannot configure a redundancy-based retention policy when backup  optimization is enabled

    B

     Backup optimization is performed， but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up

    C

     Backup optimization is permanently disabled

    D

     Backup optimization is temporarily disabled because a redundancy-based retention policy is specified


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

  • 第3题：

    单选题
    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）
    A

     The statistics are stored in the pending statistics table in the data dictionary.

    B

     The statistics are treated as the current statistics by the optimizer for all sessions.

    C

     The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D

     The statistics are temporary and used by the optimizer for all sessions until this session terminates.


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

  • 第4题：

    单选题
    Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）
    A

     V$VALID_NLS_VALUES

    B

     NLS_VALID_VALUES

    C

     NLS_VALUE_OPTIONS

    D

     V$NLS_VALUE_OPTIONS

    E

     V$NLS_VALID_VALUES


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

  • 第5题：

    单选题
    Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）
    A

     ASMB

    B

     PMON

    C

     RBAL

    D

     SMON


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

  • 第6题：

    单选题
    During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation？（）
    A

     The installation terminates with an error.

    B

     The installation proceeds with the default value without warnings and errors.

    C

     The installation proceeds with the default value but it would not be an OFA-compliant database.

    D

     The installation proceeds with the default value but a message would be generated in the alert log file.


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

  • 第7题：

    单选题
    Which is not a valid locale definition file type？（）
    A

     Language

    B

     Linguistic sort

    C

     Calendar

    D

     Territory

    E

     Character set


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

  • 第8题：

    单选题
    Which statement can be an inference from the output?（）
    A

    The FRA disk group has an asynchronous I/O bottleneck

    B

    The least number of I/Os are performed on the last data file in the list

    C

    The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list

    D

    The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group


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

  • 第9题：

    单选题
    While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
    A

    It updates the existing SQL profiles with current statistics.

    B

    It makes the statistics information available to GATHER_STATS_JOB

    C

    It initiates the statistics collection process by running GATHER_STATS_JOB

    D

    It logs a warning message in the alert log so that the DBA can perform statistics collection manually.


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

  • 第10题：

    多选题
    Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)
    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


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

  • 第11题：

    单选题
    Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）
    A

     XID

    B

     VERSIONS_PK

    C

     VERSIONS_XID

    D

     VERSIONS_UNIQUE


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

  • 第12题：

    多选题
    Which three statements are true regarding persistent lightweight jobs？（）
    A

    Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.

    B

    The user cannot set privileges on persistent lightweight jobs.

    C

    Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.

    D

    Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.

    E

    The use of a template is mandatory to create persistent lightweight jobs.


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

  • 第13题：

    单选题
    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）
    A

     NLS_LANG

    B

     NLS_COMP

    C

     NLS_SORT

    D

     None of the above


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

  • 第14题：

    多选题
    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)
    A

    ALTER DATABASE FLASHBACK ON;

    B

    GRANT SELECT any transaction TO scott;

    C

    GRANT EXECUTE ON dbms_flashback TO scott;

    D

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    E

    ALTER TABLESPACE undots1 RETENTION GUARANTEE;

    F

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;


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

  • 第15题：

    单选题
    If a backup set is expired， what can you do to correct the problem？（）
    A

     Change the retention criteria.

    B

     Make the lost backup set pieces available to RMAN again.

    C

     Run the crosscheck command to correct the location for the backup set piece contained in the metadata.

    D

     Nothing. The backup set piece is lost forever.

    E

     Call Oracle support，their assistance is required.


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

  • 第16题：

    多选题
    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）
    A

    the SQL text

    B

    the execution plan

    C

    the execution context

    D

    the execution frequency

    E

    the system change number （SCN）


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

  • 第17题：

    单选题
    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
    A

     Yes， if the database is in ARCHIVELOG mode

    B

     Yes， if the database is in NOARCHIVELOG mode

    C

     No， the backup is not usable in any way

    D

     Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE


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

  • 第18题：

    多选题
    What is the purpose of the recover command？（）
    A

    Recover database datafiles from physical disk backup sets.

    B

    Recover required incremental backups from physical disk backup sets.

    C

    Recover required archived redo logs from physical disk backup sets.

    D

    Apply incremental backups to recover the database.

    E

    Apply archived redo logs to recover the database.


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

  • 第19题：

    多选题
    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）
    A

    the SQL text

    B

    the execution plan

    C

    the execution context

    D

    the execution frequency

    E

    the system change number （SCN）


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

  • 第20题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile 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

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第21题：

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

  • 第22题：

    多选题
    What information does the report schema command not provide？（）
    A

    Size of the datafiles

    B

    Size of the tempfiles

    C

    Date of last backup for datafiles and tempfiles

    D

    Filenames for each datafile

    E

    Checkpoint SCN associated with the last RMAN backup


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

  • 第23题：

    单选题
    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）
    A

     Setting a nonzero value for SGA_TARGET

    B

     Configuring Automatic Shared Memory Management

    C

     Configuring Automatic Memory Management

    D

     Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

    E

     None of the above


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

  • 第24题：

    单选题
    What is the default AU size of an ASM disk group？ What is the maximum AU size in an ASM disk group？（）
    A

     100KB default， 10TB maximum

    B

     256KB default， 1024MB maximum

    C

     10MB default， 126PB maximum

    D

     64KB default， 1EB maximum

    E

     1MB default， 64MB maximum


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

相关内容