READ Free Dumps For Oracle- 1z0-007
Question ID 1742 | In which three cases would you use the USING clause? (Choose three.) |
Option A | A. The tables to be joined have columns of the same name and different data types. |
Option B | B. The tables to be joined have multiple NULL columns. |
Option C | C. You want to create a nonequijoin. |
Option D | D. You want to use a NATURAL join, but you want to restrict the number of columns in the join condition. |
Option E | E. The tables to be joined have columns with the same name and compatible data types. |
Correct Answer | A,D,E |
Question ID 1743 | For which two actions can you use the TO_DATE function? (Choose two.) |
Option A | A. format 'January 10 1999' for input |
Option B | B. convert any numeric literal to a date |
Option C | C. format '10-JAN-99' to 'January 10 1999' |
Option D | D. convert any date literal to a date |
Option E | E. convert any date to a character literal |
Correct Answer | A,D |