Madras University DBMS Question Paper

[Shaleen]

I am pursuing MCA from Madras University. My examination of MCA 2nd semester will held in next month and I am weak in DBMS (Database management system) Paper. So can you provide me model question paper DBMS?

As you asking for the previous year question paper of the BCA 2nd year of the Subject DBMS the question paper is as follow :


UNIVERSITY OF MADRAS
NOVEMBER 2010
SAE5B/SAZ5A
Time: Three hours
Maximum: 75 marks
PART A-(10 X 2 = 20 marks)
Answer any TEN Questions.
1. What is DBMS and RDBMS?
2. What is normalization?
3. What are the basic data types to define an attribute?
4. Write the general meaning of outer join.
5. List down the basic arithmetic operators
6. What is sub form?
7. What are the basic SQL DDL commands?
8. Write down the primary functions for error handling.
9. What are the primary sections of reports?
10. Write the difference between centralized and distributed database.
11. What is the role of database administrator?
12. What is the use of backup?
PART B-(5 X 5 = 25 marks)
Answer any FIVE Questions.
13. What are the components of database system?
14. What is functional dependency? Explain
15. Discuss Boyce Codd Normal form.
16. Write a note and list down the aggregation operators.
17. How to handle the unexpected errors? Explain
18. Write a note on table operations.
19. Describe the client/server database.
PART C-(3 X 10 = 30 marks)
Answer any THREE Questions.
20. Describe the terms related to class and how to convert the class to normalized table.
21. What is sub query, nested sub query? And also explain the following SQL operators IN, All, Any.
22. What are the common controls to build a form? Explain
23. What are the data storage methods available? Explain
24. What are the development stages of a database tasks? Explain

hii sir, I wants to get the previous year question paper of the BCA 2nd year of subject DBMS will you please provide it ?

What are the basic sql and ddl command

Please can anyone post dbms madras university qp 2017, 2018