EDPT (Electronic Data Processing Test) 2 — Questions and Answers
Question 1: In a relational database, what term describes the column(s) in one table that reference the primary key of another table?
- Candidate key
- Foreign key (Correct answer)
- Composite key
- Alternate key
Correct answer: Foreign key
A foreign key is a column or set of columns in one table that references the primary key in another table, enforcing referential integrity.
Question 2: Which number system uses only the digits 0 and 1?
- Octal
- Hexadecimal
- Binary (Correct answer)
- Decimal
Correct answer: Binary
The binary number system (base-2) uses only two digits: 0 and 1, and is fundamental to digital computer operations.
Question 3: What does RAM stand for in computer terminology?
- Read-Access Memory
- Random Access Memory (Correct answer)
- Rapid Application Memory
- Read-Anytime Module
Correct answer: Random Access Memory
RAM stands for Random Access Memory, the volatile short-term memory a computer uses to store data currently being processed.
Question 4: A file contains 4,096 bytes. How many kilobytes is this?
- 4 KB (Correct answer)
- 8 KB
- 2 KB
- 16 KB
Correct answer: 4 KB
1 kilobyte = 1,024 bytes, so 4,096 ÷ 1,024 = 4 KB.
Question 5: Which type of software coordinates hardware resources and provides services to application programs?
- Utility software
- Operating system (Correct answer)
- Middleware
- Firmware
Correct answer: Operating system
An operating system manages hardware resources and provides a platform on which application programs can run.
Question 6: In a spreadsheet, which function returns the largest value in a range of cells?
- HIGH()
- LARGE()
- MAX() (Correct answer)
- TOP()
Correct answer: MAX()
The MAX() function in spreadsheet applications returns the highest numeric value from a specified range of cells.
Question 7: What is the process of finding and fixing errors in a computer program called?
- Compiling
- Debugging (Correct answer)
- Interpreting
- Patching
Correct answer: Debugging
Debugging is the systematic process of identifying, isolating, and correcting errors (bugs) in software code.
EDPT (Electronic Data Processing Test) 2
In a relational database, what term describes the column(s) in one table that reference the primary key of another table?