Pl/Sql MCQ Questions And Answers

Pl/Sql MCQs : This section focuses on "Basics" of 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. pl/sql was developed by?

A. IBM
B. Oracle
C. Facebook
D. Google

View Answer


2. Which of the following is true?

A. PL/SQL is a completely portable
B. Pl/Sql is a high-performance transaction-processing language
C. PL/SQL provides a built-in, interpreted and OS independent programming environment
D. All of the above

View Answer


3. Which of the following are Features of PL/SQL?

A. PL/SQL is tightly integrated with SQL
B. Pl/sql offers extensive error checking
C. Pl/Sql offers numerous data types
D. All of the above

View Answer


4. PL/SQL provides high security level.

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

View Answer


5. Every PL/SQL statement ends with a ?

A. colon
B. questionmark
C. semicolon
D. dollar sign

View Answer


6. PL/SQL blocks can be nested within other PL/SQL blocks using?

A. Begin
B. End
C. Both A and B
D. None of the above

View Answer


7. Which of the following is/are Advantages of PL/SQL?

A. PL/SQL is strongly integrated with SQL
B. PL/SQL allows sending an entire block of statements to the database at one time
C. PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database
D. All of the above

View Answer


8. The PL/SQL supports?

A. single-line comments
B. multi-line comments
C. single-line and multi-line comments
D. None of the above

View Answer


9. PL/SQL provides support for Object-Oriented Programming.

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

View Answer


10. PL/SQL identifiers are?

A. constants
B. variables
C. exceptions
D. All of the above

View Answer





Discussion


* You must be logged in to add comment.