Oracle/PLSQL MCQs section has MCQs for the preparation FPSC, PTS, NTS, UPSC, and other competitive tests like CSS, PMS, etc. This set of Multiple Choice Questions & Answers (MCQs) focuses on Oracle/PLSQL MCQs for FPSC, PTS, NTS, CSS, UPSC , and PMS. Oracle/PLSQL MCQs questions with answers and explanation for your placement tests and job interviews like FPSC, PTS, NTS, UPSC, and CSS.
A.
All work done by the transaction is undone, as if it had nOt been issued.
B.
Any locks acquired by the transaction are released.
C.
Both A & B
D.
None of the above

A.
B.
Operands
C.
Operators
D.
Both A & B

A.
None of the above
B.
HTF
C.
HTP
D.
Both A & B

A.
None of the above
B.
%ROWTYPE
C.
%TYPE
D.
Both A & B

A.
None of the above
B.
Function
C.
Procedure
D.
Package

A.
None of the above
B.
<>
C.
~=
D.
**

A.
–
B.
Simple CASE Expression
C.
Searched CASE Expression
D.
Both A & B

A.
None of the above
B.
Delimiters
C.
Literals
D.
Comments

A.
None of the above
B.
Error reporting,Character, Datatype conversion
C.
Number,Date,Object reference
D.
Miscellaneous

A.
All mentioned above
B.
Select
C.
Begin
D.
Start
