21. The number of BLOB column allowed in Oracle table is

A. 1 

B. 255 

C. 1024 

D. Unlimited 

22. Choose the correct pattern Matching sign for matching a single character

A. _ 

B. ? 

C. * 

D. % 

23. The correct syntax of DECODE stament is

A. DECODE(if1,then1,if2,then2…else) 

B. DECODE(if1,then1,else1,if2,then2,else2…) 

C. DECODE(value,if1,then1,else1,if2,then2,else2….) 

D. none of the above 

24. Which operator, when used along with special operators, reverts their output?

A. NOT 

B. AND 

C. OR 

D. JOIN 

25. Which lock allows multiple users to see the data but not change it

A. exclusive locks  

B. mutative locks  

C. shared locks 

D. table locks 

26. A procedure which return a value is called as

A. Procedure 

B. Function 

C. Package 

D. None of these 

27. Data stored in the curser is called as _______

A. active data 

B. stored data 

C. active data set 

D. user defined data 

28. In which areas of PL/SQL block must code be placed in order to handle Oracle-defined exceptions?

A. Declaration section only 

B. Declaration and executable section only 

C. Exception handler only 

D. Declaration,executable and exception handler sections 

29. Which procedure can be used to create a customised error message

A. RAISE_ERROR 

B. SQLERRM 

C. RAISE_APPLICATION_ERROR 

D. RAISE_SERVER_ERROR 

30. procedure and functions are explicitely executed.This is different from database trigger.When is a database trigger executed

A. when transaction is commited 

B. during the data manipulation statement 

C. when an oracle supplied package references the trigger 

D. during a data manipulation statement and when transaction is commited 

• 1
• 2
• 3
• 4
• 5