Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? （）A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9E、45 and 45.93F、45.95 and 45.93
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? （）
- A、46 and 45
- B、46 and 45.93
- C、50 and 45.93
- D、50 and 45.9
- E、45 and 45.93
- F、45.95 and 45.93
相关考题：
语句select ROUND(45.953,－1),TRUNC(45.936,2)from dual;的结果是()。 A.46 and 45B.46 and 45.93C.50 and 45.93D.50 and 45.9
Evaluate the SQL statement:SELECT ROUND(45.953, －1), TRUNC(45.936, 2)FROM dual;Which values are displayed? () A. 46 and 45B. 46 and 45.93C. 50 and 45.93D. 50 and 45.9E. 45 and 45.93F. 45.95 and 45.93
Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),－1),2)FROM dual;What will be displayed? () A. 0B. 1C. 0.00D. An error statement
Evaluate the SQL statement:SELECT LPAD (salary,10,*)FROM EMPWHERE EMP _ ID = 1001;If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?() A. 17000.00B. 17000*****C. ****170.00D. **17000.00E. an error statement
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement
Which three SELECT statements displays 2000 in the format “$2,000.00”?（）A、SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;B、SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;C、SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;D、SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;E、SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;F、SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual;
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;
Which three SELECT statements display 2000 in the format "$2,000.00"? （）A、SELECT TO_CHAR(2000, '$#,###.##') FROM dual;B、SELECT TO_CHAR(2000, '$0,000.00') FROM dual;C、SELECT TO_CHAR(2000, '$9,999.00') FROM dual;D、SELECT TO_CHAR(2000, '$9,999.99') FROM dual;E、SELECT TO_CHAR(2000, '$2,000.00') FROM dual;F、SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
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.
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A、SELECT 1, "2" FROM 3 WHERE last_name = '8';B、SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C、SELECT 1, 2 FROM 3 WHERE last_name = '8';D、SELECT 1, '2' FROM EMP WHERE last_name = '8';
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A、0B、1C、0.00D、An error statement
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）A、SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150
Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement
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;
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;
语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A17000.00B17000*****C****170.00D**17000.00Ean error statement
单选题Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A17000.00B17000*****C****170.00D**17000.00Ean error statement
单选题语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9
单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A17000.00B17000*****C****170.00D**17000.00Ean error statement
单选题Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9E45 and 45.93F45.95 and 45.93
单选题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?（）ASelection, projection, joinBDifference, projection, joinCSelection, intersection, joinDIntersection, projection, joinEDifference, projection, product
单选题Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）ASELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;BSELECT TO_DATE(SYSDATE,'yyyy') FROM dual;CSELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;DSELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;ESELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
单选题Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）ASELECT SUBSTR( ‘Hello World’,1) FROM dual;BSELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;CSELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;DSELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;ESELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A16 B100 C160 D200 E150