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

An INNER JOIN returns only the rows that have matching values in both tables being joined.

Question 2

What is the purpose of database normalization?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

Database normalization organizes tables to reduce data redundancy and improve data integrity by eliminating anomalies in insertion, update, and deletion operations.

Question 3

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

Accepted Answer

Network packet routing

Answer

Network packet routing is a function of network hardware and software, not a DBMS, which handles storage, retrieval, access control, 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 Definition Language (DDL) includes commands like CREATE, ALTER, and DROP that define and modify the structure of database objects.

Question 5

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

Accepted Answer

Cannot exist without depending on another entity

Answer

A weak entity cannot be uniquely identified by its own attributes alone and depends on a parent (strong) entity for its existence and identification.

MIS - Management Information Systems Practice Test

MIS - Management Information Systems Practice Test

MIS Database Management Systems 2