Cursor MCQ Questions And Answers

Cursor MCQs : This section focuses on "Cursor" in Pl/Sql. These Multiple Choice Questions (MCQs) should be practiced to improve the Pl/Sql skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.

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

A. records
B. cursor
C. packages
D. trigger

View Answer


2. PL/SQL controls the context area through a cursor.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


3. The set of rows the cursor holds is referred to as the __________.

A. inactive set
B. simple set
C. active set
D. complex set

View Answer


4. How many types of cursors?

A. 1
B. 2
C. 3
D. 4

View Answer


5. Programmers cannot control the _______ cursors and the information in it.

A. implicit
B. explicit
C. both a and b
D. Can not say

View Answer


6. Which attribute returns TRUE if an INSERT, UPDATE, or DELETE statement affected one or more rows?

A. %NOTFOUND
B. %ISOPEN
C. %ROWCOUNT
D. %FOUND

View Answer


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

A. SELECT cursor_name
B. INSERT cursor_name
C. UPDATE cursor_name
D. OPEN cursor_name

View Answer


8. Oracle creates ___________ when SQL statements are processed.

A. Content Areas
B. Context Areas
C. Context Ids
D. Content Ids

View Answer


9. The Implicit cursors are created in order to process the ____ statements.

A. DDL
B. DCL
C. DML
D. TCL

View Answer


10. Explicit cursors are programmer-defined cursors for gaining more control over the context area.

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer





Discussion


* You must be logged in to add comment.