A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these

题目

A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）

  • A、difference, projection, join
  • B、selection, projection, join
  • C、selection, intersection, join
  • D、intersection, projection, join
  • E、difference, projection, product
相似考题

1.An(73)statement can perform. a calculation and store the result in a variable so that it can be used later。A．assignmentB．executableC．inputD．output

2.Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()A. NLS_LANGB. NLS_COMPC. NLS_SORTD. None of the above

3.l An (5) statement can perform. a calculation and store the result in a variable so that it can be used later.A. executableB.inputC.outputD. assignment

4.In which four clauses can a subquery be used? ()A. in the INTO clause of an INSERT statementB. in the FROM clause of a SELECT statementC. in the GROUP BY clause of a SELECT statementD. in the WHERE clause of a SELECT statementE. in the SET clause of an UPDATE statementF. in the VALUES clause of an INSERT statement

更多“A SELECT statement can be used ”相关问题

  • 第1题：

    An ______ statement can perform. a calculation and store the result in a variable so that it can be used later.

    A．executable

    B．input

    C．output

    D．assignment


    正确答案：D
    解析：译文的含义是：()语句可以执行计算，并将结果存储在变量中，以便以后使用。选项A、B、C、D的含义分别是可执行、输入、输出、赋值。选项D符合题意，为所选。

  • 第2题：

    What is a sub-select statement?

    A．a select statement that selects a subset of fields in a table

    B．a select statement that returns a subset of the data in a table

    C．a select statement that appears within another select statement

    D．a select statement that returns a subset of the constraints on a field


    正确答案：C

  • 第3题：

    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）

    • A、NLS_LANG
    • B、NLS_COMP
    • C、NLS_SORT
    • D、None of the above

    正确答案:D

  • 第4题：

    Which statement is false about sales catalogs？（）

    • A、Sales catalogs are used for customer display purposes.
    • B、With a sales catalog products can be placed in many locations.
    • C、If sales catalogs are used then it is not necessary to have a master catalog.
    • D、Sales catalogs can be used to target specific customer segments.
    • E、Sales catalogs can be used to control what products a customer can see.

    正确答案:C

  • 第5题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第6题：

    Where can subqueries be used?（）

    • A、field names in the SELECT statement 
    • B、the FROM clause in the SELECT statement 
    • C、the HAVING clause in the SELECT statement
    • D、the GROUP BY clause in the SELECT statement 
    • E、the WHERE clause in only the SELECT statement 
    • F、the WHERE clause in SELECT as well as all DML statements

    正确答案:B,C,F

  • 第7题：

    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

  • 第8题：

    多选题
    Which two statements are true regarding the ORDER BY clause? （）
    A

    It is executed first in the query execution

    B

    It must be the last clause in the SELECT statement

    C

    It cannot be used in a SELECT statement containing a HAVING clause

    D

    You cannot specify a column name followed by an expression in this clause

    E

    You can specify a combination of numeric positions and column names in this clause


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

  • 第9题：

    多选题
    In which four clauses can a subquery be used? （）
    A

    in the INTO clause of an INSERT statement

    B

    in the FROM clause of a SELECT statement

    C

    in the GROUP BY clause of a SELECT statement

    D

    in the WHERE clause of a SELECT statement

    E

    in the SET clause of an UPDATE statement

    F

    in the VALUES clause of an INSERT statement


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

  • 第10题：

    多选题
    Which three are true?（）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


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

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

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

    A subquery can retrieve zero or more rows

    B

    Only two subqueries can be placed atone level

    C

    A subquery can be used only in SQL query statements

    D

    A subquery can appear on either side of a comparison operator

    E

    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement


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

  • 第13题：

    Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?

    A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

    B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

    C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

    D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t


    参考答案：D

  • 第14题：

    In which four clauses can a subquery be used?（）

    • A、in the INTO clause of an INSERT statement
    • B、in the FROM clause of a SELECT statement
    • C、in the GROUP BY clause of a SELECT statement
    • D、in the WHERE clause of a SELECT statement
    • E、in the SET clause of an UPDATE statement
    • F、in the VALUES clause of an INSERT statement

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

  • 第15题：

    Which two statements about views are true? （）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第16题：

    Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

    • A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
    • B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
    • C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
    • D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

    正确答案:D

  • 第17题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第18题：

    Which statement is true regarding Flashback Version Query？ （）

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第19题：

    多选题
    Where can subqueries be used?（）
    A

    field names in the SELECT statement

    B

    the FROM clause in the SELECT statement

    C

    the HAVING clause in the SELECT statement

    D

    the GROUP BY clause in the SELECT statement

    E

    the WHERE clause in only the SELECT statement

    F

    the WHERE clause in SELECT as well as all DML statements


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

  • 第20题：

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

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


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

  • 第21题：

    多选题
    Which two are true about aggregate functions?（）
    A

    You can use aggregate functions in any clause of a SELECT statement.

    B

    You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.

    C

    You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

    D

    You can pass column names, expressions, constants, or functions as parameter to an aggregate function.

    E

    You can use aggregate functions on a table, only by grouping the whole table as one single group.

    F

    You cannot group the rows of a table by more than one column while using aggregate functions.


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

  • 第22题：

    单选题
    Which statement is true regarding Flashback Version Query？（）
    A

     It returns versions of rows only within a transaction.

    B

     It can be used in subqueries contained only in a SELECT statement.

    C

     It will return an error if the undo retention time is less than the lower bound time or SCN specified.

    D

     It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.


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

  • 第23题：

    单选题
    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）
    A

    NLS_LANG

    B

    NLS_COMP

    C

    NLS_SORT

    D

    None of the above


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

  • 第24题：

    单选题
    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）
    A

     NLS_LANG

    B

     NLS_COMP

    C

     NLS_SORT

    D

     None of the above


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

相关内容