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
Ans : B
Explanation: Pl/Sql was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.
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
Ans : D
Explanation: All of the above is true about Pl/Sql.
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
Ans : D
Explanation: All of the above are Features of PL/SQL.
4. PL/SQL provides high security level.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, PL/SQL provides high security level
5. Every PL/SQL statement ends with a ?
A. colon
B. questionmark
C. semicolon
D. dollar sign
View Answer
Ans : C
Explanation: Every PL/SQL statement ends with a semicolon (;).
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
Ans : C
Explanation: PL/SQL blocks can be nested within other PL/SQL blocks using BEGIN and END.
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
Ans : D
Explanation: All of the above are Advantages of PL/SQL
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
Ans : C
Explanation: The PL/SQL supports single-line and multi-line comments.
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
Ans : A
Explanation: True, PL/SQL provides support for Object-Oriented Programming.
10. PL/SQL identifiers are?
A. constants
B. variables
C. exceptions
D. All of the above
View Answer
Ans : D
Explanation: PL/SQL identifiers are constants, variables, exceptions, procedures, cursors, and reserved words.
Discussion