Unit 3: Database Management System
Unit 3: Database Management System SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM Q1. What is a database? Ans. A database is an organized collection of data. Q2. What is DBMS? Ans. DBMS stands for Database Management System. It is software that controls the creation, maintenance, and use of a database. Q3. Name two DBMS Software. Ans. Two DBMS Software are : 1 MySQL 2. Oracle 3. Microsoft SQL Server 4. Microsoft Access. Q4. What is the difference between a Flat file and a Relational? Flat File: Data is stored in a single table. It is suitable for less amount of data. Relational: Data is stored in multiple tables. It is suitable for large amounts of data. Q5. What do you mean by database servers? Ans. Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Q6. Write four advantages of a database. Ans. Four advantages of a database are 1 It reduces Data Redundancy 2. It allows sharing of data. 3. It