Introduction to Database

Applications of Database are:-

• Banking

• Sales

• Ticket Reservation

• HR Management

Why we need database?

• To store  a particular picture
• To store  a particular text
• To store  a particular collection of data.
• To store  a particular audio

What is Database Management System?

• A software system that enables users to access to the database.
• A software system that enables users to create  access to the database.
• A software system that enables users to define, create, maintain and control access to the database.
•   A software system that enables users to maintain and control access to the database.

Which of the following is NOT Advantages of DBMS

• Increased data consistency 
• Reduced data redundancy
• Improved data security 
• Increase data isolation

Using different file organization should not require change to conceptual or external schemas.

This is referring to

• Logical Data Independence

• Physical Data Independence

• Conceptual Data Independence

• User Data Independence

_______ builds the application programs that provide the required functionality for the end-users.

• Data Administrator (DA)

• Database Administrator (DBA)

• Database Designers (Logical & Physical)

• Application Programmers

Column titles are __________________________.

• Field Names

• Records

• Primary Keys

• Foreign Keys

Column in a table also known as

• Attribute

• Entity

• Record

• Relationship

SQL stands for

• structured query language

• structured question language

• sustainable query language

• sustainable question language

___ exists when different versions of the same data appear in different places

• Data integrity

• Data anomaly

• Data redundancy

• Data inconsistency