Post Graduate Diploma- Post Graduate Diploma In Computer Applications (PGDCA) 2nd Sem R.D.B.M.S.(Alagappa University, Karaikudi, Tamil Nadu-2011)
Wednesday, 24 July 2013 08:53Jebaprincy
Second Semester
Computer Applications
R.D.B.M.S.
Time : 3 Hours Maximum : 100 Marks
Part A (15 × 1 = 15)
Answer all the questions.
1. What is file processing ?
2. What is attribute ?
3. Define data abstraction.
4. List the tools of Oracle.
5. Define Primary key
6. How constraint is defined in table creation ?
7. What is NULL ?
8. What is the use of Ceil function ?
9. How user is created in SQL * PLUS ?
10. What is Object binding in Oracle ?
11. Give the syntax to create index.
12. Define View.
13. List any two privileges available in Oracle.
14. Who is DBA ?
15. How comments are represented in Report Writer ?
Part B (5 × 5 = 25)
Answer all the questions.
16. (a) Explain Codd’s rule.
(Or)
(b) Describe Network model with example.
17. (a) Explain about DML statements.
(Or)
(b) Write short notes on Data types.
18. (a) Explain about Date functions.
(Or)
(b) Write short notes on Sub Queries.
19. (a) Write short notes on object definition in database.
(Or)
(b) Explain about views.
20. (a) Write short notes on Grant.
(Or)
(b) Explain in detail about commit.
Part C (5 × 12 = 60)
Answer all the questions.
21. (a) Explain in detail about Data Models.
(Or)
(b) Describe with sketch about DBMs architecture.
22. (a) (i) Write short notes on logical comparision.
(6)
(ii) Explain Query expression Operator.
(6)
(Or)
(b) Explain SQL statements.
23. (a) Explain about SQL functions.
(b) Describe about Join Theory in SQL.
24. (a) Write short notes on :
(i) Sequence.
(ii) Synonyms.
(Or)
(b) Explain in detail about View.
25. (a) How DBA create users and grant privileges in SQL ? Explain with example.
(Or)
(b) Explain about Report writer of SQL.
| Earning: ₹ 4.65/- |
