DBMS concepts (Medium)

1. Is DBMS is a software tool?

• TRUE

• FALSE

Data redundancy

• always lead to data inconsistency.

• sometimes lead to data inconsistency.

• means data inconsistency.

• is not related to data inconsistency.

The database architecture focuses on the design and implementation of computer programs that store and organize

• information for a computer.

• information for a business.

• information of all device in a computer.

• information about the parts of a computer.

A data model determines

• the structure of hardware components.

• the structure of a computer.

• the structure of software components.

• the structure of data.

Candidate Key is a specific type of field in a relational database that can identify

• each record uniquely.

• each attribute uniquely.

• each table in a database.

• each column of a table.

Consider relations R and S. A natural join is the set of tuples of all combinations in R and S that are equal on their common attribute names.

• TRUE

• FALSE

ACID is a standard set of properties that must be satisfied by

• Computer Networks.

• Operating System.

• Database Transactions

• Computer Memory.

Normalization is used to eliminate

• Insertion and Deletion Anomalies

• Deletion and Update Anomalies

• Update Anomalies.

• Insertion, Deletion and Update Anomalies

If there is no transitive dependency for non-prime attributes, then the relation must be in

• Second Normal Form.

• Third Normal Form.

• First Normal Form

• Fourth Normal Form.

A relation will be in 4NF if it is in Boyce-Codd normal form and has no

• Functional dependency.

• Transitive dependency.

• Multi-valued dependency.

• Join dependency.