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

Hierarchical model

Answer

Network model

Answer

Object-oriented model

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 field that allows duplicate values

Answer

A pointer to a record in another table

Answer

A constraint that allows null values

Question 3

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

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 4

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

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Concurrency, Integrity, Dependency

Answer

Atomicity, Concurrency, Integrity, Durability

Answer

Accuracy, Consistency, Isolation, Dependency

Question 5

A FOREIGN KEY in a relational database:

Accepted Answer

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

Answer

Uniquely identifies a record within its own table

Answer

Encrypts sensitive data within the table

Answer

Prevents any changes to a table's structure

Question 6

Which normal form eliminates partial dependencies by ensuring every non-key attribute depends on the whole primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 7

In database terminology, what is a 'schema'?

Accepted Answer

The logical structure or blueprint defining the organization of data in a database

Answer

A backup copy of the database

Answer

A query that retrieves data from multiple tables

Answer

A record stored in a database table