niusouti.com

单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）ASQL Repair AdvisorBSQL OptimizerCSQL Access AdvisorDSQL Tuning Advisor

题目
单选题
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）
A

 SQL Repair Advisor

B

 SQL Optimizer

C

 SQL Access Advisor

D

 SQL Tuning Advisor

相似考题

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

2.Which of the following advisors is run in every maintenance window by the auto－task system?()A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor

3.Which three components does the Scheduler use for managing tasks within the Oracle environment? ()(Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedure

4.Which three components does the Scheduler use for managing tasks within the Oracle environment?()A. a jobB. a programC. a scheduleD. a PL/SQL procedure

更多“Which of the following advisors within the Oracle advisory f”相关问题

  • 第1题：

    Which of the following statements describe the use of the keyword

    static?

    a) Within the body of a function: A static variable maintains its value

    between function revocations

    b) Within a module: A static variable is accessible by all functions

    within that module

    c) Within a module: A static function can only be called by other

    functions within that module


    正确答案：
     

  • 第2题：

    SQ L*Loader is a utility that can perform which two tasks？（）

    • A、Load data from a disk， tape， or named pipes.
    • B、Load data into an Oracle database using DML statements.
    • C、Extract， reorganize， and insert data within an Oracle database.
    • D、Load data from external files into tables in an Oracle database.
    • E、Load data into an Oracle database using operating system commands.
    • F、Load data directly from a non-Oracle database to an Oracle database.

    正确答案:A,D

  • 第3题：

    The Attribute field within the IS-IS LSP header contains which of the following flags？ （）

    • A、IS-Type
    • B、Overload （LSPDBOL）
    • C、Pseudonode （PN）
    • D、Attached （ATT）
    • E、Fragment （Frag-Nr）
    • F、Partition （P）

    正确答案:A,B,D,F

  • 第4题：

    Which of the following is the MOST space efficient server chassis type within a server rack？（）

    • A、 Tower server
    • B、 Bare metal server
    • C、 Blade server
    • D、 Rack server

    正确答案:C

  • 第5题：

    Which three components does the Scheduler use for managing tasks within the Oracle environment? （）(Choose three.)

    • A、a job
    • B、a program
    • C、a schedule
    • D、a PL/SQL procedure

    正确答案:A,B,C

  • 第6题：

    Which three components does the Scheduler use for managing tasks within the Oracle environment?（）

    • A、a job
    • B、a program
    • C、a schedule
    • D、a PL/SQL procedure

    正确答案:A,B,C

  • 第7题：

    Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

    • A、INSERT 
    • B、SELECT 
    • C、UPDATE 
    • D、DELETE

    正确答案:B

  • 第8题：

    单选题
    You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）
    A

     The Automatic Memory Manager （AMM）

    B

     The SQL Tuning Advisor

    C

     The Segment Advisor

    D

     The SQL Access Advisor


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

  • 第9题：

    多选题
    Which of the following Oracle features utilize the undo tablespace？（）
    A

    Flashback Query

    B

    Flashback Drop

    C

    Flashback Table

    D

    Flashback Database

    E

    Transaction Processing

    F

    Recycle Bin


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

  • 第10题：

    单选题
    Which of the following factors will have the greatest effect on the heating load within a conditioned space?（）
    A

    Solar gain

    B

    Infiltration and ventilation air

    C

    Occupants inside the space

    D

    Entertainment equipment within the space


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

  • 第11题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）
    A

    SQL Repair Advisor

    B

    SQL Optimizer

    C

    SQL Access Advisor

    D

    SQL Tuning Advisor SQL


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

  • 第12题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）
    A

     SQL Repair Advisor

    B

     SQL Optimizer

    C

     SQL Access Advisor

    D

     SQL Tuning Advisor


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

  • 第13题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor SQL

    正确答案:D

  • 第14题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第15题：

    Which of the following laptop components will MOST likely need replacing within the first threeyears of use?（）

    • A、Battery
    • B、Processor
    • C、Memory
    • D、Backlight

    正确答案:A

  • 第16题：

    Which of the following is an interior routing protocol that is used to provide routing within autonomous systems?（）

    • A、ARP
    • B、IGP
    • C、BGP
    • D、EGP

    正确答案:B

  • 第17题：

    You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）

    • A、mydb is a service name.
    • B、test.us.oracle.com is a database name.
    • C、1521 is the listener port number.
    • D、mydb is a host name.
    • E、test.us.oracle.com is a net service name.
    • F、hr is a username.
    • G、test.us.oracle.com is an instance name.

    正确答案:A,C,F

  • 第18题：

    Which of the following advisors is run in every maintenance window by the auto-task system?（）

    • A、The Memory Advisor
    • B、The SQL Tuning Advisor
    • C、The Undo Advisor
    • D、The SQL Access Advisor

    正确答案:B

  • 第19题：

    Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）

    • A、The Advisory is on and will capture both CPU and memory overhead.
    • B、The Advisory is on but the memory for the Advisory is not allocated.
    • C、The Advisory is off and the memory for the Advisory is not allocated.
    • D、The Advisory is off but the memory for the Advisory remains allocated.

    正确答案:D

  • 第20题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

  • 第21题：

    单选题
    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）
    A

    Shared pool 

    B

    Control file 

    C

    SGA 

    D

    PGA


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

  • 第22题：

    单选题
    Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）
    A

    The Advisory is on and will capture both CPU and memory overhead.

    B

    The Advisory is on but the memory for the Advisory is not allocated.

    C

    The Advisory is off and the memory for the Advisory is not allocated.

    D

    The Advisory is off but the memory for the Advisory remains allocated.


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

  • 第23题：

    单选题
    The Oracle Net architecture is based on which of the following？（）
    A

    OCI

    B

    OSI

    C

    TCP/IP

    D

    SNMP


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

  • 第24题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）
    A

    SQL Repair Advisor

    B

    SQL Optimizer

    C

    SQL Access Advisor

    D

    SQL Tuning Advisor


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

相关内容