Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based,

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

相似考题

1.［A］ turning ［B］ tuning ［C］ tucking ［D］ tugging

2.以下程序段的输出结果为 ( )int j=2；switch(j){case 2：System.out.print("two.")；case 2+1：System.out.println("three.")；breakdefault：System.out.println("value is"+j)；break；}A．two.three.B．two.C．three.D．value is 2

3.Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);Which two statements are true?（）A. Database operations will be monitored only when they consume a significant amount of resource.B. Database operations for all sessions will be monitored.C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D. Only DML and DDL statements will be monitored for the session.E. All subsequent statements in the session will be treated as one database operation and will be monitored.

4. I am _______ to believe that he won‘t come back to see his wife again. A.inclined B.puzzled C.accompanied D.performed

参考答案和解析
参考答案：A, C, E
更多“Which three functions are performed by the SQL Tuning Advisor?() (Choose three.) ”相关问题

  • 第1题：

    Evaluatethefollowingcode：SQL>VARIABLEtask_nameVARCHAR2（255）；SQL>VARIABLEsql_stmtVARCHAR2（4000）；SQL>BEGIN：sql_stmt：=’SELECTCOUNT（*）FROMcustomersWHEREcust_state_province=’’CA’’’；：task_name：=’MY_QUICKTUNE_TASK’；DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，：task_name，：sql_stmt）；END；Whatistheoutcomeofthisblockofcode？（）

    A.Itcreatesataskandworkload，andexecutesthetask.

    B.Itcreatesataskandworkloadbutdoesnotexecutethetask.

    C.Itproducesanerrorbecauseatemplatehasnotbeencreated.

    D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.


    参考答案：A

  • 第2题：

    It is reported that he never ____ an operation (手术) without washing his hands.

    A、railway

    B、track

    C、gay

    D、performed


    正确答案:D

  • 第3题：

    以下程序段的输出结果为( )。 int j=2 switch (j){ Case 2： system.out.print("two.")： Case 2+1： System.out.println("three.")； break： default: System.out.println (“value is”+j): Break }A.B.two

    A．two.three.

    B．two

    C．three

    D．value is 2


    正确答案：A

  • 第4题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

    A. Execute the query and view Active Session History (ASH) for information about the query.

    B. Enable SQL trace for the query.

    C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    参考答案：C

  • 第5题：

    No matter how frequently _____, the works of Beethoven always attract large audiences.

    (A) performing (C) to be performed

    (B) performed (D) being performed

     

     


    选B
    主语是the works，the works与perform之间是被动关系，所以用过去分词performed

  • 第6题：

    为choose表添加外键约束，约束名为choose_student_fk，外键为student_no，参照 student表的st_no字段，以下SQL语句片段正确的是（）。

    A．constraint choose_student_fk FOREIGN KEY (student_no);

    B．constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student(st_no);

    C．constraint choose_student_fk FOREIGN KEY (st_no) REFERENCES student(student_no);

    D．constraint choose_student_fk REFERENCES student(st_no);


    alter table choose add constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student(stu_no);

相关内容