Index

Theory

1. Database Management System?
2. Comparison bet. DBMS & Conventional System
3. Importance of Database and DBMS
4. Database System Environment 
5. Functions of DBMS                            
6. Diagram showing difference between database And conventional file  system           
7. Data model & its categories.     
8. The Entity-Relationship (ER) model
9. Advantages and disadvantages of ER model
10. The Object Oriented (OO) model
11. Advantages and disadvantages of OO model
12. Diagram showing comparison between OO data Model and ER model
13. The Relational Model                                             
14. Advantages and disadvantages of Relational model
15. The Network model                         
16. The hierarchical model                                         
17. Degree of abstraction or ANSI/SPARC data model
18. The Conceptual Data Model      
19. Internal Data Model Vs. External Data Model
20. The Physical Data Model              
21. Abstract View of Data                                             
22. Database Administrator                                         
23. Data Integrity        

    Entity Integrity, Referential Integrity       

24. When to enable referential integrity?
25. Insert and Delete rules for Referential Integrity

    Insert Rules, Delete rules

26. Domain Rules for Referential Integrity
27. Primary key and foreign key domains
28. Primary key attributes                                           
29. Composite key, Artificial key and Foreign key

    Composite key,  Artificial key, Foreign key

30. Codd’s 12 rules for Relational Database
31. The Schema and Sub-Schema    
32. Functional Dependencies            
33. Normalization: First, Second, Third, Advanced, Boyce-Codd, Fourth, Fifth
34. Example on Normalization          
35. Steps in Normalization                                           
36. Benefits of RDBMS                            

Oracle-SQL

37. History of Oracle                                
38. New features in Oracle 10g        
39. Starting Oracle 9i                               
40. What is SQL?                                                                 
41. SQL * Plus                                                                       
42. Data types in SQL                               
43. SQL Operators                                                              
44. Create command                               
45. Creating table from another table
46. Alter Table command                                             
47. Drop Table command                                             
48. Insert command                                 
49. Inserting into multiple tables   
50. Update, Delete command                                   
51. Select command                                
52. Exercise on select command     
53. Commit command                            
54. Savepoint, Rollback command                         
55. Example on Savepoint and Rollback
56. Grant and Revoke command     
57. Single value functions (numeric) & their

    examples: Abs, Ceil, Floor, Mod, Power,
    Round, Trunc, Sign, Sqrt

58. Character functions (character) & their examples : Ascii, Chr, Initcap, Instr,  Length, Lower, Lpad, Ltrim, Rpad, Rtrim, Soundex, Substr, Upper, Translate
59. Date Functions & their examples

    Add_month, Last_day
    Months_between, Next_day

60. Miscellaneous functions with example

    Decode, Greatest, Least, Nvl

61. Group value functions ( Aggregate Functions)

    Max, Sum, Count, Avg, Stddev

62. Group By, Having, and Order By clause
63. Creating View                                                               
64. Joins:  Natural, Cross, Outer, Full Outer
65. Hierarchical queries / tree structure
66. Integrity Constraints    

    Domain, Key, Primary, Unique, foreign    

67. Enabling and disabling a constraint
68. Answers to frequently asked queries in Examination 

PL/SQL

69. What is Pl/SQL?                                                           
70. Data types in PL/SQL                                               
71. Variable and constant declaration in PL/SQL
72. Control structures: if, while, for, loop, goto
73. Cursor: Opening, Fetching, Closing
74. Cursor attributes                                
75. Examples 1…7  on cursor                                     
76. Cursor variable                                                            
77. Exceptions                                                                      
78. Large Objects                                                                
79. Collections in PL/SQL                                              
80. Example on varray                             
81. Record in PL/SQL                               
82. Subprograms                                                                 
83. Procedures                                                                     
84. Examples 1…10  on procedure
85. Functions                                                 
86. Examples on function                                              
87.  Overloading in PL/SQL                                          
88. Example on function overloading
89. Recursion in PL/SQL                         
90. Example on Recursion                                            
91. Packages                                                   
92. Advantages of Packages                                         
93. Sample structure of Package     
94. Triggers, Types of Triggers                                    
95. Examples 1…6 on trigger                                      
96. Transactions & its properties    

    Atomicity, Consistency, Isolation, Durability

97. Indexes: Unique, composite, Reverse, bitmap 
98. Clustering                                                                        
99. Creating Users                                                              
100. Altering Users                                                               
101. Dropping Users                                                            
102. Architecture of Oracle                                           
103. Details of Oracle Architecture  
104. Oracle Handling Files                                              
105. Table space                                                                    
106. Table Space Allocation                                           

Question Bank