31. ________ Collection of stored procedures and functions
Answer : Package.
32. Cleaning up temporary segments that are no longer in in use is done by __________
Answer : SMON.
33. Actual data of oracle is stored in ________
Answer : DATA tablespace.
34. The Tool used to create package is called as ____
Answer : SQL *PLUS.
35. Rollback and Commit affect
Answer : Only DML statements.
36. The value of INSTR(‘CALIFORNIA’,’A’,1,2) is
Answer : 10.
37. The number of users that can be handled by Oracle 8i server is approximately
Answer : 10000.
38. An entity is an
Answer : both.
39. A table having only one attribute as a key is always in _____________
Answer : Second Normal Form.
40. Needs of Normalisation are
Answer : All above.