DBMS concepts (Easy)

What is DBMS stands for

• Database Manager Service

• Database Management System

• Database Manipulation Service

• Data Business Management Service

Data inconsistency is different and conflicting version of same data occurs at different place

• TRUE

• FALSE

A database architect develops and implements software to meet the needs of

• customer

• computer

• user

• programmer

The Entity-Relation model is composed of ...

• entity and object relationships

• entity and employee relationship

• entity types and their relationships

• entity types only.

Primary Key is a minimal set of attributes that uniquely specify

• an attribute in a relation.

• a column in a relation.

• a table in a relation.

• a tuple in a relation.

A key attribute

• can have NULL values.

• is the extra attribute of a relation.

• can have multiple data values.

• can not have NULL values

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output

• TRUE

• FALSE

ACID properties means

• Atomicity, Consistency, Isolation, and Deletion

• Atomicity, Consistency, Identification, and Deletion

• Atomicity, Consistency, Isolation, and Durability

• Atomicity, Construction, Isolation, and Deletion

Normalization divides the larger table into the smaller table and links them using

• relationship.

• redundancy

• hyperlink

• tuples.

A relation is in 2NF, only if a relation is in 1NF and

• attribute is dependent on each other.

• every non-key attribute is fully dependent on primary key.

• every attribute is a key attribute

• primary key dependent on the other attribute.