Database Fundamentals Quiz

What is the primary purpose of a database?

• To store information for easy access

• To manage and organize physical files

• To perform calculations without data storage

• To automate business operations

Which of the following is NOT an advantage of using a Database Management System (DBMS)?

• Faster data access

• Reduced probability of inconsistent data

• Increased storage cost

• Flexibility in handling data

What defines the kind of data a field in a database table can store, such as text, numbers, or dates?

• Record

• Field

• Table

• Data Type

It stores data in plain text format and is organized as a single table with no relationships between tables.

• relational database

• slant file database

• flat file database

• correlational database

What is a 'record' in a database table?

• A specific item in a table

• A category of data

• The foundation of a table

• The primary key used to link tables

Which of the following is NOT a component of Microsoft Access?

• Ribbon

• Quick Access Toolbar

• Database Console

• Backstage View

What is the function of a 'Crosstab Query' in Microsoft Access?

• Retrieves specific data from multiple tables

• Summarizes data in a matrix format

• Prompts users for input criteria

• Modifies existing data records

What type of relationship allows a single record in one table to relate to multiple records in another table?

• One-to-One

• One-to-Many

• Many-to-Many

• Self-Relationship

What is the role of the 'Shutter Bar' in Microsoft Access?

• Manages database system settings

• Displays database objects like tables and queries

• Provides quick access to frequently used commands

• Generates complex queries automatically

A customizable toolbar that provides quick access to frequently used commands, such as Save, Undo, and Redo.

• Quick Access Toolbar

• Ribbon

• Tell Me

• Shutter Bar