Scribd
Upload
2 views10 pages

dbmsQnA

The document outlines various concepts related to Database Management Systems (DBMS), including the three levels of architecture, data protection methods using Grant and Revoke commands, and normalization with explanations of 1NF and 2NF. It also discusses characteristics of DBMS, SQL commands, data independence, ER diagrams, roles of a DBA, disadvantages of conventional file systems, and various data models. Additionally, it covers concepts such as join operations, ACID properties, transaction states, and locking mechanisms.

Uploaded by

bahinki
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
2 views10 pages

dbmsQnA

The document outlines various concepts related to Database Management Systems (DBMS), including the three levels of architecture, data protection methods using Grant and Revoke commands, and normalization with explanations of 1NF and 2NF. It also discusses characteristics of DBMS, SQL commands, data independence, ER diagrams, roles of a DBA, disadvantages of conventional file systems, and various data models. Additionally, it covers concepts such as join operations, ACID properties, transaction states, and locking mechanisms.

Uploaded by

bahinki
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

1.

Explain the three levels of architecture of DBMS with


labeled diagram.

2. How can we protect our Data Base? Give the syntax


and examples of Grant & Revoke Commands.

3. What is Normalization?” Explain 2NF.


Eg

4. What are various characteristics of DBMS?


1. Data Abstraction
2. Data Independence
3. Data Security
4. Data Integrity
5. Data Consistency

5. Write down the syntax with example of following commands: insert, update, Alter, Delete.
5. What is SQL? How DDL and DML and different?
6. What is Data Independence? Give five differences between Logical data independence and
Physical data independence.

7. What are ER diagrams? Write various symbols used


in it. Explain briefly with example.

8. Who is DBA? Write various roles of DBA.

9. Write five disadvantages of conventional file system.


[Link] Redundancy and Inconsistency
2. Difficulty in Accessing Data
3. Data Isolation
4. Integrity Problems

10. Define Normalization. Explain 1NF, 2NF and 3NF with the help of an example.

Eg:

Eg:

Eg:
10. Define Mapping constraints. Explain two types of
mapping constraints with examples.

11. Define join operations on tables. Explain various types of Join Operations using suitable
examples.
12. Define Data Model. Define any two types of Data Models.

1. Hierarchical Data Model


Definition:
The Hierarchical Data Model organizes data in a tree-like structure, where:
• Each parent can have multiple children.
• Each child has only one parent.
2. Relational Data Model
Definition:
The Relational Data Model represents data in the form of tables (relations) consisting of rows and
columns.
Features:
• Uses primary keys and foreign keys.
• Supports SQL for querying data.
13. Define cardinality ratio and participation constraint for a relation.
14. ACID properties

15. States of transaction


16. Attribute and types

17. 2 phase locking


18. Bcnf

19. Shared vs exclusive lock

20. Components of database system

You might also like