Oracle/PLSQL MCQS

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.

Q: Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?

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


View Answer

Q: Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?

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


View Answer

Q: PL/SQL Expressions are constructed using?

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


View Answer

Q: Which of the following are used for displaying output on a web page?

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


View Answer

Q: Which of the following is used to declare a record?

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


View Answer

Q: Which of the following has a return type in its specification and must return a value specified in that type?

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


View Answer

Q: From the following PL/SQL Delimiters which symbol is exponentiation operator?

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


View Answer

Q: In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?

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


View Answer

Q: Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier?

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


View Answer

Q: PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?

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


View Answer