Database | MCQs

Explanation

The address field contains letters, numbers, and symbols (e.g., "House #42, Street 8").

So, it must be stored as an alpha-numeric data type to handle such mixed content.

Explanation

BCNF is a stronger version of the 3rd Normal Form; it handles certain anomalies that 3NF does not.

It ensures that every determinant is a candidate key, improving data integrity.

Explanation

In databases, semantic description defines what kind of data an attribute should store.

Storing "Physics" as an employee name violates the expected semantic meaning of a name (e.g., "John", "Ali").

Explanation

A report in DBMS presents formatted data retrieved from the database in a readable, often printable form.

It is mainly used for viewing and analyzing data.

Explanation

Concurrency control manages simultaneous access to data in a database to prevent conflicts or data inconsistency.

It ensures data integrity when multiple users perform read/write operations at the same time.

Explanation

Each row in a data set (called a tuple)

n database lingo, these columns are called attributes.

A database attribute is a column name and the content of the fields under it in a table.

Explanation

In database lingo, these columns are called attributes.

A database attribute is a column name and the content of the fields under it in a table.

while 

Each row in a data set (called a tuple)

Explanation

Most databases and spreadsheets (like Excel or Google Sheets) allow users to freely add or delete rows and columns.

This flexibility helps in updating or organizing data as per requirements.

Explanation

A primary key uniquely identifies each record (row) in a database table.

It ensures data integrity by preventing duplicate and null entries in the key column.

Explanation

A Database Administrator (DBA) is responsible for the design, implementation, maintenance, and repair of a database.

They ensure that the database operates efficiently, securely, and reliably.