ICDL Databases / Using Databases (ICDL Foundation)

According to ICDL Using Databases Syllabus 6.0, what is a database?

• AAn organised collection of structured data stored and managed by a database application
• BA word processing document with formatted paragraphs only
• CA network cable diagram showing router connections
• DAn audio file stored on a portable music player

In the ICDL syllabus, information is best described as:

• ARaw unprocessed numbers and text entered at a keyboard
• BThe processed output of data that has meaning for a user
• CA printer driver installed on the operating system
• DA compressed ZIP archive of unrelated files

How is a database organised in terms of structure according to the ICDL syllabus?

• AWorksheets, cells, and formulas only
• BSlides, animations, and transitions
• CTables, records, and fields
• DHeaders, footers, and page margins only

Regarding data storage in a database, the ICDL syllabus states that:

• AData is stored only in temporary RAM and never on disk
• BChanges must be manually saved with a separate Save command like a word processor
• CData is stored exclusively in report footers
• DAll database data is stored in tables and changes are automatically saved

Which of the following is listed in the ICDL syllabus as a common use of databases?

• AHospital patient details and bank account records
• BEditing video special effects in a timeline
• CConfiguring BIOS boot order on a motherboard
• DCompiling C++ source code into machine language

Good database design according to syllabus 1.2.1 means each table should contain data related to:

• AEvery subject type in the organisation in one table
• BA single subject type only
• COnly report headers and footers
• DRandom unrelated topics mixed together

Each record in a database should contain data related to:

• AMultiple unrelated customers in one row
• BOnly the primary key with no other fields
• CA single subject such as one customer or one order
• DEvery field definition in the database

Each field in a table should contain:

• AAt least five unrelated data elements
• BComplete multi-paragraph essays by default
• CEntire backup copies of other tables
• DOnly one element of data

Which data types does the ICDL Using Databases syllabus associate with field content?

• AText, number, date/time, and yes/no
• BJPEG, MP3, AVI, and GIF only
• CHTML, CSS, JavaScript, and PHP only
• DExecutable, batch, shell, and binary only

Which field properties does the ICDL syllabus identify as associated with fields?

• ACPU clock speed, RAM voltage, and fan RPM
• BField size, format, and default value
• CMonitor resolution, refresh rate, and colour depth
• DRouter SSID, WPA key, and channel width only

What is a primary key in a database table?

• AA decorative font applied to report headings
• BThe password used to log in to the operating system
• CA unique identifier that distinguishes each record in a table
• DA printer setting for duplex colour output

What is the main purpose of an index on a database field according to the ICDL syllabus?

• ATo change the paper orientation to landscape
• BTo add animated transitions between form pages
• CTo delete all records in a table automatically
• DTo speed up search queries

The main purpose of relating tables in a database is to:

• AMinimise duplication of data
• BMaximise duplication of every field in every table
• CPrevent users from running any queries
• DRemove the need for primary keys entirely

A relationship between two tables is built by:

• AMerging every field from both tables into one column
• BMatching a unique field in one table with a field in another table
• CDeleting the smaller table without saving
• DPrinting both tables to PDF simultaneously

Why is maintaining the integrity of relationships between tables important?

• AIt disables all filters and queries permanently
• BIt converts every report to an audio file
• CIt ensures linked records stay consistent and valid across related tables
• DIt removes the need for any field data types

An airline stores flight reservations so seats are not double-booked. Why is a database better suited to this than a single spreadsheet?

• AA database enforces structure, relationships, and integrity rules across many related rec…
• BA database cannot store more than one reservation at a time
• CA spreadsheet automatically prevents every possible data entry error
• DA database converts all reservations into audio files for playback

Storing a customer's date of birth in a field should use which data type per syllabus 1.2.4?

• ADate/time
• BYes/No
• CText only with no date support
• DExecutable binary

A field that stores whether a product is active (true/false) should use which data type?

• ANumber with three decimal places
• BYes/No
• CDate/time
• DMemo for multi-page text only

Which statement about a primary key is correct?

• AIts value must be unique for every record and cannot be left empty
• BIt may be duplicated freely across many records
• CIt is optional decorative text shown only in report headers
• DIt stores the user's operating-system login password

Which actions does syllabus 2.1.1 require for the database application itself?

• ACompile source code and deploy a web server
• BFormat paragraphs and insert page breaks
• CCreate pivot charts from worksheet data
• DOpen and close the database application

What is the difference between closing a database file and closing the database application?

• AClosing the file leaves the application open for another database; closing the applicatio…
• BThere is no difference; both delete all tables in the database
• CClosing the file uninstalls the application from the computer
• DClosing the application automatically deletes the database file

When you create a new database, why must you save it to a location on a drive before adding tables?

• AThe database file must exist on disk so its objects and data can be stored persistently
• BSaving converts the database into a spreadsheet workbook
• CA database can only ever be saved to cloud storage, never a local drive
• DTables cannot be created until the database is printed first

Regarding the ribbon and toolbars, the ICDL syllabus expects candidates to:

• APermanently delete the ribbon from the operating system
• BConvert the ribbon into a database table
• CDisplay or hide built-in toolbars and restore or minimise the ribbon
• DShare the ribbon on social media platforms

You are unsure how to apply a validation rule in your database application. What is the most appropriate first step?

• AUse the application's built-in Help resources to look up the feature
• BDelete the table and start the whole database again
• CUninstall and reinstall the operating system
• DExport the database to PDF and stop working

Which database objects can candidates open, save, and close per syllabus 2.2.1?

• ATable, query, form, and report
• BWorksheet, chart, and pivot table only
• CSlide, animation, and transition only
• DEmail message, calendar event, and contact only

In a database application, what is the main purpose of Design view compared with Datasheet view for a table?

• ADesign view prints the table while Datasheet view emails it
• BDesign view defines fields, data types, and properties; Datasheet view displays and edits…
• CBoth views do exactly the same thing with no difference
• DDesign view plays animations while Datasheet view records audio

What is the difference between deleting all records in a table and deleting the table itself?

• ADeleting records empties the table but keeps its structure; deleting the table removes th…
• BThere is no difference; both leave the empty table behind
• CDeleting records also deletes every other object in the database
• DDeleting the table only hides it temporarily and keeps all its data

In a form showing one record at a time, which control lets you move to the next or previous record?

• AThe record navigation buttons at the bottom of the form
• BThe paper-size setting in print preview
• CThe validation rule on a numeric field
• DThe referential integrity option in relationships

How does sorting a table differ from filtering it?

• ASorting reorders all records by a field's values; filtering hides records that do not mat…
• BSorting deletes non-matching records; filtering reorders them
• CSorting and filtering both permanently delete records from the table
• DSorting changes field data types; filtering renames the table

Sorting surnames from Z to A in a table is an example of:

• AAscending alphabetic order
• BDescending alphabetic order
• CAscending numeric order
• DRandom record shuffle

A multi-page report is open in print preview. What does the page navigation control do?

• AIt moves the on-screen preview between pages of the report without changing the data
• BIt permanently deletes pages from the printed report
• CIt changes the report's underlying query criteria
• DIt exports each page as a separate database file

The ICDL Using Databases module's overall goal includes the ability to:

• ADesign enterprise WAN topologies exclusively
• BWrite operating-system kernel modules in assembly
• CEdit 4K video timelines with transitions
• DCreate routine reports and prepare outputs ready for print or electronic distribution

Why might a user minimise the ribbon or hide built-in toolbars in a database application?

• ATo free up screen space for viewing more records or design area
• BTo permanently remove the toolbars from every application on the computer
• CTo delete the data stored in the open table
• DTo change the table's primary key field

Switching between Datasheet view and Design view in a table is an example of:

• AChanging operating-system user accounts
• BSwitching between view modes per syllabus 2.2.2
• CApplying referential integrity in relationships
• DExporting query output to XML format

In a Customers table, what does adding a new record do?

• AIt creates one new row holding the data for one additional customer
• BIt adds a new field column to every record in the table
• CIt deletes the existing customers to make room
• DIt changes the data type of the primary key field

A customer changes their phone number. Which action correctly updates the database?

• ADelete the entire customer record and the whole table
• BModify the data in the phone field of that customer's existing record
• CAdd a new field column called NewPhone for every customer
• DChange the table's primary key to the new phone number

When creating a table, which data types does syllabus 3.2.1 require candidates to specify?

• AText, number, date/time, and yes/no
• BMP3, WAV, FLAC, and AAC
• CIPv4, IPv6, MAC, and DNS only
• DBold, italic, underline, and strikethrough

Setting a Text field's field size to 2 characters for a province code mainly helps by:

• ALimiting entries to the intended length and reducing invalid data
• BAutomatically translating the code into another language
• CConverting the field into a yes/no data type
• DDeleting any record that already has a province code

A field already containing values like "N/A" and "TBC" is changed from Text to Number. What is the likely consequence?

• AThose non-numeric entries are lost or cause conversion errors
• BThe text values are automatically converted into valid numbers
• CEvery relationship in the database is deleted
• DThe table is renamed to match the new data type

What is the main benefit of adding a validation rule to a field at table-design time?

• AIt rejects invalid entries as they are typed, improving data accuracy at the source
• BIt speeds up the computer's processor during data entry
• CIt automatically prints the table after each entry
• DIt removes the need to ever back up the database

In a Students table, which field is the best choice to set as the primary key?

• AStudentID, a unique number assigned to each student
• BSurname, because many students can share a surname
• CCity, since students live in only a few cities
• DEnrolmentDate, which several students share

When indexing a field, what does choosing "Yes (Duplicates OK)" allow compared with "Yes (No Duplicates)"?

• AThe field is converted into the table's primary key automatically
• BRepeated values are permitted in the field while still speeding up searches
• CAll existing duplicate records are deleted from the table
• DThe field can no longer be searched or sorted at all

You need to start recording each customer's email address in an existing Customers table. What is the correct approach?

• AAdd a new Email field to the existing table
• BCreate a separate new database just for email addresses
• CStore the email inside the existing Surname field
• DDelete the table and re-enter every customer from scratch

Widening a column in a table's Datasheet view affects:

• AOnly how the data is displayed on screen, not the stored values
• BThe data type of the field, changing it to text
• CThe actual values stored, truncating long entries permanently
• DThe primary key, making it allow duplicates

To create a one-to-many relationship between a Customers table and an Orders table, which fields are typically joined?

• AThe CustomerID primary key in Customers to a matching CustomerID field in Orders
• BThe Surname field in Customers to the OrderDate field in Orders
• CTwo fields that contain completely unrelated data
• DThe report footer of Customers to the form header of Orders

What happens to the two tables when you delete the one-to-many relationship between them?

• AThe tables and their records remain; only the link between them is removed
• BBoth tables and all their records are permanently deleted
• CThe two tables are merged into a single table
• DAll field data types in both tables are reset to text

With referential integrity enforced, what happens if you try to delete a Customer who still has Orders?

• AThe database blocks the deletion to avoid leaving orders with no matching customer
• BAll orders in the database are deleted along with the customer automatically and silently
• CThe customer is converted into an order record
• DReferential integrity is switched off for the whole database