1. ………………….. are used to recreate if trigger already exists.
A) Cursor
B) Trigger
C) Keywords
D) Replace
2. ………………………… is used to define code that is executed/fired when certain actions or event occur.
A) Cursor
B) Trigger
C) Keywords
D) Replace
3. …………….. provide a way for your program to select multiple rows of data from the database and then process each row individually.
A) PL/SQL Cursors
B) PL/SQL Trigger
C) PL/SQL Select
D) PL/SQL Process
4. ……………………… cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.
A) Implicit
B) Explicit
C) Internal
D) External
5. ……………………. cursors are declared and used by the user to process multiple row, returned by SELECT statement.
A) Implicit
B) Explicit
C) Internal
D) External
6. ………………….. contain a pointer that keeps track of the current row being accessed, which enables your program to process the rows at a time.
A) Tracker
B) Cursor
C) Accesser
D) Trigger
7. ………………….. a cursor enables you to define the cursor and assign a name to it.
A) Declaring
B) Stating
C) Extracting
D) Importing
8. In ………………. the cursor advances to the next row in the active set each time the fetch command is executed.
A) recreating the process
B) redefining the process
C) iterative process
D) None of the above
9. A ……………………. is a database object that groups logically related PL/SQL types, objects and subprograms.
A) Module
B) Package
C) Body
D) Name
10. In the PL/SQL, the package specification contains ………………….. declarations.
A) Public
B) Private
C) Friend
D) Protected
Answers:
1. D) Replace
2. B) Trigger
3. A) PL/SQL Cursors
4. A) Implicit
5. B) Explicit
6. B) Cursor
7. A) Declaring
8. C) iterative process
9. B) Package
10.A) Public
Read Next: Solved MCQ of Oracle and Distributed Databases set-3
Read More: Collections of DBMS MCQ questions
Download: Free PDF E-book of DBMS MCQ questions
Comments are closed.