PL SQL Practice Test 7

PL SQL Practice Test 7

PL-SQL-Objective-Questions-NareshITIn a stored procedure, when specifying a string parameter should use which of these ?

  1. Char
  2. varchar2
  3. TEXT
  4. REAL

Ans : 2


A Stored Procedure is a

  1. Sequence of SQL or PL/SQL statements to perform specific function
  2. Stored in compiled form in the database
  3. Can be called from all client environments
  4. All of the above

Ans : 4


Which of the following is true ,Creating a procedure have compile errors.?

  1. The line numbers reported match the line numbers you see in your text editor.
  2. SQL*Plus will automatically show the errors to you.
  3. To see the errors, enter SHOW ERRORS in SQL*Plus.
  4. If there are no syntax errors, you will receive the message “NO ERRORS.”

Ans : 3


Which of the following are the advantages of PL/SQL Packages?

  1. Modularity
  2. Easier Application Design
  3. Information Hiding
  4. All the above

Ans : 4


A package will have which of these mandatory parts?

  1. Package specification
  2. Package body or definition
  3. Both A & B
  4. None of the above

Ans : 3


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


You can pass parameters to procedures or functions in a package.

  1. True
  2. False
  3. Depends upon
  4. None of the above

Ans : 1


Which package lets PL/SQL programs read and write (OS) text files?

  1. UTL_FILE
  2. DBMS_TEXT
  3. UTL_HTTP
  4. UTL_SMTP

Ans : 1


Which of the following is not a schema object?

  1. Packages
  2. Indexes
  3. Public Synonyms
  4. Triggers

Ans : 3


In the PL/SQL, the package specification contains ………………….. declarations.

  1. Public
  2. Private
  3. Friend
  4. Protected

Ans : 1


Is it possible to open a cursor which is in a Package in another procedure ?

  1. Yes
  2. No
  3. May or may not possible
  4. None of the above

Ans : 1


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


Which of the following is true about PL/SQL package body?

  1. The package body has methods declared in package specification and private.
  2. It is created using the CREATE PACKAGE Statement.
  3. Methods and types declared in package body are not hidden from code outside
  4. All of the above.

Ans :1


All objects placed in a package specification are called

  1. Public objects.
  2. Private objects.
  3. None of the above.
  4. Both of the above.

Ans : 1


Which of the following syntax will be used to access a package element?

  1. package_name element_name;
  2. package_name;
  3. element_name;
  4. None of the above.

Ans : 3


Which of the following is not a PL/SQL unit?

  1. Table
  2. Type
  3. Trigger
  4. Package

Ans : 1


Which of the following is not true about PL/SQL package specifications?

  1. The specification is the interface to the package.
  2. It declares the types, variables, subprograms that can be referenced from outside
  3. Contains all information about the content of the package and the
  4. None of the above.

Ans : 3


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


Any subprogram not in the package specification but coded in the package body is called a

  1. Public object.
  2. Private object.
  3. None of the above.
  4. Both of the above.

Ans : 2


Which is a database object that groups logically related PL/SQL types, objects ,subprograms.

  1. Module
  2. Package
  3. Body
  4. Name

Ans : 2


What can you do with the DBMS_LOB package?

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

Ans : 4


Which Oracle supply package allows you to run jobs at use defined times?

  1. DBMS_JOB
  2. DBMS_RUN
  3. DBMS_PIPE
  4. DBMS_SQL

Ans : 1


How do you implement cannot drop a table from a stored procedure.

  1. Use the DROP command in the procedure to drop the table.
  2. Use the DBMS_DDL packaged routines in the procedure to drop the table.
  3. Use the DBMS_SQL packaged routines in the procedure to drop the table.
  4. Use the DBMS_DROP packaged routines in the procedure to drop the table.

Ans : 4


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


Which  programming constructs can be grouped within a package?

  1. Cursor
  2. Constant
  3. Trigger
  4. Cursor and Constant

Ans : 4


Which Oracle s package is used to enable HTTP callouts from PL/SQL?

  1. DBMS_DDL
  2. UTL_HTTP
  3. UTL_SMTP
  4. UTL_URL

Ans : 2


Which procedure of the dbms_output  package append text to the current line of output ?

Ans : 4


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


Azure-devops- online training
Python online traning
MS-Azure-online training
Angular9 online training
AWS online training

Specialization on Trending Courses

Linix online training
Advance Spring online training
fullstack online training
Core java onlne training
Android online training
C#-net online training
SQL online training