Database Application Concepts Quiz

Which of the following is NOT a feature used to support database application implementation?

• Input masks

• Lookup lists

• Mail merging

• Menus and macros

How can data integrity be affected in a database?

• By repeated data entry and processing errors

• By data encryption

• By data visualization

• By data compression

What is the main purpose of creating complex queries in a database?

• To retrieve specific information based on multiple criteria

• To create tables

• To automate tasks

• To import data

Which of the following tasks involves the use of SQL statements?

• Creating complex queries

• Creating tables

• Importing data

• Creating forms

What is the purpose of using forms and subforms in a database?

• To facilitate data entry and display related data

• To create tables

• To automate tasks

• To import data

Which of the following is NOT typically included in a database report?

• Grouping

• Sorting

• Input masks

• Calculations

Which of the following is a sign of poor data integrity?

• Conflicting or inconsistent data in the database

• Accurate and consistent data

• Well-organized tables

• Proper use of primary keys

Why do we try to eliminate repeated data in a relational database?

• To increase data size

• To improve data redundancy

• To reduce errors and improve efficiency

• To make data entry more complex

If a database contains only one table, what type of database is it most likely to be?

• Flat file database

• Relational database

• Object-oriented database

• Network database

Which of the following is NOT a feature of relational databases?

• Only one table

• Multiple tables

• Linking tables

• Representing entities