单选题Which SQL statement returns a numeric value?（）ASELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;BSELECT ROUND(hire_date) FROM EMP;CSELECT sysdate-hire_date FROM EMP;DSELECT 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;
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
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.
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.
Which kind of non－sourced UDF can be created so that it only returns a single value?() A.RowB.TableC.ScalarD.Column
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.
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 variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application
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.
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 PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement
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
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.
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.
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 userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources
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
Which of the following cannot be used as input to the SQL Tuning Advisor？（）A、 A single SQL statement provided by a userB、 An existing SQL Tuning Set （STS）C、 A preprocessed Database Replay workloadD、 A schema nameE、 SQL statement identified in EM as using excessive resources
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
单选题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 variableB the value of the NLS_TERRITORY variableC the value of the NLS_CURRENCY variableDthe character encoding scheme used by the client application
多选题Which two statements are true about mouse button variables?（）ASYSTEM.MOUSE_BUTTON_PRESSED returns a string.BSYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.comCA possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete.DSYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers.ESYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.
多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement
单选题Which kind of non-sourced UDF can be created so that it only returns a single value?（）ARowBTableCScalarDColumn
单选题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？（）ADefaultBSAFECEXTERNAL ACCESSDUNSAFE
多选题Which four statements correctly describe functions that are available in SQL? （）AINSTR returns the numeric position of a named character.BNVL2 returns the first non-null expression in the expression list.CTRUNCATE rounds the column, expression, or value to n decimal places.DDECODE translates an expression after comparing it to each search value.ETRIM trims the heading of trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.GNULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.
单选题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?（）AThe tuned plan is not added to the SQL plan baseline.BThe tuned plan is added to the fixed SQL plan baseline as a fixed plan.CThe tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.DThe tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）AA text copy of the control file.BA binary copy of the control file.CA file containing a SQL statement which will re-create the database.DA file containing a SQL statement which will re-create the control file.
单选题Which statement is true regarding the COALESCE function?（）AIt can have a maximum of five expressions in a list BIt returns the highest NOT NULL value in the list for all rows CIt requires that all expressions in the list must be of the same data type DIt requires that at least one of the expressions in the list must have a NOT NULL value
多选题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？（）ACreate a function that returns a list of values that represent the login times for the given user.BCreate a function that returns a list of values that represent the people who have logged more hours than the current user has logged.CCreate a function that returns a numeric value that represents the number of hours that a user has logged for the current day.DCreate a function that returns a numeric value that represents the number of hours that a user has logged for the current month.