Scribd
Upload
8 views2 pages

Database Management System Model Questions

The document contains a list of model questions related to Database Management Systems (DBMS). Topics include comparisons between file processing systems and DBMS, normalization, entity sets, data abstraction, and various database operations. It also covers transaction processes, concurrency control, security, and PL/SQL programming.

Uploaded by

kumarijyoti21819
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
8 views2 pages

Database Management System Model Questions

The document contains a list of model questions related to Database Management Systems (DBMS). Topics include comparisons between file processing systems and DBMS, normalization, entity sets, data abstraction, and various database operations. It also covers transaction processes, concurrency control, security, and PL/SQL programming.

Uploaded by

kumarijyoti21819
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

R K AMHTO DSPMU RANCHI

DATABASE MANAGEMENT SYSTEM

MODEL QUESTIONS:

1. Compare and contrast between a file processing system and DBMS.


2. What is normalization? What are the different normal forms?
3. What do you mean by insertion and deletion anomalies? Explain with
examples.
4. What do you mean by entity sets? What are strong and weak entities? Give
examples.
5. Why do we need weak entity set? Explain. How can we convert a weak
entity set to a strong entity set?
6. Why do we need Cartesian product operation? Explain this operation with an
example.
7. What do you mean by data abstraction? Explain different levels of data
abstraction.
8. What are the main functions of a database administrator? Explain in detail.
9. Why are relation normalized? Explain 2NF, 3NF and BCNF relations with
suitable example.
[Link] mapping cardinality constraints.
[Link] the overall system architecture of a relational database management
system with proper block diagram.
[Link] the three schema architecture of a database system.
[Link] the role of a high-level data model in the database design process.
[Link] is the difference between specialization and generalization? Why do
we not display this difference in schema diagrams?
[Link] is Relational algebra? What is Cartesian product?
[Link] the advantages and disadvantages of DBMS.
[Link] BCNF. How does it differ from 3NF? Why is it considered a stronger
form of 3NF?
[Link] lossless decomposition and dependency preserving. 20. Write short
notes on the following:
(a) Primary key (b) Candidate key (c) Foreign key
(d) DDL (e) DML (e) Entities
[Link] is the need for concurrency control and Recovery in DBMS?

1|Page
R K AMHTO DSPMU RANCHI

[Link] is serialisability? Explain control and view serializabilities.


23. Explain all the states of a transaction process with proper diagram.
[Link] is multi-valued dependency? Explain.
[Link] is a transaction? What are the various characteristics that a transaction
must possess? Explain the various transaction states.
[Link] Dead lock detection and recovery mechanisms
[Link] different levels of security and authorization to ensure database
security.
[Link] simple queries
[Link] self join and equijoin.
[Link] is PL/SQL Programming
[Link] Oracle functions
[Link] is trigger? What is type of trigger?

2|Page

You might also like