MIS Database Management Systems

Question 1

Which type of database model organizes data into tables with rows and columns, linked by keys?

Accepted Answer

Relational model

Answer

The relational model organizes data into tables (relations) connected via primary and foreign keys, and is the basis for SQL-based databases.

Question 2

In a relational database, a PRIMARY KEY is best described as:

Accepted Answer

A field that uniquely identifies each record in a table

Answer

A primary key uniquely identifies each row in a table and cannot contain null or duplicate values.

Question 3

Which SQL command is used to retrieve data from a database table?

Accepted Answer

SELECT

Answer

The SELECT statement is the SQL command used to query and retrieve data from one or more database tables.

Question 4

What does ACID stand for in the context of database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID stands for Atomicity, Consistency, Isolation, and Durability — the four properties that guarantee reliable database transactions.

Question 5

A FOREIGN KEY in a relational database:

Accepted Answer

Links a record in one table to a record in another table

Answer

A foreign key is a field in one table that references the primary key of another table, establishing a relationship between the two tables.

MIS - Management Information Systems Practice Test