data base technologies multiple choice questions and answers practice questions mcqs page 3

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 ?