MIS Database Management Systems 3

Question 1

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

Accepted Answer

Extract, Transform, Load

Answer

Encrypt, Transfer, Load

Answer

Evaluate, Test, Launch

Answer

Extract, Test, Link

Question 2

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

Accepted Answer

COUNT()

Answer

SUM()

Answer

AVG()

Answer

MAX()

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

The speed at which data is retrieved from the database

Answer

The process of encrypting data to prevent unauthorized access

Answer

The number of users who can simultaneously access the database

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 method to visually display database tables

Answer

A type of index that speeds up data retrieval

Answer

A backup file that stores historical records

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

Creates a separate structure that points to the actual data rows

Answer

Allows multiple values per index entry to speed up lookups

Answer

Only indexes the first column of a composite primary key

Question 6

Which concurrency control technique assigns a unique timestamp to each transaction to determine the serialization order?

Accepted Answer

Timestamp ordering protocol

Answer

Two-phase locking (2PL)

Answer

Optimistic concurrency control

Answer

Snapshot isolation

Question 7

Which of the following is an example of a DDL command in SQL?

Accepted Answer

CREATE TABLE departments (dept_id INT, dept_name VARCHAR(50))

Answer

SELECT * FROM employees

Answer

UPDATE employees SET salary = 50000

Answer

GRANT SELECT ON employees TO user1