Question 1

What does the abbreviation DBMS stand for in the context of computing?

Accepted Answer

Database Management System. DBMS stands for Database Management System, which is software used to manage databases. It allows users to create, retrieve, update, and manage data efficiently. This system acts as an interface between the database and end-users.

Question 2

Which of the following is considered a collection of related data with an implicit meaning?

Accepted Answer

Database. A database is defined as a systematic collection of structured information or data. It is designed to be easily accessed, managed, and updated by various applications. It serves as a central repository for electronic records.

Question 3

In a database, what is the term used for a single row representing a unique record?

Accepted Answer

Tuple. A tuple is a single row in a table that represents a specific record or data object. It contains a set of values for all the attributes defined in that table. This term is primarily used in the relational database model.

Question 4

Which property ensures that a database remains in a consistent state after a transaction?

Accepted Answer

Consistency. The consistency property ensures that a transaction takes the database from one valid state to another. It maintains all predefined data integrity rules and constraints during execution. It is part of the ACID properties governing database transactions.

Question 5

What is the primary role of a 'Primary Key' in a database table?

Accepted Answer

To uniquely identify each record in a table. A Primary Key is a unique identifier that prevents duplicate entries in a specific table. It cannot contain null values, ensuring that every record can be precisely located. Most relational databases require at least one primary key per table.

DBMS Basics — Set 1