单选题Evaluate these two SQL statements: What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DTh

题目
单选题
Evaluate these two SQL statements: What is true about them?（）
A

The two statements produce identical results.

B

The second statement returns a syntax error.

C

There is no need to specify DESC because the results are sorted in descending order by default.

D

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

相似考题

1.which of the following statements is not true about the british media?A. They are mainly interested in making huge profits by publishing advertisements.B. They supply people with news，keeping them informed of what is happening in the world.C. They help shape British culture.D. They provide entertainment.

2.The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.

3.Evaluate these two SQL statements:What is true about them?()A. The two statements produce identical results.B. The second statement returns a syntax error.C. There is no need to specify DESC because the results are sorted in descending order by default.D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

4.Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

更多“Evaluate these two SQL statements: What is true about them?（”相关问题

  • 第1题：

    Evaluate the set of SQL statements:What is true about the set?()

    A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

    B. The ROLLBACK statement frees the storage space occupies by the DEPT table.

    C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

    D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.


    参考答案：A

  • 第2题：

    By default, which two statements are true about export routing polices?()

    A. Export polices can evaluate only active routes

    B. Export polices can evaluate all routes

    C. Export polices can be applied to the forwarding table

    D. Export polices can be applied to interfaces


    参考答案：A, C

  • 第3题：

    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

  • 第4题：

    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

    • A、It contains only SQL profiles generated by SQL Tuning Advisor.
    • B、It stores plans generated by the optimizer using a stored outline.
    • C、It is part of the data dictionary and stored in the SYSAUX tablespace.
    • D、It is part of the data dictionary and stored in the SYSTEM tablespace.
    • E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

    正确答案:C,E

  • 第5题：

    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）

    • A、The two statements produce identical results.
    • B、The second statement returns a syntax error.
    • C、There is no need to specify DESC because the results are sorted in descending order by default.
    • D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

    正确答案:A

  • 第6题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true?（）
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

  • 第7题：

    多选题
    Which two statements are true about L2TP tunnels?（） (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


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

  • 第8题：

    多选题
    By default, which two statements are true about export routing polices?（）
    A

    Export polices can evaluate only active routes

    B

    Export polices can evaluate all routes

    C

    Export polices can be applied to the forwarding table

    D

    Export polices can be applied to interfaces


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

  • 第9题：

    多选题
    By default, which two statements are true about export routing policies?（）
    A

    Export policies can evaluate only active routes

    B

    Export policies can evaluate all routes

    C

    Export policies can be applied to the forwarding table

    D

    Export policies can be applied directly to interfaces


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

  • 第10题：

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第11题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Area（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


    正确答案： E,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 two statements are true about applying Host Checker at the realm level?()

    A. If Evaluate is checked then the client must pass policy to get the sign-in page.

    B. If Evaluate is checked then the client can fail policy and still get the sign-in page.

    C. If Require and Enforce is checked then the client must pass policy to get the sign-in page.

    D. If Require and Enforce is checked then the client can fail policy and still get the sign-in page.


    参考答案：B, C

  • 第14题：

    Which two statements are true about L2TP tunnels?（） (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第15题：

    By default, which two statements are true about export routing policies?（）

    • A、Export policies can evaluate only active routes.
    • B、Export policies can evaluate all routes.
    • C、Export policies can be applied to the forwarding table.
    • D、Export policies can be applied directly to interfaces

    正确答案:A,C

  • 第16题：

    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

  • 第17题：

    Which two statements about subqueries are true? （）

    • A、A subquery should retrieve only one row.
    • B、A subquery can retrieve zero or more rows.
    • C、A subquery can be used only in SQL query statements.
    • D、Subqueries CANNOT be nested by more than two levels.
    • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
    • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

    正确答案:B,F

  • 第18题：

    多选题
    Which two statements are true about applying Host Checker at the realm level?（）
    A

    If Evaluate is checked then the client must pass policy to get the sign-in page.

    B

    If Evaluate is checked then the client can fail policy and still get the sign-in page.

    C

    If Require and Enforce is checked then the client must pass policy to get the sign-in page.

    D

    If Require and Enforce is checked then the client can fail policy and still get the sign-in page.


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

  • 第19题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

  • 第20题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Areas（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


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

  • 第21题：

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第22题：

    单选题
    The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）
    A

    The results are not sorted.

    B

    The results are sorted numerically.

    C

    The results are sorted alphabetically.

    D

    The results are sorted numerically and then alphabetically.


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

  • 第23题：

    多选题
    Which two statements about subqueries are true? （）
    A

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


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

相关内容