niusouti.com

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL

题目

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）

  • A、SER_NO
  • B、ORDER_ID
  • C、STATUS
  • D、PROD_ID
  • E、ORD_TOTAL
  • F、composite index on ORDER_ID and ORDER_DATE
相似考题

1.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

2.Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.

3.Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()A. The SELECT statement is syntactically accurate.B. The SELECT statement does not work because there is no HAVING clause.C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

4.You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）A. The tuned plan is not added to the SQL plan baseline.B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

更多“Examine the SQL statement that ”相关问题

  • 第1题：

    Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）

    A.

    B.

    C.

    D.


    参考答案：D

  • 第2题：

    Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

    A. SER_NO

    B. ORDER_ID

    C. STATUS

    D. PROD_ID

    E. ORD_TOTAL

    F. Composite index on ORDER_ID and ORDER_DATE


    参考答案：A, F

  • 第3题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

    A.

    B.

    C.

    D.


    参考答案：C

  • 第4题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

    A.The SELECT statement is syntactically accurate.

    B.The SELECT statement does not work because there is no HAVING clause.

    C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    参考答案：A

  • 第5题：

    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）

    • A、Bind Variable Peeking
    • B、SQL Plan Baselines
    • C、Adaptive Cursor Sharing
    • D、Bind variable used in a SQL statement
    • E、Literals in a SQL statement

    正确答案:A,C,E

  • 第6题：

    Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

    • A、A single SQL statement provided by a user
    • B、An existing SQL Tuning Set (STS)
    • C、A preprocessed Database Replay workload
    • D、A schema name
    • E、SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第7题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第9题：

    多选题
    Which two statements are true regarding the SQL Repair Advisor?（）
    A

    The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

    B

    The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

    C

    The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

    D

    The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.


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

  • 第10题：

    单选题
    Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）
    A

     It is loaded with the FIXED status.

    B

     It is loaded with the ACCEPTED status.

    C

     It is not loaded with the ENABLED status.

    D

     It is not loaded with the ACCEPTED status.


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

  • 第11题：

    多选题
    Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
    A

    Oracle Managed Files are used for this instance.

    B

    The USER_DATA tablespace is managed using FET$/UET$ tables.

    C

    The COMPATIBLE initialization parameter must be 9.0.0 or higher.

    D

    Space within segments in the USER_DATA tablespace is managed with freelists.


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

  • 第12题：

    单选题
    Examine the statement： DROP TABLESPACE IND2  INCLUDING CONTENTS  AND DATAFILES；   What is the result of the statement？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第13题：

    Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()

    A.

    B.

    C.

    D.


    参考答案：A

  • 第14题：

    Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）

    A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

    B. The statement returns an error at the SELECT clause.

    C. The statement returns an error at the WHERE clause.

    D. The statement returns an error at the ORDER BY clause.


    参考答案：C

  • 第15题：

    Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

    A.

    B.

    C.

    D.


    参考答案：B

  • 第16题：

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第17题：

    Which two statements are true regarding the SQL Repair Advisor？（） 

    • A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
    • B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
    • C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
    • D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

    正确答案:B,D

  • 第18题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • A、 A single SQL statement provided by a user
    • B、 An existing SQL Tuning Set （STS）
    • C、 A preprocessed Database Replay workload
    • D、 A schema name
    • E、 SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第19题：

    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）  

    • A、 The plan baselines are verified with the SQL profiles.
    • B、 All fixed plan baselines are converted into nonfixed plan baselines.
    • C、 All the nonaccepted SQL profiles are accepted into the plan baseline.
    • D、 The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

    正确答案:D

  • 第20题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第21题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


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

  • 第22题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


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

  • 第23题：

    单选题
    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）
    A

     The plan baselines are verified with the SQL profiles.

    B

     All fixed plan baselines are converted into nonfixed plan baselines.

    C

     All the nonaccepted SQL profiles are accepted into the plan baseline.

    D

     The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.


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

  • 第24题：

    多选题
    Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


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

相关内容