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

题目

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(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 aboveSQL 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.Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()A.B.C.D.

2.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.

3.Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation performed using the control file?()A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.C. The SQL* Loader operation fails because no record terminators are specified.D. Field names should be the first line in the both the SQL* Loader data files.E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

4.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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE

参考答案和解析
正确答案:A,F
更多“Examine the SQL statements that”相关问题

  • 第1题：

    Which three statements about performance analysis by SQL Performance Analyzer are true? （）

    • A、It detects changes in SQL execution plans.
    • B、It produces results that can be used to create the SQL plan baseline.
    • C、The importance of SQL statements is based on the size of the objects accessed.
    • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
    • E、It shows only the overall impact on workload and not the net SQL impact on workload.

    正确答案:A,B,D

  • 第2题：

    Which statement correctly describes SQL and /SQL*Plus?（）

    • A、Both SQL and /SQL*plus allow manipulation of values in the database.
    • B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
    • C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
    • D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

    正确答案:A

  • 第3题：

    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

  • 第4题：

    You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）  

    • A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
    • B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
    • C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
    • D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

    正确答案:A

  • 第5题：

    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

    • A、 SQL statements that are part of the AWR baseline only
    • B、 SQL statements based on the AWR top SQL identification
    • C、 SQL statements that are part of the available SQL Tuning Set （STS） only
    • D、 SQL statements that are available in the cursor cache and executed by a user other than SYS

    正确答案:B

  • 第6题：

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

    • A、ADDM
    • B、AWR
    • C、Cursor Cache
    • D、SQL Tuning Sets
    • E、Flash Recovery Area

    正确答案:E

  • 第7题：

    单选题
    Which statement is true when you run the SQL Tuning Advisor with limited scope？（）
    A

    Access path analysis is not performed for the SQL statements.

    B

    SQL structure analysis is not performed for the SQL statements.

    C

    SQL Profile recommendations are not generated for the SQL statements.

    D

    The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.


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

  • 第8题：

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


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

  • 第9题：

    多选题
    Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > 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.


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

  • 第10题：

    单选题
    Which statement correctly describes SQL and /SQL*Plus?（）
    A

    Both SQL and /SQL*plus allow manipulation of values in the database.

    B

    /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

    C

    /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

    D

    /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.


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

  • 第11题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
    A

     SQL statements that are part of the AWR baseline only

    B

     SQL statements based on the AWR top SQL identification

    C

     SQL statements that are part of the available SQL Tuning Set （STS） only

    D

     SQL statements that are available in the cursor cache and executed by a user other than SYS


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

  • 第12题：

    单选题
    You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）
    A

     The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.

    B

     The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.

    C

     The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.

    D

     The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.


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

  • 第13题：

    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

    正确答案:A

  • 第14题：

    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

    正确答案:A

  • 第15题：

    Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

    • A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
    • B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.
    • C、The SQL* Loader operation fails because no record terminators are specified.
    • D、Field names should be the first line in the both the SQL* Loader data files.
    • E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

    正确答案:A,B,E

  • 第16题：

    What happens when you run the SQL Tuning Advisor with limited scope？（）  

    • A、 Access path analysis is not performed for SQL statements.
    • B、 SQL structure analysis is not performed for SQL statements.
    • C、 SQL Profile recommendations are not generated for SQL statements.
    • D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

    正确答案:B

  • 第17题：

    What happens when you run the SQL Tuning Advisor with limited scope?（）

    • A、Access path analysis is not performed for SQL statements.
    • B、SQL structure analysis is not performed for SQL statements.
    • C、SQL Profile recommendations are not generated for SQL statements.
    • D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

    正确答案:B,C

  • 第18题：

    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

  • 第19题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue 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.


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

  • 第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题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）
    A

    SQL statements that are part of the AWR baseline only 

    B

    SQL statements based on the AWR top SQL identification

    C

    SQL statements that are part of the available SQL Tuning Set (STS) only 

    D

    SQL statements that are available in the cursor cache and executed by a user other than SYS 


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

  • 第22题：

    单选题
    What happens when you run the SQL Tuning Advisor with limited scope？（）
    A

     Access path analysis is not performed for SQL statements.

    B

     SQL structure analysis is not performed for SQL statements.

    C

     SQL Profile recommendations are not generated for SQL statements.

    D

     Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.


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

  • 第23题：

    多选题
    What happens when you run the SQL Tuning Advisor with limited scope?（）
    A

    Access path analysis is not performed for SQL statements.

    B

    SQL structure analysis is not performed for SQL statements.

    C

    SQL Profile recommendations are not generated for SQL statements.

    D

    Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.


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

  • 第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
    解析： 暂无解析

相关内容