MIS Database Management Systems 2

Question 1

Which type of JOIN returns only the rows where there is a match in both tables?

Accepted Answer

INNER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Answer

FULL OUTER JOIN

Question 2

What is the purpose of database normalization?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

To increase query execution speed by adding redundant data

Answer

To encrypt sensitive data in the database

Answer

To replicate data across multiple servers

Question 3

A Database Management System (DBMS) provides all of the following EXCEPT:

Accepted Answer

Network packet routing

Answer

Data storage and retrieval

Answer

Concurrent user access control

Answer

Data backup and recovery

Question 4

Which database language is used to define the structure of database objects like tables and indexes?

Accepted Answer

Data Definition Language (DDL)

Answer

Data Manipulation Language (DML)

Answer

Data Control Language (DCL)

Answer

Transaction Control Language (TCL)

Question 5

In an Entity-Relationship (ER) diagram, a 'weak entity' is one that:

Accepted Answer

Cannot exist without depending on another entity

Answer

Has no attributes

Answer

Has too many relationships with other entities

Answer

Contains only foreign key attributes

Question 6

Which of the following best describes a NoSQL database?

Accepted Answer

A non-relational database designed for flexible, scalable storage of unstructured or semi-structured data

Answer

A database that uses only the SQL language for queries

Answer

A relational database optimized for read-heavy workloads

Answer

A database that stores data in fixed-length records

Question 7

What is a 'deadlock' in the context of database concurrency?

Accepted Answer

A state where two or more transactions are each waiting for the other to release a resource, causing a standstill

Answer

A situation where a database query takes too long to execute

Answer

A backup process that locks the database for maintenance

Answer

An error that occurs when invalid data is inserted into a table