Data Base Practice Questions

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





Show Answer ?

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





Show Answer ?

23. The correct syntax of DECODE stament is





Show Answer ?

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





Show Answer ?

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





Show Answer ?

26. A procedure which return a value is called as





Show Answer ?

27. Data stored in the curser is called as _______





Show Answer ?

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





Show Answer ?

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





Show Answer ?

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





Show Answer ?