Five Year DBMS Question papers for BCA / B.Sc students

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

  

UNIVERSITY OF MADRAS

APRIL 2011                                                                    SAE5B/SAZ5A

Time: Three hours                                                          Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1.      What is database?

2.      What is normalization?

3.      What is DDL?

4.      What is a query?

5.      Define Foreign Key and Super Key.

6.      What is multiple table query?

7.      What is Cold Backup?

8.      What is DML?

9.      What is data integrity?

10.  Define Distributed Database System.

11.  What is data security?

12.  Write the important advantages of data distribution. 

PART B-(5 X 5 = 25 marks)          

Answer any FIVE Questions.

13.  Discuss briefly the Advantages DBMS.

14.  Explain briefly the data dictionary and the system catalog.

15.  What do you mean by Correlated sub query?

16.  Discuss briefly the data entry through multi-table form.

17.  Discuss briefly the user interface features.

18.  List and describe the functions of the database administrator.

19.  Discuss briefly the backup and recovery procedures in the transaction process. 

PART C-(3 X 10 = 30 marks)         

Answer any THREE Questions.

20.  Discuss how to converting class diagrams to normalized tables.

21.  Describe the Data Manipulation and Data Definition commands with suitable examples.

22.  Discuss the effective design of forms and reports.

23.  Explain in detail lie data clustering and partitioning.

24.  Discuss the following:

(A) Client/Server Database

(B)  Object Oriented Database 

UNIVERSITY OF MADRAS

NOVEMBER 2011                                                             SAE5B/SAZ5A

Time: Three hours                                                              Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1.      What is DBMS?

2.      What is a feasibility study?

3.      Define data dictionary.

4.      What are the situations in which a query will be created?

5.      What is the purpose of DISTINCT operator?

6.      Write the difference between DDL and DML.

7.      What are the primary types of forms?

8.      What are the primary sections of reports?

9.      What is transaction?

10.  List down the data storage methods.

11.  What are the development stages in database tasks?

12.  What is client/server database?

 

PART B-(5 X 5 = 25 marks)           

Answer any FIVE Questions.

13.  What are events? How they are described in a database design?

14.  How to convert a class diagram into normalized tables?

15.  What are the differences between OREDER BY and GROUP BY commands?

16.  Explain the difference between a Check Box and an option button.

17.  What is meant by error handling? Explain its two functions.

18.  How do menus improve the user interface?

19.  Write short notes on DBA. 

PART C-(3 X 10 = 30 marks)         

Answer any THREE Questions.

20.  List down the components of DBMS. Explain DBMS with its diagram.

21.  How to join tables when some items exist in only one of the tables? Discuss.

22.  What are the main controls can we use on forms? Explain these controls.

23.  Discuss about Custom Reports.

24.  Explain the three tier client/server data model.

UNIVERSITY OF MADRAS

APRIL 2012                                                                    SAE5B/SAZ5A

Time: Three hours                                                          Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1.      Define database?

2.      Give the purpose of foreign key.

3.      How to define a table in oracle.

4.      Define spooling.

5.      What is meant by DML?

6.      Define the term ‘set’.

7.      Mention the data types supported in PL/SQL.

8.      Define cursor variables.

9.      What is meant by exception?

10.  Give the purpose of functions.

11.  How to imitate the triggers in PL/SQL?

12.  Name any two composite data types.

PART B-(5 X 5 = 25 marks)           

Answer any FIVE Questions.

13.  Mention the salient features of relational data model.

14.  How relationships are defined in DBMS?

15.  Explain the technique of logging into SQL*Plus.

16.  With an example, show how to later an existing table in Oracle.

17.  How to use the DEFINE command?

18.  Discuss on the nested blocks in Embedded SQL.

19.  Give the purpose of data dictionary.

 

PART C-(3 X 10 = 30 marks)         

Answer any THREE Questions.

20.  Explain the technique of reducing redundancy through normalization.

21.  How to do the following in Oracle:

(a)    Dropping a table

(b)   Renaming a table and

(c)    Truncating a table

22.  Describe the execution of CASE structures.

23.  Classify the types of exceptions. Discuss them with examples.

24.  How packages are to be used in PL/SQL? 

 

UNIVERSITY OF MADRAS

NOVEMBER 2012                                                         SAE5B/SAZ5A

Time: Three hours                                                          Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1.      What is are Basic Components of a DBMS?

2.      What is meant by First Normal Form?

3.      Define: Data Dictionary.

4.      What is SQL?

5.      What is a subquery and in what situations it is useful?

6.      What is the purpose of subforms?

7.      What are the main reports types?

8.      Define: Procedural Language.

9.      What is the purpose of form events?

10.  Define: Cluster Analysis.

11.  Who is DBA?

12.  Distinguish between Physical Security and Logical Security. 

PART B-(5 X 5 = 25 marks)           

Answer any FIVE Questions.

13.  Write short notes on data types.

14.  Discuss on converting a class diagram to normalized tables, with examples.

15.  Write short notes on DDL statements.

16.  Discuss briefly on form layout.

17.  Write short notes on Table Operation.

18.  Discuss in detail, Data partitioning.

19.  Write about database tasks by development stages. 

PART C-(3 X 10 = 30 marks)         

Answer any THREE Questions.

20.  What are the advantages of a DBMS? Explain them.

21.  Explain the computation using queries with suitable examples.

22.  Explain creating forms with examples.

23.  Explain the user interface features.

24.  Describe in detail, Distributed databases.

UNIVERSITY OF MADRAS

APRIL 2013                                                                    SAE5B/SAZ5A

Time: Three hours                                                          Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1.      List down the advantages of a DBMS.

2.      Define: Class diagrams.

3.      What are keywords?

4.      What is the basic structure of the SQL SELECT command?

5.      Define: DDL

6.      List the basic human factors design elements.

7.      What are Tabular forms?

8.      List the primary sections of Reports.

9.      Write the purpose of the SAVEPOINT technique.

10.  Write a note on: Data partitioning.

11.  What takes are performed by a DBA?

12.  Define: A file-server.

PART B-(5 X 5 = 25 marks)           

Answer any FIVE Questions.

13.   Explain associations and relationships with example.
14.   Write short notes on: Domain-key normal form.
15.   Explain Testing queries with examples.
16    Discuss briefly on creating packages with examples.
17.   Explain Error handling with examples.
18.   Discuss on Transactions with examples.
19.   Explain about Application types.

                              

                                    PART C-(3 X 10 = 30 marks)

Answer any THREE Questions.
20.    Explain about BCNF and 4NF with examples.
21.    Describe in detail, Queries with Multiple tables with examples.
22.    Explain Direct manipulation of Graphical objects.
23.    Describe Custom reports with examples.
24.    What are Client/Server databases? Explain.

UNIVERSITY OF MADRAS

NOVEMBER 2013                                                                     SAE5B/SAZ5A

Time: Three hours                                                            Maximum: 75 marks 

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1. What is DBMS? Give definition.
2. What is the usage of report writer?
3. What are basic data  type to define an attribute?
4. What are queries?
5. List down the basic arithmetic operators.
6. What is meant by join operation?
7. What are the basic SQL DDL commands?
8. Write down the basic types of forms.
9. What are the primary sections of reports?
10. What are the primary data storage methods?
11. What is the role of a database administrator?
12. What are the strengths of a distributed database?

PART B-(5 X 5 = 25 marks)       

Answer any FIVE Questions.

13. What are the components of a DBMS system? Explain.
14. Explain the Entity – relationship diagram with class.
15. Discuss Boyce Code Normal form.
16. Write a note on aggregation operators.
17. How to handle the unexpected errors? Explain.
18. Write a short note on data clustering.
19. Describe the client/server database.

PART C-(3 X 10 = 30 marks)         

 

Answer any THREE Questions.

20. Explain in detail about 1NF,2NF and 3NF.
21. What is subquery, nested subquery and the SQL operators IN,ALL,ANY&EXISTS operation?
22. What are the common controls to build a form? Explain.
23. Explain in detail about the user interface features.
24. What are the development stages of a database tasks?

UNIVERSITY OF MADRAS

APRIL 2014                                                                    SAE5B/SAZ5A

Time: Three hours                                                          Maximum: 75 marks

PART A-(10 X 2 = 20 marks)

Answer any TEN Questions.

1. What is a database?
2. Define entity, class and objects.
3. What is encapsulation and why is it important?
4. State any three SQL aggregate functions.
5. Define: Relational algebra.
6. What are the basic properties for forms?
7. List the various report layout elements.
8. Distinguish between horizontal and vertical partitioning.
9. Define: ‘transaction’.
10. State the problems of logical security.
11. What is a distributed database? List its advantages.
12. What is recovery in a database?

PART B-(5 X 5 = 25 marks)

Answer any FIVE Questions.

13. What are the primary benefits provide by a DBMS.
14. Discuss about  various association details.
15. Discuss about SQL data manipulation commands.

16.   Explain any three controls on forms.

17.   Explain the concept of data clustering and data partitioning

18.   Explain the primary role of the data administrator.

19.   Discuss the three tier Client/Server model.

PART C-(3 X 10 = 30 marks)

Answer any THREE Questions.

20.  Explain the components of database management systems.

21.  Explain the process of joining tables in a query.

22.  Discuss about report design.

23.  Describe the three primary data storage methods.

24.  Describe the database tasks by development stages.