READ Free Dumps For Oracle- 1z1-051
Question ID 4785 | See the Exhibit and examine the structure of the SALES table: |
Option A | A. It produces an error because COUNT (*) should be specified the SELECT clause also |
Option B | B. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*) |
Option C | C. It executes successfully and generates the required result |
Option D | D. It produces an error because COUNT (*) should be only the HAVING clause and not in the WHERE clause |
Correct Answer | D |
Question ID 4786 | When does a transaction complete? (Choose all that apply.) |
Option A | A. When a PL/SQL anonymous block is executed |
Option B | B. When a DELETE statement is executed |
Option C | C. When a data definition language statement is executed |
Option D | D. When a TRUNCATE statement is executed after the pending transaction |
Option E | E. When a ROLLBACK command is executed |
Correct Answer | C,D,E |