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

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

相似考题

1.Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

2.Evaluate this SQL statement:What will happen if you remove all the parentheses from the calculation?()A. The value displayed in the CALC_VALUE column will be lower.B. The value displayed in the CALC_VALUE column will be higher.C. There will be no difference in the value displayed in the CALC_VALUE column.D. An error will be reported.

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.

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.

更多“Which SQL statement returns a numeric value?（）”相关问题

  • 第1题：

    Evaluate the SQL statement:What is the result of the statement?()

    A. The statement produces an error at line 1.

    B. The statement produces an error at line 3.

    C. The statement produces an error at line 6.

    D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

    E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.


    参考答案：E

  • 第2题：

    Which statements concerning the value of a member variable are true， when no explicit assignments have been made？（）  

    • A、The value of an int is undetermined.
    • B、The value of all numeric types is zero.
    • C、The compiler may issue an error if the variable is used before it is initialized.
    • D、The value of a String variable is "" （empty string）.
    • E、The value of all object variables is null.

    正确答案:B,E

  • 第3题：

    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）

    • A、A text copy of the control file.
    • B、A binary copy of the control file.
    • C、A file containing a SQL statement which will re-create the database.
    • D、A file containing a SQL statement which will re-create the control file.

    正确答案:D

  • 第4题：

    When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? （）

    • A、Timeout  
    • B、SQL Error  
    • C、Successful  
    • D、Connection Not Available  

    正确答案:C

  • 第5题：

    Which four statements correctly describe functions that are available in SQL? （）

    • A、INSTR returns the numeric position of a named character.
    • B、NVL2 returns the first non-null expression in the expression list.
    • C、TRUNCATE rounds the column, expression, or value to n decimal places.
    • D、DECODE translates an expression after comparing it to each search value.
    • E、TRIM trims the heading of trailing characters (or both) from a character string.
    • F、NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
    • G、NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

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

  • 第6题：

    Which statement is true regarding the COALESCE function?（）

    • A、It can have a maximum of five expressions in a list 
    • B、It returns the highest NOT NULL value in the list for all rows 
    • C、It requires that all expressions in the list must be of the same data type 
    • D、It requires that at least one of the expressions in the list must have a NOT NULL value

    正确答案:C

  • 第7题：

     Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set.  Which permission set should you use? （）

    • A、 Default 
    • B、 SAFE 
    • C、 EXTERNAL_ACCESS 
    • D、 UNSAFE

    正确答案:C

  • 第8题：

    多选题
    Which two statements are true about mouse button variables?（）
    A

    SYSTEM.MOUSE_BUTTON_PRESSED returns a string.

    B

    SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com

    C

    A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete.

    D

    SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers.

    E

    SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.


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

  • 第9题：

    单选题
    Which kind of non-sourced UDF can be created so that it only returns a single value?（）
    A

    Row

    B

    Table

    C

    Scalar

    D

    Column


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

  • 第10题：

    多选题
    Which four statements correctly describe functions that are available in SQL? （）
    A

    INSTR returns the numeric position of a named character.

    B

    NVL2 returns the first non-null expression in the expression list.

    C

    TRUNCATE rounds the column, expression, or value to n decimal places.

    D

    DECODE translates an expression after comparing it to each search value.

    E

    TRIM trims the heading of trailing characters (or both) from a character string.

    F

    NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.

    G

    NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.


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

  • 第11题：

    单选题
    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）
    A

    A text copy of the control file.

    B

    A binary copy of the control file.

    C

    A file containing a SQL statement which will re-create the database.

    D

    A file containing a SQL statement which will re-create the control file.


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

  • 第12题：

    多选题
    TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）
    A

    Create a function that returns a list of values that represent the login times for the given user.

    B

    Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.

    C

    Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.

    D

    Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.


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

  • 第13题：

    Which kind of non－sourced UDF can be created so that it only returns a single value?()

    A.Row

    B.Table

    C.Scalar

    D.Column


    参考答案：C

  • 第14题：

    You issued the following statement：   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1；   Which parameter is NOT overridden by using the above statement？（）  

    • A、 the value of the NLS_LANGUAGE variable
    • B、 the value of the NLS_TERRITORY variable
    • C、 the value of the NLS_CURRENCY variable
    • D、the character encoding scheme used by the client application

    正确答案:C

  • 第15题：

    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

  • 第16题：

    Which two statements are true about mouse button variables?（）

    • A、SYSTEM.MOUSE_BUTTON_PRESSED returns a string. 
    • B、SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com 
    • C、A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete. 
    • D、SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers. 
    • E、SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action. 

    正确答案:B,E

  • 第17题：

    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

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

    单选题
    You issued the following statement：   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1；   Which parameter is NOT overridden by using the above statement？（）
    A

     the value of the NLS_LANGUAGE variable

    B

     the value of the NLS_TERRITORY variable

    C

     the value of the NLS_CURRENCY variable

    D

    the character encoding scheme used by the client application


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

  • 第20题：

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


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

  • 第21题：

    单选题
    Application developers in TestKing.com create an assembly that contains a CLR function.This CLR function reads data from a spreadsheet， performs some calculations， and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use？（）
    A

    Default

    B

    SAFE

    C

    EXTERNAL ACCESS

    D

    UNSAFE


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Which statement is true regarding the COALESCE function?（）
    A

    It can have a maximum of five expressions in a list 

    B

    It returns the highest NOT NULL value in the list for all rows 

    C

    It requires that all expressions in the list must be of the same data type 

    D

    It requires that at least one of the expressions in the list must have a NOT NULL value


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

相关内容