OCTOBER/NOVEMBER-2010(C-05)

3232

BOARD DIPLOMA EXAMINATION, (C-05)

 

OCTOBER/NOVEMBER-2010

DCM-III SEMESTER EXAMINATIONS

PART-A          10*3=30

1. Define First Normal Form.
2. Define the following terms: (1) Entity (b)Relationship (c)generalization.
3. write short notes on Network model.
4. create a table named Account with following attributes and constraints : acno, name, actype, loc, balance, acno must be unique and not null.
5. write short note on format models for date and number.
6. list the advantages of views.
7. define cluster and give its use.
8. what are global and local variables?
9. define function and explain.
10. how to create package specification.

PART-B

11. explain E.F.CODD’s rules for RDBMS.           10
12. Explain the process to reduce ER diagrams to tables.
13. (a)explain Oracle tools. (b)define sub query and explain.
14. (a)list various operators in SQL. (B)explain how to manage space in SQL.
15. Explain the procedure of creating, altering and dropping tables.
16. Explain how to create a procedure in PL/SQL.
17. (a)Explain about recursion.                                                                    5        (b)explain the concept of propagation of exception.                             5
18. explain the concept of stored sub programs.                                          10

Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS

• 
  
• OCTOBER/NOVEMBER-2010(C-09)