46 and 45
46 and 45.93
50 and 45.93
50 and 45.9
45 and 45.93
45.95 and 45.93
第1题:
A. 0
B. 1
C. 0.00
D. An error statement
第2题:
Which three SELECT statements displays 2000 in the format “$2,000.00”?()
第3题:
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? ()
第4题:
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?()
第5题:
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?()
第6题:
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?()
第7题:
语句select ROUND(45.953,-1),TRUNC(45.936,2)from dual;的结果是()。
第8题:
17000.00
17000*****
****170.00
**17000.00
an error statement
第9题:
Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join
Difference, projection, product
第10题:
46 and 45
46 and 45.93
50 and 45.93
50 and 45.9
45 and 45.93
45.95 and 45.93
第11题:
0
1
0.00
an error statement
第12题:
SELECT SUBSTR( ‘Hello World’,1) FROM dual;
SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
第13题:
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?()
第14题:
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?()
第15题:
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()
第16题:
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()
第17题:
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? ()
第18题:
Which SQL statement returns a numeric value?()
第19题:
17000.00
17000*****
****170.00
**17000.00
an error statement
第20题:
46 and 45
46 and 45.93
50 and 45.93
50 and 45.9
第21题:
17000.00
17000*****
****170.00
**17000.00
an error statement
第22题:
Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join
Difference, projection, product
第23题:
SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
第24题:
16
100
160
200
150