BCS Database Management Systems

Question 1

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID stands for Atomicity (all-or-nothing), Consistency (valid state transitions), Isolation (concurrent transactions don't interfere), and Durability (committed data persists).

Question 2

What is a primary key in a relational database?

Accepted Answer

A unique identifier for each row in a table that cannot be NULL

Answer

A primary key is a column or set of columns that uniquely identifies each row in a table and cannot contain NULL values.

Question 3

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

Accepted Answer

SELECT

Answer

The SELECT statement retrieves data from one or more tables, with optional filtering (WHERE), grouping (GROUP BY), and sorting (ORDER BY) clauses.

Question 4

What is the purpose of normalization in database design?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

Database normalization organizes tables to minimize data redundancy and dependency by dividing large tables into smaller, logically related ones.

Question 5

What is a foreign key constraint?

Accepted Answer

A column that references the primary key of another table, enforcing referential integrity

Answer

A foreign key is a column in one table that refers to the primary key in another table, ensuring referential integrity between related tables.

BCS - Bachelor Of Computer Science Degree Practice Test

BCS - Bachelor Of Computer Science Degree Practice Test

BCS Database Management Systems