Scribd
Upload
171 views3 pages

DBMS Important Questions

The document provides important questions and answers for the Diploma 4th Semester Examination in Database Management System (DBMS) at Jharkhand University of Technology. Key topics include definitions and characteristics of DBMS, normalization, SQL commands, and the differences between DBMS and RDBMS. It serves as a study guide for students preparing for their final exam in DBMS.

Uploaded by

bhaskarraj8058
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
171 views3 pages

DBMS Important Questions

The document provides important questions and answers for the Diploma 4th Semester Examination in Database Management System (DBMS) at Jharkhand University of Technology. Key topics include definitions and characteristics of DBMS, normalization, SQL commands, and the differences between DBMS and RDBMS. It serves as a study guide for students preparing for their final exam in DBMS.

Uploaded by

bhaskarraj8058
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

Jharkhand University of Technology, Ranchi

Diploma 4th Semester Examination

Subject: Database Management System (DBMS)

Important Questions and Answers

1. What is DBMS?

Answer: A Database Management System (DBMS) is a software system that enables users to

define, create, maintain, and control access to the database. It helps manage large amounts of data

efficiently.

2. What are the main characteristics of a DBMS?

Answer:

- Data Redundancy Control

- Data Integrity

- Data Security

- Concurrent Access

- Data Independence

3. Explain DDL, DML, and DCL with examples.

Answer:

- DDL (Data Definition Language): Used to define the structure. E.g., CREATE, ALTER.

- DML (Data Manipulation Language): Used to manipulate data. E.g., INSERT, UPDATE.

- DCL (Data Control Language): Used to control access. E.g., GRANT, REVOKE.

4. What is normalization? Explain 1NF, 2NF, 3NF, and BCNF.

Answer:

Normalization is the process of organizing data to reduce redundancy.


- 1NF: Atomic values.

- 2NF: No partial dependency.

- 3NF: No transitive dependency.

- BCNF: Every determinant is a candidate key.

5. What is data fragmentation?

Answer: Data fragmentation is breaking a database into smaller pieces for efficiency.

- Types: Horizontal, Vertical, and Hybrid Fragmentation.

6. What is a distributed database?

Answer: A database spread across multiple locations.

Advantages: Reliability, Faster Query Processing, Local Autonomy.

7. What is a primary key?

Answer: A primary key is a field that uniquely identifies each record in a table.

8. What is foreign key?

Answer: A foreign key is a field in one table that refers to the primary key in another table.

9. What is SQL and give some common commands.

Answer:

SQL is Structured Query Language used to communicate with databases.

- SELECT, INSERT, UPDATE, DELETE, CREATE TABLE

10. What is a transaction in DBMS?

Answer: A transaction is a sequence of operations performed as a single logical unit of work.

Properties: ACID (Atomicity, Consistency, Isolation, Durability)


11. What is a view in SQL?

Answer: A view is a virtual table based on the result-set of an SQL statement.

12. What is deadlock?

Answer: A situation where two or more transactions wait indefinitely for each other to release locks.

(Note: Not in your syllabus)

13. What is ER diagram?

Answer: An Entity-Relationship Diagram represents data and relationships among data.

14. What is normalization's importance?

Answer: Reduces redundancy, improves integrity, and optimizes queries.

15. Difference between DBMS and RDBMS.

Answer:

- DBMS stores data as files; RDBMS stores in tables.

- RDBMS supports relationships; DBMS doesn't.

Prepared by ChatGPT for DBMS Final Exam Preparation.

You might also like