24: In which three cases would you use the USING clause? (Choose three.)
A.You want to create a nonequijoin.
B.The tables to be joined have multiple NULLcolumns.
C.The tables to be joined have columns of the same name and different data types.
D.The tables to be joined have columns with the same name and compatible data types.
E.You want to use a NATURAL join, but you want to restrict the number of columns in the join
condition.
http://llhdf.**.com/blog/275795
38: For which two actions can you use the TO_DATE function? (Choose two.)
A.convert any date literal to a date
B.convert any numeric literal to a date
C.convert any date to a character literal
D.format 'January 10 1999' for input
E.format '10-JAN-99' to 'January 10 1999
http://topic.csdn.net/u/20090329/10/0c388d76-9e8d-42e2-afc4-7893b3b13c61.html
0: A subquery can be used to ___.
A.create groups of data
B.sort data in a specific order
C.convert data to a different format
D.retrieve data based on an unknown condition
why answer is D
43: Evaluate the SQLstatement:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
What will be displayed
SQL> SELECT ROUND(9.00,2) FROM dual;
ROUND(9.00,2)
-------------
9
SQL> SELECT ROUND(0.00,2) FROM dual;
ROUND(0.00,2)
-------------
0
SQL> SELECT ROUND(0.01,2) FROM dual;
ROUND(0.01,2)
-------------
.01
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14730395/viewspace-675199/ ，如需转载，请注明出处，否则将追究法律责任。
