DATABASE CONCEPTS

1.	What is a database ?
Ans :	A database may be defined as a collection of interrelated data stored together to serve multiple applications.
2.	What is the Database Management System ?
Ans :	A DBMS refers to a software that is responsible for storing, maintaining and utilizing databases. A database along with a DBMS is referred to as a database system.
3	What is the purpose of a Database
Ans :	The following purpose of Database Management System are defined below a. Database reduce the data redundancy to a large extent b. Database can control data inconsistency to a large extent c. database facilitate sharing of data d. database enforce standards. e. database can ensure data security
4.	What is ACID property
Ans.	1. Atomicety 2. Consistency 3. Isolation / Integrity 4. Durability

5. What is data Redundancy

Ans: means , duplication of data e.g. the name of the student is in both the attendance register and the guard file even though the attendance register is having the name for all the months.

6. What is data Security

Ans : Unauthorized Access and Unauthorized Use. It is the protection of data against accidental or intentional disclosure to unauthorized person or unauthorized modification or destruction. it is related to privacy of data.

7.   What is database abstraction.

Ans : It is the concept development of database system 

8. What are the various levels of database Implementation.

Ans : 1. Internal Level (Physical Level)

          2. Conceptual Level 

          3. External Level (View Level)

9. What is Physical Level 

Ans : Physical Level of DBMS means internal level or hardware where the data is saved.

10. What is Conceptual Level

Ans : In this level the concept or keys of the data are implemented.

11. What is External Level 

Ans. It is the View Level , here the viewer sees the data as and when needed.