CS405 Quiz 4 Set 2

Q1. cursor are declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.

1. Explicit
2. Implicit
3. Internal
4. External

Correct answer: Implicit

Q2. A _____ is a pointer to this context area.

1. cursor
2. packages
3. records
4. trigger

Correct answer: cursor

Q3. Which of the following is correct syntax to open the Cursor?

1. OPEN cursor_name
2. INSERT cursor_name
3. SELECT cursor_name
4. UPDATE cursor_name

Correct answer: OPEN cursor_name

Q4. When is an implicit cursor used?

1. DDL statement is run and the statements are not associated with any explicit cursor.
2. SELECT or DML statement is run and not associated with any cursor variable.
3. SELECT statement is run even if the statements are associated with explicit cursor.
4. SELECT/DML statement is run and the statements are not associated explicit cursor.

Correct answer: SELECT/DML statement is run and the statements are not associated explicit cursor.

Q5. Which of the following statements is true about implicit cursors?

1. Implicit cursors are used in cursor for loops to handle data processing.
2. Implicit cursors are no longer a feature in Oracle.
3. Developers should use implicit cursors with great care.
4. Implicit cursors are used for SQL statements that are not named.

Correct answer: Implicit cursors are used for SQL statements that are not named.

Q6. What is the maximum number of exception handlers processed before the PL/SQL block is exited, provided an exception occurs?

1. All exceptions that are referenced in the block
2. One
3. None
4. All exceptions that apply

Correct answer: One

Q7. cursors are declared and used by the user to process multiple row, returned by SELECT statement.

1. External
2. Implicit
3. Explicit
4. Internal

Correct answer: Explicit

Q8. Which of the following is not correct about Cursor?

1. Cursor is used for retrieving multiple rows
2. SQL uses implicit Cursors to retrieve rows
3. Cursor holds temporary results
4. Cursor is a named Private SQL area

Correct answer: Cursor is a named Private SQL area

Q9. How many rows can a cursor hold?

1. One to ten
2. One or more
3. One only
4. Zero only

Correct answer: One or more

Q10. Which type of cursor does an implicit and explicit cursor belong to?

1. Operating System cursor
2. Session cursor
3. System cursor
4. Database cursor

Correct answer: Database cursor