PL SQL MCQ Questions 8

PL SQL MCQ Questions 8

PL-SQL-Objective-Questions-NareshITWhich statement is package specification or body of a stored subprogram?

  1. Package Specification only requires recompilation
  2. Package body only requires recompilation
  3. Both package & body requires recompilation
  4. Both package & body does not require recompilation.

Ans : 1


The packaged procedure that makes data in form permanent in the Database is

  1. Post
  2. Post form
  3. Commit form
  4. None of the above

Ans :  3


Which of the following do not execute multiple PL/SQL programs simultaneously?

  1. Oracle Advanced Queuing
  2. DBMS_JOB
  3. DBMS_SQL
  4. Pipelined Functions

Ans : 3


Which package can you use to output values and messages stored procedures?

  1. DBMS_DISPLAY
  2. DBMS_OUTPUT
  3. DBMS_LIST
  4. DBMS_DESCRIBE

Ans : 2


Which of the  package statement is  true?

  1. Packages can be nested.
  2. You can pass parameters to packages.
  3. A package is loaded into memory each time it is invoked.
  4. The contents of packages can be shared by many applications.

Ans : 4


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Which state of a package variable after executing the package is declared?

  1. It persists across transactions within a session.
  2. It persists from session to session for the same user.
  3. It does not persist across transaction within a session.
  4. It persists from user to user when the package is invoked.

Ans : 1


What can you do with the DBMS_LOB package?

  1. WRITE procedure to write data to a BFILE.
  2. BFILENAME function to locate an external BFILE.
  3. FILEEXISTS function to find the location of a BFILE.
  4. FILECLOSE procedure to close the file being accessed.

Ans : 4


Which Package use database triggers to application when specific db values change?

  1. DBMS_OUTPUT
  2. DBMS_ALERT
  3. DBMS_PIPE
  4. All mentioned above

Ans : 2


What function you are using to load the data in UTL_FILE package?

  1. Fopen()
  2. file_open()
  3. isopen()
  4. fileopen()

Ans : 1


Which is not in UTL_FILE function?

  1. FOPEN()
  2. File_CLOSE()
  3. FCOPY()
  4. FFLUH()

Ans : 2


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Can we load the data from table to table through utl_file package?

  1. Yes
  2. No
  3. Depends upon
  4. Invalid option

Ans : 1


What is the disadvantage of Packages?

  1. Memory wastage
  2. Performance
  3. data Hiding
  4. modularity

Ans : 1


Pl/sql packages supports polymorphism?

  1. True
  2. False
  3. Depends upon
  4. Invalid option

Ans : 1


PL/SQL package consists of?

  1. Datatypes
  2. columns
  3. tables
  4. synonyms

Ans : 3


How can you generate debugging output from PL/SQL?

  1. DBMS_SQL
  2. DBMS_OUTPUT
  3. DBMS_PIPE
  4. DBMS_LOB

Ans : 2


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Which is oracle supplied package?

  1. DBMS_SQL
  2. DB_ORACLE
  3. DB_SQl
  4. DBMS_OBJ

Ans : 1


Which of the following procedures of DBMS_SQL supports bulk DML operations?

  1. BIND_VARIABLE_CHAR
  2. BIND_VARIABLE_RAW
  3. BIND_ARRAY
  4. BIND_VARIABLE

Ans : 3


How STANDARD Package Defines the PL/SQL Environment?

  1. The package specification declares public types, variables, subprograms
  2. The package specification declares private
  3. A & B
  4. None of the above

Ans : 1


A __________ is a special kind of a store procedure that executes in response to certain actions.

  1. Procedures
  2. Triggers
  3. Functions
  4. None of the mentioned

Ans :  2


Under which circumstance do you design database triggers?

  1. To duplicate the functionality of other triggers.
  2. To replicate built-in constraints in the Oracle server such as primary key and foreign key.
  3. When a specific operation is performed, related actions are performed.
  4. None of the above

Ans : C


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


What is a condition predicate in a DML trigger?

  1. Specify a WHEN-LOGGING-ON condition in the trigger body.
  2. Use the NEW and OLD qualifiers in the trigger body as a condition.
  3. Combine several DBM triggering events into one in the trigger body.
  4. Specify a SHUTDOWN or STARTUP condition in the trigger body.

Ans : 3


Which of the following is true concerning triggers?

  1. You do not create them with SQL.
  2. They execute against only some applications that access a database.
  3. They have an event, condition, and action.
  4. They cannot cascade (cause another trigger to fire).

Ans : 3


What is the maximum number of triggers that can apply to a single table?

  1. 14
  2. 10
  3. 12
  4. 16

Ans : 3


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Read More PL/SQL Objective Questions and Answers

Click Here
Click Here
Click Here
PL/SQL Objectives 1
PL/SQL Objectives 2
PL/SQL Objectives 3
PL/SQL Objectives 4
PL/SQL Objectives 5
PL/SQL Objectives 6
PL/SQL Objectives 7
PL/SQL Objectives 8
PL/SQL Objectives 9
PL/SQL Objectives 10
PL/SQL Objectives 11
PL/SQL Objectives 12
PL/SQL Objectives 13
PL/SQL Objectives 14
PL/SQL Objectives 15

Share this post