Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? ()
第1题:
A. 0
B. 1
C. 0.00
D. An error statement
第2题:
A. 0
B. 1
C. 0.00
D. An error statement
第3题:
A.46 and 45
B.46 and 45.93
C.50 and 45.93
D.50 and 45.9
第4题:
Which three SELECT statements display 2000 in the format "$2,000.00"? ()
第5题:
Which three SELECT statements displays 2000 in the format “$2,000.00”?()
第6题:
A. 17000.00
B. 17000*****
C. ****170.00
D. **17000.00
E. an error statement
第7题:
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?()
第8题:
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
第9题:
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?()
第10题:
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?()