21-01-2013, 04:48 PM
Department of computer Science and Engineering Question Bank
1Department of computer.doc (Size: 55 KB / Downloads: 32)
UNIT-1
Part-A
1) Define database management system.
2) List any eight applications of DBMS.
3) What are the disadvantages of file processing system?
4) Define instance and schema?
5) What is conceptual schema?
6) Define data model?
7) What is the purpose of storage manager?
8) What is a data dictionary?
9) Define single valued and multi valued attributes.
10) What are stored and derived attributes?
11) What are composite attributes?
12) What is degree of relationship set?
13) Define weak and strong entity sets?
Part-B
1) Explain the architecture of DBMS with a neat block diagram.
2) Explain the two types of participation constraint.
3) Explain ER model in detail.
4) Explain the design issues of ER-model.
5) Draw and explain ER diagram for a banking enterprise.
UNIT-2
Part-A
1) What is the structure of relational database?
2) What is the structure of SQL query?
3) What are numeric functions?
4) What are date functions?
5) What are string functions?
6) What is dual table? Write the importance of it.
7) What are the different aggregate functions?
8) What is sub-query?
9) What is importance of query language?
Part-B
1) Explain the relational model with an example.
2) Explain the types of keys in relational model.
3) Explain key constraints in relational model.
4) Explain the constraints applicable on relation
5) Explain the basic data types of SQL.
6) Explain nested Queries with examples.
7) Explain different relational algebraic operations.
8) Explain set operations with an example..
9) Explain the extended relational algebraic operations.
UNIT-3
Part-A
1) What are stored procedures?
2) What is self join? Explain with an example.
3) What are anomalies?
4) What is an insertion anomaly?
5) Why we need to normalize the data?
6) Give the difference between 3rd Normal Form and BCNF.
7) Define lossy decomposition.
8) Justify the statement all decomposition are not fruitful or loss less decompositions.
Part-B
1) Explain embedded SQL and dynamic SQL in detail.
2) Explain the integrity constraints supported by SQL.
3) Explain triggers with an example.
4) Explain security and authorization in SQL.
5) Explain the different Normal Forms in detail.