Data | MCQs

Explanation

Explanation

A field is the smallest meaningful unit of data in a database.

It representing a single piece of information such as a name or age within a record.

Explanation

A "Select query" is used to retrieve data from a database.

It can filter records to show employees earning more than $5000 a month by specifying conditions.

Explanation

After creating a table, fields (columns) can be modified.

It allowing for both additions and deletions as required.

Explanation

A dynaset is a collection of records that match the parameters of a query. 

It dynamically updates based on the query criteria set by the user.

Explanation

Numeric Pad is in Keyboard.

It is a section on the right side of a standard keyboard that contains numbers and arithmetic operators for quick data entry.

Explanation

When a computer detects invalid data, it often displays a red triangle or an error indicator to alert the user.

This symbol is commonly used in spreadsheets, databases, and other software applications to indicate that the data is incorrect, inconsistent, or outside of the expected range.

Explanation

The Cascade Delete option is a database feature that automatically deletes all related records in a child table when a record is deleted from a parent table.

This helps maintain data consistency and integrity by ensuring that all related data is removed when a primary record is deleted.

Explanation

Syntax refers to the rules and structure of data, including the format, order, and organization of data elements.

Syntax defines how data is represented, stored, and transmitted.

Explanation

There are three types of relationships that can exist between two tables:

• one-to-one.
• one-to-many.
• many-to-many.