PracticeVideosBlogFlashcards
All Practice Exams

Free Practice Questions for CAPE Information Technology Unit 2

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
88+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Caribbean CSEC & CAPE Exams

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Bahamas General Certificate of Secondary Education

Practice Questions100 questions

BGCSE Bookkeeping & Accounts

Practice Questions100 questions

CAPE Biology Unit 1

Practice Questions100 questions

CAPE Caribbean Studies

Practice Questions100 questions

CAPE Chemistry Unit 1

Practice Questions100 questions

CAPE Communication Studies

Practice Questions100 questions
Exam Review

Key Facts: CAPE Information Technology Unit 2 Exam

45

Paper 01 Questions

CXC Syllabus

90m

Paper 01 Time Limit

CXC Syllabus

Grade V

Minimum Passing Grade

CXC Grading Policy

3

Syllabus Modules

CXC Syllabus

BBD $69.50

Subject Fee

CXC Fee Schedule

BBD $48.50

Candidate Entry Fee

CXC Fee Schedule

CAPE IT Unit 2 combines Paper 01 (45 MCQs, 90 minutes, 30%), Paper 02 (six compulsory structured questions, 150 minutes, 50%), and an SBA project or private-candidate Paper 032 (three questions, 90 minutes, 20%). The official assessment is in English. Our MCQs support study; they do not replace written-response or practical project preparation.

Sample CAPE Information Technology Unit 2 Practice Questions

Try these sample questions to review concepts for the CAPE Information Technology Unit 2 exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 88+ question experience with AI tutoring.

1A regional distribution company receives inventory reports where item quantities are mathematically correct, but the figures reflect stock levels from three months ago. As a result, warehouse supervisors place redundant purchase orders. Which characteristic of information quality is deficient in these reports?
A.Accuracy
B.Timeliness
C.Understandability
D.Security
Explanation: Timeliness requires information to be available to decision-makers when needed and sufficiently current to reflect present reality. Although the three-month-old figures were accurate at the time of recording, their lack of timeliness led to flawed inventory decisions.
2When assessing the value of information within a management information system, an organization determines that information is cost-effective when:
A.The total financial and operational benefit derived from using the information exceeds the cost of collecting, storing, and processing it.
B.The information is collected using free and open-source database management software.
C.The volume of data collected is maximized regardless of the hardware storage expenses incurred.
D.The information can be archived indefinitely on magnetic tape without undergoing backup verification.
Explanation: Cost-effectiveness in information management dictates that the economic and operational value gained from having the information (such as improved productivity or avoided losses) must outweigh the total cost of acquiring, processing, storing, and distributing that information.
3A secondary school maintains student contact details in separate spreadsheet files across the admissions, athletics, and accounts departments. When a student changes their telephone number, only the athletics file is updated, resulting in conflicting records. This scenario illustrates which major limitation of traditional file systems?
A.Data redundancy leading to data inconsistency
B.Physical data independence
C.Strict enforcement of referential integrity
D.Atomicity failure in transaction logs
Explanation: Data redundancy occurs when the same data attributes are duplicated across multiple disconnected files. When an update occurs in one location but not others, it causes data inconsistency, where contradictory values exist simultaneously across different departments.
4In a computerized payroll application, which type of file contains permanent and semi-permanent records such as employee ID, national registration number, job title, and basic salary rate?
A.Transaction file
B.Master file
C.Temporary work file
D.Spool file
Explanation: A master file stores permanent and cumulative semi-permanent data that serves as an authoritative source of truth for an application, such as employee identification and pay rates in a payroll system.
5In batch processing systems, what is the primary role of a transaction file in relation to a master file?
A.It completely replaces the master file at the end of every business quarter.
B.It stores temporary records of daily business events used to update the master file during processing.
C.It maintains an encrypted backup copy of operating system binaries.
D.It stores database schema definitions and indexing metadata for the database engine.
Explanation: In traditional batch processing, a transaction file collects chronological records of business activities (e.g., daily sales or inventory receipts) which are subsequently processed in batches to update balances and records within the master file.
6A commercial utility provider bills 100,000 customers once per month by processing all records in sequence by meter number. Conversely, customer service representatives require immediate retrieval of an individual customer record when handling phone inquiries. Which combination of file organization and access methods is most appropriate for these two operational requirements?
A.Serial access on magnetic tape for customer inquiries and random access for monthly billing runs
B.Indexed sequential file organization, supporting sequential access for batch billing and direct access via an index for individual inquiries
C.Unordered heap file organization with linear search for both billing and customer service inquiries
D.Strict sequential access on write-once optical discs for both operations
Explanation: Indexed sequential file organization arranges records sequentially on disk by primary key while providing index tables. This enables efficient sequential scanning for high-volume monthly batch billing and fast random access for customer service lookups.
7In direct (random) file organization, record keys are converted into physical disk block addresses using a mathematical formula known as a hashing algorithm. What problem arises when two distinct primary keys generate the exact same disk storage address, and what is the term for this event?
A.A collision occurs, requiring an overflow handling technique such as linear probing or chaining.
B.A deadlock occurs, causing the operating system to abort the transaction immediately.
C.A referential integrity breach occurs, resulting in the automatic deletion of the duplicate record.
D.A schema drift occurs, requiring complete database re-normalization to First Normal Form.
Explanation: A collision (or synonym) occurs when a hashing function maps two different key values to the identical bucket or storage location. Systems resolve collisions using overflow strategies such as linear probing, open addressing, or linked chaining.
8In the ANSI-SPARC three-level database architecture, physical data independence is best demonstrated when:
A.The conceptual schema can be modified without altering user views at the external level.
B.The internal physical storage structures or indexing methods can be changed without requiring modifications to the conceptual schema or application programs.
C.The external user interface can be converted from a command-line interface to a web portal without changing database tables.
D.Relational tables can be split into Third Normal Form without modifying existing SQL queries.
Explanation: Physical data independence refers to the capacity to change the internal schema (such as storage allocation, file structures, or secondary indexing) without altering the conceptual schema, external schemas, or application programs.
9What is the primary function of the data dictionary (or system catalog) within a relational Database Management System (DBMS)?
A.To maintain index entries that map application data values to the locations of individual records.
B.To store metadata, including table structures, data types, field constraints, relationships, and user access privileges.
C.To store the current customer, employee, and sales records entered by application users.
D.To execute SQL statements and choose the most efficient query execution plan.
Explanation: The data dictionary (system catalog) is a repository of metadata—data about data. It stores detailed schema definitions, table layouts, column data types, integrity rules, indexes, and security authorizations used by the DBMS engine.
10Which responsibility is primarily assigned to a Database Administrator (DBA) rather than a Data Administrator (DA)?
A.Establishing high-level organizational data policies, business data standards, and strategic information ownership.
B.Performing physical database implementation, performance tuning, storage allocation, and database backup and recovery operations.
C.Defining enterprise-wide data naming conventions and a common business glossary.
D.Assigning business ownership of data and establishing organizational data-retention policies.
Explanation: The Database Administrator (DBA) handles the technical and operational management of the database, including physical implementation, query optimization, security configuration, index tuning, and backup and disaster recovery. The Data Administrator (DA) focuses on business data governance and policy.

About the CAPE Information Technology Unit 2 Exam

CAPE Information Technology Unit 2 covers Information Management, Use of Information Technology Tools, and Social, Organisational and Personal Issues. Candidates study databases, productivity applications, web technologies, security, legal and ethical issues, and health and safety. OpenExamPrep provides independent English-language MCQ practice for these topics and Paper 01. This study adaptation does not simulate the structured-response papers or replace practical database or website development and SBA project work.

Exam sponsor: Caribbean Examinations Council (CXC). The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Assessment

Paper 01: 45 MCQs, 90 minutes, 30%. Paper 02: six compulsory structured questions, 150 minutes, 50%. Paper 031: a practical database or website project with an approximately 600–700-word report, 20%; private candidates instead take Paper 032: three project-based questions, 90 minutes, 20%.

Time Limit

Paper 01: 1 hour 30 minutes; Paper 02: 2 hours 30 minutes; private-candidate Paper 032: 1 hour 30 minutes

Passing Score

Grade V

Exam / Certification Fees

BBD $69.50 subject fee plus BBD $48.50 candidate entry fee (plus local registrar fees)

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

33.3%

Module 1: Information Management

Covers file organization, database architectures, entity-relationship modeling, relational design, normalization (1NF, 2NF, 3NF), SQL commands, data integrity, and security controls.

33.3%

Module 2: Use of Information Technology Tools

Covers selection criteria for IT tools, spreadsheet modeling and advanced functions, document processing, presentation design, web technologies (HTML, CSS), and cloud collaboration.

33.3%

Module 3: Social, Organizational, and Personal Issues

Covers societal implications of IT, cybercrime, information security controls and encryption, intellectual property, Caribbean legal frameworks, ergonomics, and environmental issues.

Preparing for the CAPE Information Technology Unit 2 Exam

What You Need to Know

  • Passing score: Grade V
  • Assessment: Paper 01: 45 MCQs, 90 minutes, 30%. Paper 02: six compulsory structured questions, 150 minutes, 50%. Paper 031: a practical database or website project with an approximately 600–700-word report, 20%; private candidates instead take Paper 032: three project-based questions, 90 minutes, 20%.
  • Time limit: Paper 01: 1 hour 30 minutes; Paper 02: 2 hours 30 minutes; private-candidate Paper 032: 1 hour 30 minutes
  • Exam / certification fees: BBD $69.50 subject fee plus BBD $48.50 candidate entry fee (plus local registrar fees) Official sources

Using Our Practice Resources

  • Work through all 88 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

CAPE Information Technology Unit 2: Suggested Study Strategy

1Practice step-by-step normalization from unnormalized data structures up through Third Normal Form (3NF), identifying partial and transitive dependencies.
2Review SQL syntax thoroughly, particularly SELECT statements involving WHERE filters, GROUP BY, HAVING, and aggregate functions.
3Master advanced spreadsheet functions such as nested IF, VLOOKUP, INDEX/MATCH, and absolute versus relative cell addressing.
4Study the differences between symmetric and asymmetric encryption, public and private keys, and digital signatures.
5Understand ergonomic principles and health issues associated with prolonged computer use, such as repetitive strain injury (RSI) and computer vision syndrome.

Frequently Asked Questions

What is the format and duration of CAPE Information Technology Unit 2 Paper 01?

Paper 01 contains 45 compulsory multiple-choice questions evenly distributed across the three syllabus modules (15 questions each). The time allowed is 1 hour 30 minutes (90 minutes), and the paper accounts for 30% of the overall Unit grade.

What are the three modules covered in CAPE IT Unit 2?

Unit 2 comprises Module 1: Information Management (databases, normalization, SQL), Module 2: Use of Information Technology Tools (productivity software, web design, cloud tools), and Module 3: Social, Organizational, and Personal Issues (security, legal/ethical topics, health and safety).

What grading system does CXC use for CAPE examinations?

CXC reports CAPE results using a seven-point grading scale from Grade I to Grade VII. Grades I to V represent passing grades, where Grade I indicates outstanding achievement. Grades VI and VII represent performance below standard.

Are candidates required to take CAPE IT Unit 1 before Unit 2?

No. Although studying Unit 1 provides helpful background in computer architecture and basic problem-solving, CXC designs each CAPE Unit as a standalone certifiable qualification. Candidates may sit Unit 2 before or concurrently with Unit 1.