MIS Database Management Systems 3

Question 1

In a data warehouse context, what is an 'ETL process'?

Accepted Answer

Extract, Transform, Load

Answer

ETL stands for Extract, Transform, Load — the process of pulling data from source systems, transforming it into a consistent format, and loading it into a data warehouse.

Question 2

Which SQL aggregate function returns the number of rows that match a specified condition?

Accepted Answer

COUNT()

Answer

The COUNT() function returns the total number of rows that match the specified criteria in a query.

Question 3

What does 'data integrity' mean in a database system?

Accepted Answer

The accuracy, consistency, and reliability of data stored in the database

Answer

Data integrity ensures that data stored in a database is accurate, consistent, and reliable throughout its lifecycle, enforced through constraints and validation rules.

Question 4

A 'stored procedure' in a database is best described as:

Accepted Answer

A precompiled set of SQL statements stored in the database that can be executed on demand

Answer

A stored procedure is a precompiled collection of SQL statements saved in the database that can be called and executed repeatedly, improving performance and code reuse.

Question 5

In database indexing, a clustered index:

Accepted Answer

Sorts and stores the actual table data rows in the order of the indexed column

Answer

A clustered index determines the physical order of data storage in the table itself, meaning the table rows are stored sorted by the indexed column.

MIS - Management Information Systems Practice Test

MIS - Management Information Systems Practice Test

MIS Database Management Systems 3