niusouti.com

Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;D、SELECT LOWER(SUBST

题目

Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）

  • A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;
  • B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
  • C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
  • D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
  • E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
相似考题

1.The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;

2.The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber

3.Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product

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

参考答案和解析
正确答案:E
更多“Which SELECT statement will the ”相关问题

  • 第1题：

    Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

    A. Selection, projection, join

    B. Difference, projection, join

    C. Selection, intersection, join

    D. Intersection, projection, join

    E. Difference, projection, product


    参考答案：A

  • 第2题：

    Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?（）

    A.selection, projection, join

    B.difference, projection, join

    C.selection, intersection, join

    D.intersection, projection, join

    E.difference, projection, product


    参考答案：A

  • 第3题：

    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

  • 第4题：

    Which SQL statement returns a numeric value?（）

    • A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
    • B、SELECT ROUND(hire_date) FROM EMP;
    • C、SELECT sysdate-hire_date FROM EMP;
    • D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;

    正确答案:C

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    单选题
    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
    A

    Alice only

    B

    Alice and Reena

    C

    Alice, Reena, and Timber

    D

    Sue, Alice, Reena, and Timber


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

  • 第9题：

    单选题
    A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
    A

    Acquire locks on table queried 

    B

    Generate redo for statement 

    C

    Fetch data from disk into memory 

    D

    Write changes to disk


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

  • 第10题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
    A

    Selection, projection, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    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.


    参考答案：A

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

    • A、SELECT ename, salary*12 'Annual Salary' FROM employees;
    • B、SELECT ename, salary*12 "Annual Salary" FROM employees;
    • C、SELECT ename, salary*12 AS Annual Salary FROM employees;
    • D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

    正确答案:B

  • 第17题：

    Which statement is true regarding the INTERSECT operator?（）

    • A、It ignores NULL values 
    • B、Reversing the order of the intersected tables alters the result 
    • C、The names of columns in all SELECT statements must be identical 
    • D、The number of columns and data types must be identical for all SELECT statements in the query 

    正确答案:D

  • 第18题：

    Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）

    • A、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
    • B、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
    • C、SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
    • D、SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
    • E、SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

    正确答案:A

  • 第19题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
    A

    Selection, projection, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


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

  • 第20题：

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

  • 第21题：

    单选题
    The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）
    A

    DISPATCHER 

    B

    USER 

    C

    SERVER 

    D

    LGWR 

    E

     DBW0


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

  • 第22题：

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

  • 第23题：

    单选题
    The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）
    A

    GRANT select ON dept TO ALL_ USER;

    B

    GRANT select ON dept TO ALL;

    C

    GRANT QUERY ON dept TO ALL_USERS

    D

    GRANT select ON dept TO PUBLIC;


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

  • 第24题：

    单选题
    In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）
    A

    Immediately after the SELECT clause

    B

    Before the WHERE clause

    C

    Before the FROM clause

    D

    After the ORDER BY clause

    E

    After the WHERE clause


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

相关内容