IC3 Database Applications 2 — Questions and Answers
Question 1: What is a 'flat file' database?
- A database stored on a USB flash drive
- A single table database with no relationships to other tables (Correct answer)
- A database that uses compressed file formats
- A database that only stores image files
Correct answer: A single table database with no relationships to other tables
A flat file database contains all data in a single table with no links or relationships to other tables, making it simple but limited for complex data.
Question 2: In a relational database, what connects two related tables?
- A form
- A report
- A foreign key (Correct answer)
- A macro
Correct answer: A foreign key
A foreign key is a field in one table that references the primary key of another table, creating the relationship between the two tables.
Question 3: Which of the following is an example of a database management system (DBMS)?
- Microsoft PowerPoint
- Adobe Photoshop
- Microsoft Access (Correct answer)
- Mozilla Firefox
Correct answer: Microsoft Access
Microsoft Access is a DBMS that provides tools for creating, organizing, querying, and managing databases.
Question 4: When sorting database records in ascending order on a 'Last Name' field, which entry appears first?
- Williams
- Anderson (Correct answer)
- Martinez
- Thompson
Correct answer: Anderson
Ascending alphabetical order starts from A; 'Anderson' begins with 'A', placing it before names starting with later letters.
Question 5: What does 'filtering' records in a database mean?
- Deleting unwanted records permanently
- Displaying only records that meet specific criteria (Correct answer)
- Sorting records in a different order
- Merging two tables into one
Correct answer: Displaying only records that meet specific criteria
Filtering temporarily hides records that do not meet the specified criteria, showing only the relevant subset of data without deleting anything.
Question 6: Which type of query would you use to change the price field for all records where 'Category' equals 'Electronics'?
- Select query
- Append query
- Update query (Correct answer)
- Crosstab query
Correct answer: Update query
An Update query modifies existing values in one or more fields for records that match specified criteria, such as changing prices for a product category.
Question 7: What is data validation in a database context?
- The process of encrypting sensitive data
- Rules that control what data can be entered into a field (Correct answer)
- A method of compressing the database file
- A backup procedure for the database
Correct answer: Rules that control what data can be entered into a field
Data validation uses rules and constraints to ensure that only appropriate, accurate data is entered into database fields, maintaining data integrity.
IC3 Database Applications 2
What is a 'flat file' database?