Data | MCQs

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 Consolidated Data Distribution, all data is stored at one central site.

This simplifies management but may reduce access speed for remote users.

Explanation

An index helps the database quickly locate rows in a table without scanning the entire data.

It improves query performance by providing direct pointers to the data rows.

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

Integer data type stores whole numbers without decimals, ideal for values like 67, 100, etc.

It supports a range that easily includes numbers greater than 66.000 and doesn’t require decimal precision like float.

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

A transmission medium is a channel through which data is transmitted — satellite systems are used to transmit signals over long distances.

LED TV or video camera are devices, not mediums for data transmission.

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)