Database Introduction 2

1. DBMS Stands for:-

• Database marketing system

• Data Management System

• Database Management System

• Data Marketing System

3. Which of the following is not an example of DBMS?

• MySQL

• Microsoft Access

•      IBM DB2

• Microsoft Excel

Data is

• collection of processed items
• collection of unprocessed items

_______ 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 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

Following are the relationship type, except

• One-to-zero relationship

• One-to-one relationship

• Ont-to-many relationship

• Many-to-many relationship

For the following two Tables, which is the best relationship described:

RULER / COUNTRY

• One to One

• One to Many

• Many to Many

For the following two Tables, which is the best relationship described:

RECIPE/ INGREDIENT

• One to One

• One to Many

• Many to Many