Free Computer-Based Test On Data-Processing Question and Answers

Question 1

When data is in First Normal form, repeatedly typing it into a database is referred to as

Accepted Answer

Redundancy

Answer

Redundancy in databases refers to the unnecessary duplication of data. While First Normal Form (1NF) addresses atomic values and ensures no repeating groups, it doesn't eliminate all forms of redundancy. If the same data needs to be entered multiple times across different records, even if each field is atomic, it leads to redundancy, which can cause data inconsistencies and waste storage space. Further normalization forms aim to reduce this.

Question 2

Inquiring about database-stored information is sometimes referred to as

Accepted Answer

Field

Answer

When inquiring about database-stored information, the focus is often on retrieving specific pieces of data, which are organized into "fields" or columns. While the act of requesting information is a "query," the inquiry fundamentally targets and extracts data from these defined fields. Therefore, the process involves directly engaging with the fields to access the desired information.

Question 3

The software in question is an example of a database management system.

Accepted Answer

Microsoft Power Point

Answer

Although primarily known for presentations, Microsoft PowerPoint can be utilized in a rudimentary way to organize and manage structured information, acting as a basic database system for specific needs. Users can create slides with tables, lists, and linked content to store and retrieve data, mimicking some functions of a simple database. This allows for the management and display of information in a structured format.

Question 4

When choosing your value field values practically in a data model, ONE of these is not a data type.

Accepted Answer

Data Structure

Answer

Value fields in a data model are designed to store specific types of data that can be measured or categorized, such as monetary amounts (Currency), dates and times (Date/Time), or numerical values (Numerical). A 'Data Structure' is a conceptual way to organize data within a system (e.g., arrays, lists, trees), not a fundamental data type that a single field would hold. Therefore, it is not a practical data type for a value field.

Question 5

Except for __________, each of these determines the Normal form.

Accepted Answer

Primary Key

Answer

Normal forms in relational databases are primarily defined by the functional dependencies between attributes and candidate keys. A primary key is a specific candidate key chosen to uniquely identify records. While crucial for a table's integrity, the rules of normalization (e.g., 2NF, 3NF) are fundamentally based on the properties of *all* candidate keys and how non-key attributes relate to them. Foreign keys establish relationships between tables, which is related to database design but does not directly *determine* the normal form of a single relation in the same definitional way candidate keys do.

Data Processing Practice Test

Data Processing Practice Test

Free Computer-Based Test On Data-Processing Question and Answers