READ Free Dumps For Oracle- 1z1-051
| Question ID 4767 | See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table: |
| Option A | A. It produces an error because the NATURAL join can be used only with two tables |
| Option B | B. It produces an error because a column used in the NATURAL join cannot have a qualifier |
| Option C | C. It produces an error because all columns used in the NATURAL join should have a qualifier |
| Option D | D. It executes successfully |
| Correct Answer | B |
| Question ID 4768 | You work as a database administrator at ABC.com. You study the exhibit carefully. You want to create a SALE_PROD view by executing the following SQL statements: Exhibit: |
| Option A | A. The view will be created and you can perform DLM operations on the view |
| Option B | B. The view will not be created because the join statements are not allowed for creating a view |
| Option C | C. The view will not be created because the GROUP BY clause is not allowed for creating a view |
| Option D | D. The view will be created but no DML operations will be allowed on the view |
| Correct Answer | D |
