Free Computer-Based Test On Data-Processing Question and Answers — Questions and Answers
Question 1: When data is in First Normal form, repeatedly typing it into a database is referred to as
- Normalization
- Redundancy (Correct answer)
- Dependency
- Normal Form
Correct answer: Redundancy
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
- Report
- Query
- Record
- Field (Correct answer)
Correct answer: Field
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.
- Microsoft Power Point (Correct answer)
- FoxBase
- Microsoft Access
- dBase III
Correct answer: Microsoft Power Point
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.
- Currency
- Data Structure (Correct answer)
- Date/Time
- Numerical
Correct answer: Data Structure
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.
- Foreign Key
- Primary Key (Correct answer)
- Attribute Key (Correct answer)
- Candidate key
Correct answer: Primary Key
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.
Question 6: The object set is defined in the relational database model by the _________.
- Tuple
- Entity (Correct answer)
- Relation
- Attribute
Correct answer: Entity
In the relational database model, an 'entity' represents a real-world object or concept about which data is stored, such as a customer, product, or order. The 'object set' refers to the collection of these entities. Each entity type is then typically represented as a relation (or table) in the database, with its attributes defining its characteristics.
Question 7: When expanding the database structure, a database redesign is necessary because of an issue with tables in _____ form.
- Fourth Normal
- Third Normal
- Second Normal
- First Normal (Correct answer)
Correct answer: First Normal
First Normal Form (1NF) is the most basic level of normalization, requiring that all attributes in a relation contain atomic (indivisible) values and that there are no repeating groups. If a table is not in 1NF, it has fundamental structural flaws that make it difficult to query, update, and expand efficiently. Such issues necessitate a database redesign to achieve a proper relational structure.
Free Computer-Based Test On Data-Processing Question and Answers
When data is in First Normal form, repeatedly typing it into a database is referred to as