READ Free Dumps For Oracle- 1z0-001
| Question ID 8132 | Which operator is not appropriate in the joined condition of none equijoin select statement?
|
| Option A | In operator
|
| Option B | Like operators.
|
| Option C | Equal operators.
|
| Option D | Between x and y operator.
|
| Option E | Greater than and equal to operator.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because none equijoin select statement can not contain operator "=" by definition. Incorrect Answers: A: Operator IN can be used in none equijoin select statement. B: Operator LIKE can be used in none equijoin select statement. D: BETWEEN operator can be used in none equijoin select statement. E: Operator ">=" can be used in none equijoin select statement. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 50-53 Chapter 4: Advanced Data Selection in Oracle
| Question ID 8133 | What should you do after each fetch statement in the PL/SQL block?
|
| Option A | Open the cursor.
|
| Option B | Close the cursor.
|
| Option C | Initialize the loop.
|
| Option D | Test for the rows using the cursor attribute.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because after each FETCH statement you should use SQL%NOTFOUND or SQL% FOUND implicit cursor attributes to check whether fetch statement processed any row data from cursor. Incorrect Answers: A: You need to open cursor before first fetch statement usage. You don't need reopen cursor after each FETCH statement. B: You need to close cursor after you finished to use it. You don't need close and reopen cursor after each FETCH statement. C: Loop does not need to be initialised after each FETCH statement, SQL%NOTFOUND or SQL%FOUND implicit cursor attributes will show when you need to exit from the loop. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 224 Chapter 5: Introducing PL/SQL