Scribd
Upload
13 views4 pages

DBMS BCS403 Impbymohsinali

The document is a question bank for a Database Management Systems course, structured into five modules covering various topics such as database definitions, data models, SQL operations, transaction management, and NOSQL systems. Each module contains multiple questions aimed at engineering students, focusing on theoretical concepts, practical applications, and design guidelines. The content is designed to assess students' understanding of database systems and their functionalities.

Uploaded by

Goodperson CoDM
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views4 pages

DBMS BCS403 Impbymohsinali

The document is a question bank for a Database Management Systems course, structured into five modules covering various topics such as database definitions, data models, SQL operations, transaction management, and NOSQL systems. Each module contains multiple questions aimed at engineering students, focusing on theoretical concepts, practical applications, and design guidelines. The content is designed to assess students' understanding of database systems and their functionalities.

Uploaded by

Goodperson CoDM
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

BCS403: Database Management

System by Mohsin Ali

Question Bank

Prepared for Engineering Students


1 Module 1
1. Define database. Elaborate component modules of DBMS and their interactions.

2. Describe the three-schema architecture. Why do we need mappings among schema


levels?

3. Explain the difference between logical and physical data independence. What are
the advantages of using DBMS approach? Explain.

4. Draw an ER diagram for an COMPANY database with employee, department,


project as strong entities and dependent as weak entity. Specify the constraints,
relationships and ratios in the ER diagram.

5. Define the following terms with example for each using ER notations: Entity, at-
tribute, composite attribute, multivalued attribute, participation role, cardinality
ratio.

6. Explain the categories of Data Models. Describe the characteristics of database.

7. What are the responsibilities of DBA & database designers?

8. Explain the types of end users with examples.

9. Explain the different types of attributes in ER model.

2 Module 2
1. Discuss the update operations and dealing with constraint violations with suitable
examples.

2. Illustrate the relational algebra operators with examples for select and project op-
eration.

3. Discuss the characteristics of relations that make them different from ordinary table
and files.

4. Explain Unary relational operations with examples.

5. What is an Integrity Constraint? Explain the importance of Referential Integrity


Constraint.

6. Discuss the E.R to Relational mapping algorithm with example for each step.

7. Demonstrate the concepts of Generalization & Specialization with examples.

8. Discuss equijoin and natural join with suitable example using relational algebra
notation.

9. Explain any two operations that change the state of relation in a database. Provide

1
suitable examples.

10. Discuss the aggregation functions and grouping in relational algebra with suitable
examples.

3 Module 3
1. Discuss the informal design guidelines for relation schema design.

2. Define INF, 2NF, and 3NF with examples.

3. Write the syntax for INSERT, UPDATE and DELETE statements in SQL and
explain with suitable examples.

4. Discuss insertion, deletion and modification anomalies. Why are they considered
bad? Illustrate with examples.

5. Illustrate the following with suitable examples:

• Datatypes in SQL

• Substring Pattern Matching in SQL

6. Explain informal design guidelines for relational schema design.

7. What is Functional dependency? Explain the inference rules for functional depen-
dency with proof.

8. Explain the types of update anomalies in SQL with an example.

9. Explain Armstrong inference rules. Explain types of JBBC drivers.

4 Module 4
1. What do understand by correlated Nested Queries in SQL? Explain with suitable
example.

2. Discuss the ACID properties of a database transaction.

3. What are the views in SQL? Explain with examples.

4. In SQL, write the usage of GROUP BY and HAVING clauses with suitable exam-
ples.

5. Discuss the types of problems that may encounter with transactions that run con-
currently.

6. Demonstrate transaction states & additional operations.

7. Demonstrate working of Assertion & Triggers in database? Explain with an exam-

2
ple.

8. Demonstrate the System Log in database transaction. Explain cursor and its prop-
erties in embedded SQL with suitable example.

9. Explain stored procedure language in SQL with an example.

10. With a neat diagram, explain transition diagram of a transaction.

5 Module 5
1. What is the two phase locking protocol? How does it Guarantee serializability.

2. Describe the wait-die and wound-wait protocols for deadlock prevention.

3. What is NOSQL? Explain the CAP theorem. List and explain the four major
categories of NOSQL system.

4. What is Multiple Granularity locking? How is it implemented using intension locks?


Explain.

5. Discuss the following MongoDB CRUD operations with their formats:

• Insert

• Delete

• Read

6. Briefly discuss about Neo4j data model.

7. Define Schedule? Illustrate with an example. What are document based NOSQL
systems?

8. Why Concurrency control is needed? Demonstrate with an example.

9. What is NOSQL Graph database? Explain deadlock prevention protocols.

10. What are Binary locks? Explain with Lock and unlock operations with algorithm.

You might also like