ICDL Using Databases Exam Flashcards

Q: Which ICDL module does this flashcard set cover?

It covers ICDL South Africa's Using Databases module, not Advanced Database. The cards follow the six categories in ICDL Databases Syllabus 6.0: Understanding Databases, Using the Application, Tables, Retrieving Information, Forms, and Outputs.

Q: Is Syllabus 6.0 the only version currently used in South Africa?

No. ICDL South Africa publishes Syllabus 6.0 and Syllabus 6.0 sample tests, but its module page also says Syllabus 5.0 remains in use during a transition period. Confirm the version and supported database application with your Accredited Test Centre.

Q: What is the pass mark for ICDL Using Databases in South Africa?

ICDL South Africa states that the pass mark is 75% for all modules. It does not publish a current nationwide candidate pass-rate percentage, so the pass rate is listed as not published.

Q: How many questions and how much time are allowed?

Not published by ICDL South Africa on its current Using Databases or general FAQ pages. Test delivery is automated and supervised at an Accredited Test Centre, so ask your centre for the current test specification instead of relying on an unofficial fixed count or duration.

Q: When can I retake a failed ICDL module?

ICDL South Africa requires a 24-hour wait before rewriting a failed module, after which you may use the next available time at your chosen Accredited Test Centre. Its public FAQ does not state a longer wait after three failures, so both retake fields use the same one-day rule; additional fees may apply.

Q: Do I have to complete training before the test?

No. ICDL South Africa says training is not compulsory if you already meet the syllabus criteria. You still need a candidate registration number and must take the certification test under examination conditions at an ICDL Accredited Test Centre.

Question 1

What is a database?

Accepted Answer

An organised collection of related data that can be stored, maintained, and retrieved systematically. The organisation makes it possible to find and analyse records without treating every item as an unrelated file.

Question 2

How does information differ from data?

Accepted Answer

Data consists of raw facts; information is the meaningful output produced by processing or organising those facts. A list of sale amounts is data, while a monthly sales total is information.

Question 3

How do tables, records, and fields relate?

Accepted Answer

A table stores one subject type, each row is a record about one subject instance, and each field holds one attribute of that record. For example, one Customer record can contain Name and Phone fields.

Question 4

Why should one table represent one subject type?

Accepted Answer

It keeps each record structurally consistent and avoids mixing unrelated entities. Customers and Orders belong in separate tables because one customer can have multiple orders.

Question 5

Why should a field contain one data element?

Accepted Answer

Atomic values can be searched, sorted, validated, and updated independently. Combining city and postal code in one field makes both values harder to query and maintain.

Question 6

What does a field's data type control?

Accepted Answer

It controls the kind of value the field accepts and which operations are valid. Numbers support arithmetic, dates support date operations, and yes/no fields restrict input to two logical states.

Question 7

How is a field property different from a data type?

Accepted Answer

The data type defines the kind of data; properties refine how that field behaves or appears. Field size, display format, and default value are properties rather than separate data types.

Question 8

What is the purpose of a primary key?

Accepted Answer

It uniquely identifies each record in a table. A stable unique key prevents two records from being indistinguishable and provides a dependable value for table relationships.

Question 9

What is the main purpose of an index?

Accepted Answer

An index speeds searches and query retrieval on the indexed field. It is a performance aid; it does not replace a primary key or define the meaning of the data.

Question 10

Why relate database tables?

Accepted Answer

Relationships let tables share a matching key instead of repeating the same descriptive data. This reduces duplication and makes consistent updates easier to maintain.

Question 11

How is closing a database different from closing its application?

Accepted Answer

Closing the database ends work on that data file while the database program may remain open. Closing the application exits the program and closes any open database objects with it.

Question 12

Why choose the save location when creating a database?

Accepted Answer

The location determines where the database file is stored and later found, backed up, or shared. A clear filename and appropriate folder reduce the risk of editing the wrong copy.

Question 13

What is the benefit of hiding an unused toolbar or minimising the ribbon?

Accepted Answer

It increases the workspace available for database objects without deleting commands. Restoring the interface brings the commands back when they are needed.

Question 14

When should built-in Help be used?

Accepted Answer

Use it to locate a command, understand an option, or resolve an unfamiliar task within the installed application. It is more reliable than guessing through design changes that may affect stored data.

Question 15

Which objects can be opened and closed independently?

Accepted Answer

Tables, queries, forms, and reports are separate database objects. Closing one object does not close the database, and saving an object's design does not mean every other object was changed.

Question 16

Why switch between data and design views?

Accepted Answer

Data-oriented views display or edit records, while design-oriented views change an object's structure or layout. Confusing them can lead to editing content when you intended to change design, or vice versa.

Question 17

How does deleting an object differ from deleting a record?

Accepted Answer

Deleting an object removes an entire table, query, form, or report definition. Deleting a record removes one row of stored data, so the scope and consequences are very different.

Question 18

How does deleting a record differ from clearing one field?

Accepted Answer

Deleting a record removes the entire row and all of its values. Clearing a field changes only one value in an otherwise existing record.

Question 19

Which data type suits a value used in arithmetic?

Accepted Answer

Use a numeric type when the stored value must participate in calculations. An identifier that merely looks numeric, such as a telephone number, is usually text because arithmetic on it has no meaning.

Question 20

What does a text field's size property limit?

Accepted Answer

It limits how many characters the field can store. A sensible limit helps reject overlong entries, while a limit that is too small can truncate or block valid data.

Question 21

Does changing a field's format change its stored value?

Accepted Answer

Normally, format changes how the value is displayed, not the underlying value. The same date can appear in different layouts while remaining the same stored date.

Question 22

What does a default value do?

Accepted Answer

It supplies an initial value for new records when the user enters nothing else. It speeds consistent entry but can still be replaced when the new record requires a different value.

Question 23

Why inspect existing data before changing a field type?

Accepted Answer

Existing values may not convert to the new type and can be rejected, altered, or lost. Check compatibility and make a backup before changing a populated field's definition.

Question 24

What is the purpose of a numeric validation rule?

Accepted Answer

It rejects values outside an allowed condition, such as a quantity below zero. Validation protects new or edited data; it is not merely a display format.

Question 25

When should an indexed field disallow duplicates?

Accepted Answer

Disallow duplicates when each indexed value must be unique, such as an assigned membership number. Allow them when repeated values are legitimate, such as many customers sharing a city.

Question 26

What defines a one-to-many relationship?

Accepted Answer

One record in the parent table can match several records in the related table, while each related record points back to one parent. One Customer linked to many Orders is the standard pattern.

Question 27

What does referential integrity prevent?

Accepted Answer

It prevents related records from referring to a parent key that does not exist. This avoids orphan records and preserves the consistency of the relationship between tables.

Question 28

How does searching differ from filtering?

Accepted Answer

Searching moves to a matching value, while filtering temporarily displays only records that meet a condition. A search locates; a filter narrows the visible set.

Question 29

What happens when a filter is removed?

Accepted Answer

Records hidden by the filter become visible again. Removing a filter does not delete those records because filtering changes the view, not the stored data.

Question 30

How is a saved query different from a temporary filter?

Accepted Answer

A query is a named database object that can select fields, combine tables, apply criteria, and be run again. A filter is usually a temporary restriction on records shown in a table or form.

Question 31

What enables a two-table query to match records correctly?

Accepted Answer

The query needs related fields or a defined relationship that connects the tables' matching values. Without a valid match, results may omit records or produce meaningless combinations.

Question 32

Which operator means “not equal to” in query criteria?

Accepted Answer

The operator is <>. It returns values different from the criterion; it should not be confused with > or <, which compare size or order.

Question 33

What does AND require in query criteria?

Accepted Answer

Every condition joined by AND must be true for a record to match. AND normally narrows results because each additional condition adds another requirement.

Question 34

What does OR require in query criteria?

Accepted Answer

At least one condition joined by OR must be true. OR normally broadens results because a record may qualify through any listed alternative.

Question 35

What does NOT do in query criteria?

Accepted Answer

NOT excludes records that satisfy the stated condition. It reverses the condition's inclusion logic rather than comparing two values for inequality by itself.

Question 36

How do single- and multi-character wildcards differ?

Accepted Answer

A multi-character wildcard such as * or % can stand for any sequence of characters; a single-character wildcard such as ? or _ stands for exactly one. The accepted symbol depends on the application.

Question 37

Does sorting a query change which records qualify?

Accepted Answer

No. Sorting changes the order of returned records, while criteria determine membership in the result. A descending sort does not act as a filter.

Question 38

What is a form primarily used for?

Accepted Answer

A form provides a controlled layout for displaying, adding, and editing records. It is an interface to stored data, not a separate copy of every record it shows.

Question 39

Why give a form a meaningful name?

Accepted Answer

A descriptive name communicates the form's task or data source and helps users distinguish it from other forms. The name identifies the object; it does not become record data.

Question 40

What happens when a record is deleted through a form?

Accepted Answer

The underlying record is deleted from its data source; only the form's layout remains. A form is not a disposable view that shields stored data from record deletion.

Question 41

How does form header text differ from field data?

Accepted Answer

Header or footer text labels or explains the form and usually stays constant across records. Field controls display values that change as the user moves between records.

Question 42

What is a report primarily used for?

Accepted Answer

A report presents selected database information in a structured output for viewing, printing, or distribution. Unlike a form, it is designed mainly for presentation rather than routine record entry.

Question 43

Why base a report on a query instead of a whole table?

Accepted Answer

A query can preselect fields, combine related tables, and restrict records before the report formats them. This separates data selection from presentation.

Question 44

What does grouping add to a report?

Accepted Answer

Grouping organises records into categories based on a shared value, such as orders by customer. It enables group headings and group-level summaries rather than one undifferentiated list.

Question 45

Which summaries can a grouped report calculate?

Accepted Answer

Syllabus 6.0 includes sum, minimum, maximum, and average. Choose the summary that answers the reporting need; for example, use average for a typical value and sum for a total.

Question 46

What changes when report fields are rearranged?

Accepted Answer

The presentation order and layout change, not the underlying table or query values. Rearranging fields can improve readability without redesigning the data source.

Question 47

What belongs in a report header or footer?

Accepted Answer

Use it for repeated context such as a title, date, page number, or explanatory label. Record-specific values belong in the report's detail or group sections.

Question 48

Which export formats does Syllabus 6.0 distinguish?

Accepted Answer

Tables and query results may be exported to spreadsheet, text, CSV, or XML; report output may be exported to PDF. Data-oriented formats support reuse, while PDF preserves a report's presentation.

Question 49

When is landscape orientation useful?

Accepted Answer

Landscape is useful when an output is too wide for portrait, such as a table with many columns. Orientation and paper size affect page layout, not the stored database records.

Question 50

Why check print scope before printing?

Accepted Answer

Database objects allow different scopes, such as selected records, a query result, specific report pages, or a complete report. Confirming scope prevents omitted data and unnecessary pages.

Free ICDL Using Databases Exam Flashcards

Filter by Topic

Jump to Card

About These ICDL Using Databases Flashcards

Topics Covered

Frequently Asked Questions

ICDL South Africa — Using Databases Module

Explore More ICDL South Africa Digital Literacy

ICDL South Africa — Computer Essentials Module

ICDL South Africa — IT Security Module

ICDL South Africa — Online Essentials Module

ICDL South Africa — Presentation Module

ICDL South Africa — Spreadsheets Module

ICDL South Africa — Word Processing Module