READ Free Dumps For Oracle- 1z1-051
| Question ID 4806 | Which statement is true regarding synonyms? |
| Option A | A. Synonyms can be created only for a table |
| Option B | B. Synonyms are used to reference only those tables that are owned by another user |
| Option C | C. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid |
| Option D | D. A public synonym and a private synonym can exist with the same name for the same table |
| Correct Answer | D |
| Question ID 4807 | Which statement is true regarding the COALESCE function? |
| Option A | A. It can have a maximum of five expressions in a list |
| Option B | B. It requires that all expressions in the list must be of the same data type |
| Option C | C. It requires that at least one of the expressions in the list must have a NOT NULL value |
| Option D | D. It returns the highest NOT NULL value in the list for all rows |
| Correct Answer | B |