READ Free Dumps For Oracle- 1z1-051
| Question ID 4878 | Which two statements are true regarding the ORDER BY clause? (Choose two.) |
| Option A | A. It is executed first in the query execution. |
| Option B | B. It must be the last clause in the SELECT statement. |
| Option C | C. It cannot be used in a SELECT statement containing a HAVING clause. |
| Option D | D. You cannot specify a column name followed by an expression in this clause. |
| Option E | E. You can specify a combination of numeric positions and column names in this clause. |
| Correct Answer | B,E |
| Question ID 4879 | Which two statements are true regarding the USING clause in table joins?(Choose two.) |
| Option A | A. It can be used to join a maximum of three tables. |
| Option B | B. It can be used to restrict the number of columns used in a NATURAL join. |
| Option C | C. It can be used to access data from tables through equijoins as well as nonequijoins. |
| Option D | D. It can be used to join tables that have columns with the same name and compatible data types. |
| Correct Answer | B,D |