Data Base Practice Questions

31. ________ Collection of stored procedures and functions

A. Functions 

B. Procedures 

C. Triggers 

D. Package 

32. Cleaning up temporary segments that are no longer in in use is done by __________

A. LGWR 

B. PMON 

C. DBWR 

D. SMON 

33. Actual data of oracle is stored in ________

A. SYSTEM tablespace 

B. DATA tablespace 

C. USER tablespace 

D. TOOL tablespace 

34. The Tool used to create package is called as ____

A. SQL 

B. SQL *PLUS 

C. Both 

D. None of the above 

35. Rollback and Commit affect

A. Only DML statements 

B. Only DDL statements 

C. Both (a) and (b) 

D. All statements executed in SQL*PLUS 

36. The value of INSTR(‘CALIFORNIA’,’A’,1,2) is

A. 2 

B. 1 

C. 10 

D. 9 

37. The number of users that can be handled by Oracle 8i server is approximately

A. 5000 

B. 10000 

C. 1000 

D. 100000 

38. An entity is an

A. object with physical existence 

B. object with conceptual existence 

C. both 

D. none 

39. A table having only one attribute as a key is always in _____________

A. First Normal Form 

B. Second Normal Form 

C. Third Normal Form 

D. None of the above 

40. Needs of Normalisation are

A. Improves database design 

B. Ensures minium redundancy of data 

C. Removes anomalies 

D. All above 

• 1
• 2
• 3
• 4
• 5