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

Suggestions