READ Free Dumps For Oracle- 1z0-001
Question ID 1512 | The EMPLOYEE table contains these columns: |
Option A | A. The statements will retrieve different data from the database. |
Option B | B. Statement 1 will execute, but statement 2 will not. |
Option C | C. Statement 2 will execute, but statement 1 will not. |
Option D | D. The statements will retrieve the same data from the database, but will display it differently. |
Correct Answer | A |
Question ID 1513 | Which statement is true when writing a cursor FOR loop? |
Option A | A. You do not explicitly open, fetch or close the cursor within a cursor FOR loop . |
Option B | B. You must explicitly close the cursor prior to the end of the program. |
Option C | C. You must explicitly fetch the rows within a cursor FOR loop. |
Option D | D. You must explicitly declare the record variable that holds the row returned from the cursor. |
Correct Answer | A |