Introduction to Databases

Question 1

What is the primary role of DBMS software?

A.

A) To create programming languages

B.

B) To organize, store, retrieve, and maintain data relationships

**DBMS** provides the environment to manage interrelated **tables** automatically.
A DBMS automates the handling of structured data and its relationships using tables, ensuring reliability, security, and ease of access, making it a vital part of modern data-driven systems.

C.

C) To design website layouts

D.

D) To compress individual files

Question 2

What is the primary purpose of **SQL** for data analysts in business environments like telecommunications?

A.

A) Creating user interfaces

B.

B) Querying data for reports

Explanation: Data analysts use **SQL** for business performance reports.

C.

C) Deploying applications

D.

D) Managing hardware resources

Question 3

What is a **relation** in database terminology?

A.

A) A single column in a table

B.

B) A table representing interrelated data in rows and columns

Explanation: A **relation** is defined as a table that organizes interrelated data into rows and columns.

C.

C) A rule enforcing data uniqueness

D.

D) A connection between two records

Question 4

What is the primary purpose of a **primary key**?

A.

A) To link tables together

B.

B) To allow null values in rows

C.

C) To uniquely identify each row and ensure it is non-null

Explanation: A **primary key** like **EmpID** provides unique, non-null identification for each row.

D.

D) To group data by department

Question 5

Which command permanently saves transaction changes to the database?

A.

A) ROLLBACK

B.

B) SAVEPOINT

C.

C) COMMIT

Explanation: **COMMIT** makes DML changes permanent in storage.

D.

D) REVOKE

Question 6

12. Which command completely removes a table and its definition?

A.

A) TRUNCATE

B.

B) DROP

Explanation: **DROP TABLE** eliminates the table entirely from the database.

C.

C) RENAME

D.

D) GRANT

📝 Introduction to Databases

Quiz Complete!