I85PREP
⌘ K
ICDL Using Databases study materials
ICDL Using Databases study resources

ICDL Using Databases practice questions

One question at a time. Build your ICDL Using Databases understanding.

First 50 of 198 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Understanding databases

Which term describes a single row of data in a relational database table?

  1. A key
  2. A record Correct answer.
  3. A field
  4. A query

Explanation

In relational databases, a table is made of rows and columns. Each row is a record (also called a tuple) that holds one complete set of related values, while each column is a field describing one attribute.

Question 2Understanding databases

What is the primary purpose of a primary key in a table?

  1. To sort the records alphabetically
  2. To compress the stored data
  3. To link the table to a report
  4. To uniquely identify each record Correct answer.

Explanation

A primary key is a field or combination of fields whose value is unique for every record and never empty. This guarantees that each row can be identified and referenced without ambiguity.

Question 3Understanding databases

Which data type is most appropriate for storing a person's date of birth?

  1. Date/Time Correct answer.
  2. Boolean
  3. Currency
  4. Text

Explanation

A Date/Time data type stores calendar dates as date values, allowing correct chronological sorting and date arithmetic. Storing dates as text would sort them incorrectly and prevent date calculations.

Question 4Understanding databases

In a relational database, what does a foreign key do?

  1. Defines the width of a field
  2. Encrypts sensitive columns
  3. References the primary key of another table Correct answer.
  4. Calculates totals automatically

Explanation

A foreign key is a field in one table that holds values matching the primary key of another table. It creates a relationship between the two tables and helps enforce referential integrity.

Question 5Understanding databases

A database contains a Customers table and an Orders table, where one customer can place many orders. What is this relationship called?

  1. Self-referencing
  2. One-to-one
  3. One-to-many Correct answer.
  4. Many-to-many

Explanation

When a single record in one table can be associated with multiple records in another table, but each of those records links back to only one record in the first table, the relationship is one-to-many.

Question 6Understanding databases

Which object in a database is used to retrieve selected data from one or more tables based on criteria?

  1. A macro
  2. A form
  3. A query Correct answer.
  4. A report

Explanation

A query is a stored request that selects, filters, and combines data from tables according to specified criteria. It returns a result set rather than presenting or automating the data.

Question 7Understanding databases

What is the main function of a database form?

  1. To provide a user-friendly interface for entering and viewing data Correct answer.
  2. To permanently store the raw records
  3. To back up the database file
  4. To define the relationships between tables

Explanation

A form is an interface object that presents fields from a table or query so users can enter, edit, or view data conveniently. The underlying records are still stored in the tables, not in the form.

Question 8Understanding databases

Which statement best describes a flat-file database?

  1. It always requires a foreign key
  2. It stores all data in a single table Correct answer.
  3. It splits data across many linked tables
  4. It cannot contain text fields

Explanation

A flat-file database keeps all records in one table with no structural links to other tables. Relational databases, by contrast, distribute data across related tables.

Question 9Understanding databases

A company wants to store customer details once and reference them from many invoices without repeating the data. Which approach achieves this?

  1. Store customers in a separate table linked by a key Correct answer.
  2. Use a report to merge the details
  3. Add a text note to each invoice
  4. Copy the customer details into every invoice record

Explanation

Separating customers into their own table and linking invoices through a key avoids duplication and keeps data consistent. This is a core benefit of relational design, known as normalization.

Question 10Understanding databases

What does referential integrity help prevent?

  1. Slow query performance
  2. Records with duplicate primary key values
  3. Orphaned records that reference a missing parent record Correct answer.
  4. Unauthorized user access

Explanation

Referential integrity ensures that a foreign key value always matches an existing primary key value in the related table. This prevents orphaned child records that point to a parent that does not exist.

Question 11Understanding databases

Which field would be the best choice for a primary key in a Students table?

  1. Student enrolment number Correct answer.
  2. Student home town
  3. Student surname
  4. Student year group

Explanation

A primary key must be unique and non-empty for every record. An enrolment number is assigned uniquely to each student, whereas the other fields can repeat or be shared by many students.

Question 12Understanding databases

What is a database index used for?

  1. Restricting which users can edit data
  2. Formatting numbers for display
  3. Speeding up searches on a field Correct answer.
  4. Enforcing that a field is unique

Explanation

An index maintains an ordered structure of field values so the database engine can locate records faster. It improves search and sort performance but does not by itself enforce uniqueness or control access.

Question 13Understanding databases

Which of these is an example of a validation rule rather than a data type?

  1. Currency
  2. Date/Time
  3. Age must be between 0 and 120 Correct answer.
  4. Text

Explanation

A validation rule restricts the values a field can accept, such as a numeric range. Data types such as Text, Date/Time, and Currency define what kind of value is stored, not the permitted range.

Question 14Understanding databases

What distinguishes a database management system (DBMS) from a simple data file?

  1. It stores data only in plain text
  2. It controls access, integrity, and concurrent use of the data Correct answer.
  3. It removes the need for tables
  4. It can only store numeric data

Explanation

A DBMS is software that manages the database, handling access control, integrity enforcement, concurrent users, and recovery. A plain data file provides storage but none of these management functions.

Question 15Understanding databases

Which term refers to the structure of a database, including its tables, fields, and relationships?

  1. The record set
  2. The view
  3. The schema Correct answer.
  4. The index

Explanation

The schema is the formal definition of the database structure: its tables, fields, data types, and relationships. It describes how data is organized rather than the data values themselves.

Question 16Understanding databases

Why is storing the same customer address in many order records considered poor database design?

  1. It prevents the use of primary keys
  2. It forces all fields to be text
  3. It creates redundancy and risks inconsistent data Correct answer.
  4. It makes the database run faster

Explanation

Repeating the same data in multiple records is redundancy; if one copy is updated and others are not, the data becomes inconsistent. Good relational design stores such data once and links to it.

Question 17Understanding databases

Which object would you use to present grouped and formatted data for printing to managers?

  1. A table
  2. A field
  3. A report Correct answer.
  4. A query

Explanation

A report is designed to present data in a formatted layout for viewing, printing, or sharing, often with grouping and totals. Tables store data and queries select it, but neither provides a print-ready presentation.

Question 18Understanding databases

What is a one-to-one relationship between two tables?

  1. No relationship exists between the tables
  2. Each record in one table matches at most one record in the other Correct answer.
  3. Records are matched randomly
  4. Each record matches many records in the other

Explanation

In a one-to-one relationship, each record in the first table is associated with at most one record in the second table, and vice versa. It is often used to split a table for security or optional data.

Question 19Understanding databases

Which data type would best store a yes/no flag indicating whether a membership is active?

  1. Currency
  2. Memo
  3. Date/Time
  4. Boolean Correct answer.

Explanation

A Boolean (Yes/No) data type stores exactly two states, true or false, which suits an active/inactive flag. It uses minimal space and prevents invalid values.

Question 20Understanding databases

What is the effect of setting a field's Required property to Yes?

  1. The field can only contain numbers
  2. The field becomes the primary key
  3. A value must be entered in the field for every record Correct answer.
  4. The field is automatically indexed

Explanation

The Required property forces a value to be present so the field cannot be left empty. It does not by itself index the field, make it a key, or restrict its data type.

Question 21Understanding databases

Which scenario best demonstrates the need for a many-to-many relationship?

  1. Students enrol in many courses, and each course has many students Correct answer.
  2. One order belongs to one customer
  3. Each employee has one payroll number
  4. Each country has one capital city

Explanation

A many-to-many relationship exists when records on both sides can link to many records on the other side, as with students and courses. It is typically implemented with a linking table holding foreign keys to both.

Question 22Understanding databases

What is the purpose of a lookup field in a database table?

  1. To calculate totals across records
  2. To let the user choose from a predefined list of values Correct answer.
  3. To encrypt the stored values
  4. To delete duplicate records

Explanation

A lookup field presents a list of allowed values, often drawn from another table, so the user selects rather than types. This improves accuracy and consistency of the entered data.

Question 23Understanding databases

Which statement about a database view is correct?

  1. It can only display numeric fields
  2. It stores a duplicate copy of all table data
  3. It presents data from a query without storing the underlying records Correct answer.
  4. It replaces the need for tables

Explanation

A view is a saved query that presents selected data as if it were a table, but the data itself remains in the base tables. It can simplify access and restrict which fields are visible.

Question 24Understanding databases

Which of these is a benefit of splitting data into related tables rather than one large table?

  1. It reduces duplicate data and update errors Correct answer.
  2. It guarantees faster internet access
  3. It eliminates the need for backups
  4. It removes the need for data types

Explanation

Related tables store each fact once, which reduces redundancy and the risk of inconsistent updates. Data types and backups are still required in a well-designed relational database.

Question 25Understanding databases

A table stores a full address in one field, making it hard to search by town. What is the best design improvement?

  1. Convert the address to a number
  2. Remove the address field entirely
  3. Split the address into separate fields such as street, town, and postcode Correct answer.
  4. Store the address as a longer text field

Explanation

Splitting a composite value into atomic fields lets each part be searched, sorted, and validated separately. This follows the principle that each field should hold a single piece of data.

Question 26Understanding databases

Which term describes a single row in a database table?

  1. Table
  2. Query
  3. Record Correct answer.
  4. Field

Explanation

A record is one complete set of related data items, corresponding to a row in a table. A field is a column, a table is the collection of records, and a query is a request for data.

Question 27Understanding databases

Which database object is used to enter or edit data one record at a time in a structured layout?

  1. Query
  2. Form Correct answer.
  3. Report
  4. Macro

Explanation

A form provides a user-friendly interface for data entry and editing, often showing one record at a time. Reports are for output, queries for retrieval, and macros for automation.

Question 28Understanding databases

What does a foreign key in a table do?

  1. Calculates totals for a group of records
  2. Ensures all values in a field are unique
  3. Defines the maximum length of a text field
  4. References the primary key of another table Correct answer.

Explanation

A foreign key stores a value that matches a primary key in another table, creating a relationship between the tables. Uniqueness is enforced by primary keys or unique constraints, not foreign keys.

Question 29Understanding databases

Which statement best describes a relational database?

  1. All data is stored in a single table
  2. Data is organized into tables that can be linked by common fields Correct answer.
  3. Each record is stored as a separate document
  4. Data is stored as plain text files in folders

Explanation

A relational database uses multiple tables with relationships established through common fields, typically primary and foreign keys. Single-table storage, plain text files, and separate documents describe other models.

Question 30Understanding databases

What is the main advantage of using a database over a paper filing system?

  1. It removes the need for any user training
  2. Data can be quickly searched and shared by multiple users Correct answer.
  3. It guarantees that data is always accurate
  4. It eliminates the need for data backup

Explanation

Databases enable fast retrieval and controlled multi-user access, which is a key advantage over paper files. They do not remove the need for backups, guarantee accuracy, or eliminate training.

Question 31Understanding databases

Which of these is a common example of a database management system?

  1. Microsoft Word
  2. Adobe Photoshop
  3. Google Chrome
  4. Microsoft Access Correct answer.

Explanation

Microsoft Access is a database management system used to create and manage databases. Word is a word processor, Photoshop is an image editor, and Chrome is a web browser.

Question 32Understanding databases

A table has a field for telephone numbers. Which data type is most suitable to preserve leading zeros and formatting?

  1. AutoNumber
  2. Currency
  3. Number
  4. Text Correct answer.

Explanation

Text preserves leading zeros and characters such as spaces or hyphens in phone numbers. Number, Currency, and AutoNumber store numeric values and would drop leading zeros or formatting.

Question 33Understanding databases

In a table of employees, which field would be the most appropriate primary key?

  1. HireDate
  2. LastName
  3. EmployeeID Correct answer.
  4. Department

Explanation

EmployeeID is a unique identifier for each employee, making it ideal as a primary key. LastName, Department, and HireDate can have duplicates and are not guaranteed unique.

Question 34Understanding databases

Which validation rule would correctly ensure that a numeric field accepts only values between 1 and 100 inclusive?

  1. >=1 And <=100 Correct answer.
  2. Between 1 Or 100
  3. 1 To 100
  4. >1 And <100

Explanation

The expression >=1 And <=100 uses comparison operators and the And logical operator to enforce the inclusive range. The other options use incorrect syntax or exclude the endpoints.

Question 35Understanding databases

A table contains a field for storing postal codes. Which property would best limit entry to a maximum of 10 characters?

  1. Field Size Correct answer.
  2. Format
  3. Caption
  4. Input Mask

Explanation

Field Size sets the maximum length for text fields, directly limiting characters. Format controls display, Input Mask guides entry patterns, and Caption changes the label.

Question 36Understanding databases

Which relationship type is created when one record in Table A can relate to many records in Table B, but each record in Table B relates to only one record in Table A?

  1. One-to-one
  2. Self-referencing
  3. Many-to-many
  4. One-to-many Correct answer.

Explanation

A one-to-many relationship links a single record in one table to multiple records in another. One-to-one links single records, many-to-many requires a junction table, and self-referencing links a table to itself.

Question 37Understanding databases

What is the purpose of an input mask on a field?

  1. To calculate a value automatically from other fields
  2. To control the pattern of data entered, such as a phone number format Correct answer.
  3. To restrict data to a list of predefined values
  4. To hide the field from users

Explanation

An input mask provides a template that guides users to enter data in a consistent format. Restricting to a list is done by a lookup field, calculations by expressions, and hiding by form design.

Question 38Understanding databases

Which statement about a query is correct?

  1. It can select, filter, and sort data from one or more tables Correct answer.
  2. It can only be based on a single table
  3. It is used only for printing formatted output
  4. It permanently stores data in a new table by default

Explanation

A query retrieves data according to criteria and can combine multiple tables, filter rows, and sort results. It does not by default store data permanently and is not limited to one table or to printing.

Question 39Understanding databases

What does the term 'normalization' refer to in database design?

  1. Converting all text fields to numeric fields
  2. Organizing data to reduce redundancy and improve integrity Correct answer.
  3. Encrypting sensitive data in tables
  4. Creating a backup copy of the database

Explanation

Normalization structures tables and relationships to minimize duplicate data and avoid update anomalies. It is not about changing data types, backups, or encryption.

Question 40Understanding databases

A database contains a Customers table and an Orders table. Which field in the Orders table would typically be the foreign key?

  1. CustomerID Correct answer.
  2. OrderDate
  3. OrderTotal
  4. OrderID

Explanation

CustomerID in Orders references the primary key CustomerID in Customers, creating the relationship. OrderID is the primary key of Orders, while OrderDate and OrderTotal are descriptive fields.

Question 41Understanding databases

Which of these best describes the role of a database schema?

  1. It provides a user interface for data entry
  2. It defines the structure of tables, fields, and relationships Correct answer.
  3. It automatically backs up the database
  4. It stores the actual data records

Explanation

A schema is the blueprint of the database, specifying tables, fields, data types, and relationships. It does not hold the data itself, serve as an interface, or perform backups.

Question 42Understanding databases

What is the main purpose of a report in a database?

  1. To present data in a formatted, printable layout Correct answer.
  2. To establish relationships between tables
  3. To enter new records into a table
  4. To define validation rules for fields

Explanation

Reports organize and format data for output, often for printing or sharing. Data entry is done through forms, validation rules are field properties, and relationships are defined in the schema.

Question 43Understanding databases

Which statement correctly describes a many-to-many relationship?

  1. It is the same as a one-to-one relationship
  2. It can be created directly between two tables without an intermediary
  3. It requires a junction table to link the two tables Correct answer.
  4. It allows only one record on each side

Explanation

Many-to-many relationships are implemented using a junction table that contains foreign keys referencing both tables. They cannot be represented directly between two tables in a relational database.

Question 44Understanding databases

A table stores both a customer's city and the city's postal code in every order record. This leads to update anomalies. Which design change best addresses this?

  1. Split the table into two identical tables
  2. Create an index on the city field
  3. Add a validation rule to the postal code field
  4. Move city and postal code to a separate Cities table and reference it with a foreign key Correct answer.

Explanation

Storing city and postal code in a separate table removes redundancy and prevents update anomalies, with a foreign key linking orders to cities. Validation, indexing, or duplicating tables do not resolve the redundancy.

Question 45Understanding databases

In a relational database, what is the effect of enforcing referential integrity between Orders and Customers?

  1. A customer can be deleted even if orders exist for that customer
  2. An order cannot reference a customer that does not exist Correct answer.
  3. The CustomerID field in Orders can contain duplicate values
  4. The Orders table can have multiple primary keys

Explanation

Referential integrity ensures that foreign key values match an existing primary key, preventing orphan records. It restricts deletion of referenced customers and does not allow multiple primary keys.

Question 46Understanding databases

Which field property would you use to ensure that a date field cannot be set to a future date?

  1. Validation Rule Correct answer.
  2. Default Value
  3. Input Mask
  4. Format

Explanation

A validation rule can include a condition such as <=Date() to reject future dates. Input masks control format, default values prefill data, and format controls display.

Question 47Understanding databases

A database has a Books table and an Authors table. A book can have multiple authors, and an author can write multiple books. Which implementation correctly models this?

  1. Merge the Books and Authors tables into one table
  2. Add an AuthorID foreign key to the Books table
  3. Add a BookID foreign key to the Authors table
  4. Create a BookAuthors junction table with foreign keys to both Books and Authors Correct answer.

Explanation

A many-to-many relationship requires a junction table containing foreign keys to both related tables. Adding a foreign key to either side only supports one-to-many, and merging tables introduces redundancy.

Question 48Understanding databases

Which statement about a primary key is always true?

  1. It can contain duplicate values if indexed
  2. It must be the first field in the table
  3. It must be a numeric field
  4. It cannot contain null values Correct answer.

Explanation

A primary key must uniquely identify each record and therefore cannot be null. It can be text or numeric, does not have to be the first field, and cannot contain duplicates.

Question 49Understanding databases

In a database table, what is a record best described as?

  1. A rule that restricts the values typed into a field
  2. A complete set of related field values about one entity Correct answer.
  3. A single column that stores one type of data
  4. A saved instruction that filters rows

Explanation

A table is made of rows and columns; each row is a record holding all the field values that describe one entity, such as one customer. A column, by contrast, holds one attribute for every record.

Question 50Understanding databases

A library database has a Loans table. Each loan must always be linked to a borrower who already exists in the Members table. Which feature enforces this requirement?

  1. An input mask on the loan date
  2. A calculated field that totals overdue days
  3. Referential integrity on the borrower key Correct answer.
  4. A sort order applied to the Members table

Explanation

Referential integrity checks that a foreign key value in the child table matches an existing primary key value in the parent table. This prevents loans from being saved for borrowers who are not in the Members table.