A community centre in Cork is building a membership database through an ICS Skills ICDL course. According to ICDL Using Databases Syllabus 6.0, what is a database?
Understanding Databases
Question · Easy
A Galway retail trainee enters product codes at the till and later views a stock summary report. In ICDL terms, the summary report represents:
An ICDL candidate at a Dublin ETB centre opens a sample customer database. The syllabus organises database content into:
Tech Exam Prep Podcast
Listen on Spotify
Podcast
While editing customer records in a table at an Irish test centre, a candidate notices edits appear immediately without clicking Save. Syllabus 6.0 explains that:
Question · Medium
Which scenario best matches a common database use listed in ICDL Using Databases Syllabus 6.0?
A Limerick sports club wants separate tables for Members and Bookings rather than one combined list. Syllabus 1.2.1 recommends each table hold data about:
In a Members table, each row represents one member. In ICDL terminology that row is a:
The Email column in a Volunteers table is an example of a:
Which data type is most appropriate for a DateJoined field storing when a member joined an Irish community group?
A ProductPrice field should store euro amounts with two decimal places. Which data type category does the syllabus list for numeric values?
An ActiveMember field records whether each person is currently active (true or false). The matching syllabus data type is:
Why might a database designer set a default value of Ireland for a Country field?
A StudentID field must uniquely identify each learner in a Waterford training database. Syllabus 6.0 designates this role to the:
An index on a Surname field helps the database application:
When indexing a field, choosing no duplicates allowed means:
Tables
Question · Hard
A Orders table links to a Customers table so each order references one customer but a customer may have many orders. This is a:
Referential integrity between linked tables ensures that:
Storing a customer's name and address on every order line instead of linking to a Customers table mainly causes:
Before creating relationships, an ICDL candidate should ensure each table represents:
At an ICS Skills accredited test centre, a candidate finishes practising and wants to exit the database program entirely. Syllabus 2.1.1 requires the skill to:
Using The Application
A trainee closes the current membership database but keeps the database program open to work on another file. This demonstrates:
When creating a new database for a school fundraiser, why must you save it to a drive location first?
A candidate accidentally minimises the ribbon and cannot find familiar commands. Syllabus 2.1.4 expects them to:
Unsure how to set a validation rule, an ICDL student should first consult:
Which objects can candidates open, save, and close according to syllabus 2.2.1?
To change a field's data type and field size, a candidate should switch the table to:
In Datasheet view, the navigation buttons at the bottom of the window let a candidate:
When a table has more records than fit on screen, syllabus 2.2.4 expects candidates to use:
A volunteer list should display surnames from A to Z. Which action matches syllabus 2.2.5?
To review the most recently added bookings first, sort the BookingDate field in:
Deleting a query object from the navigation pane removes:
Switching from Design view to Datasheet view for a table allows a candidate to:
A candidate opens an existing inventory database from a network folder at an Irish college. This matches syllabus task:
Which view is most appropriate for quickly typing several new member rows into a table?
A charity volunteer adds a new donor row in Datasheet view. This satisfies syllabus task:
An outdated event registration must be removed from the Registrations table. Syllabus 3.1.1 requires the ability to:
Correcting a mistyped phone number in an existing member row is syllabus task:
When creating a new Products table, syllabus 3.2.1 requires specifying each field's:
A QuantityInStock field should display whole numbers with no decimals. Which field property from syllabus 3.2.2 applies?
Changing a phone-number field from Text to Number could cause problems because:
A validation rule requiring Age to be between 16 and 120 is an example of syllabus task:
Before linking tables, a designer sets MemberID as the unique identifier in the Members table. This is syllabus task:
To speed lookups on Surname, a candidate indexes the field with duplicates allowed because:
A new Notes field must be added to an existing Volunteers table. This matches syllabus:
A Surname column is too narrow to show long Irish family names. Syllabus 3.2.8 expects the candidate to:
Linking Orders to Customers so each order references exactly one customer is syllabus task:
A database redesign requires removing the link between Projects and Clients tables. Syllabus 3.3.2 covers:
Loading more…