MCQ of PL/SQL and Oracle With Answer set -2

1. ....................... are used to recreate if trigger already exists. A) Cursor B) Trigger C) Keywords D) Replace 2. .....................

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 are 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 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) Declearing

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 process

B) redefining 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) Declearing
8. C) iterative process
9. B) Package
10.A) Public

You Might also view the following Related Posts

• Solved MCQ of PL/SQL and Oracle set-1
• Solved MCQ of SQL Server set-1
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of Data Structure Set-2  
• Solved MCQ of Data Structure Set-1
• MCQ of Structured Query Language(SQL) With Answer Set -2
• Solved MCQ of Database Management System (DBMS) Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• Solved MCQ of C set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here