Data Processing Computer-Based Test On Data-Processing 2 — Questions and Answers
Question 1: Which data structure stores elements in a last-in, first-out (LIFO) order?
- Queue
- Stack (Correct answer)
- Linked list
- Binary tree
Correct answer: Stack
A stack follows LIFO order, where the most recently added element is removed first.
Question 2: In a relational database, a foreign key is used to:
- Uniquely identify each row in a table
- Enforce a link between two tables (Correct answer)
- Index a column for faster queries
- Encrypt sensitive data fields
Correct answer: Enforce a link between two tables
A foreign key creates a referential link between a column in one table and the primary key of another table.
Question 3: Which of the following best describes 'batch processing'?
- Processing transactions one at a time as they occur
- Collecting data over a period and processing it all at once (Correct answer)
- Processing data in real time using streaming pipelines
- Distributing processing across multiple nodes simultaneously
Correct answer: Collecting data over a period and processing it all at once
Batch processing accumulates data over a set interval and processes it as a group rather than immediately.
Question 4: What does ETL stand for in data processing workflows?
- Extract, Transform, Load (Correct answer)
- Evaluate, Transfer, Log
- Export, Translate, Link
- Encode, Test, Launch
Correct answer: Extract, Transform, Load
ETL is a three-phase pipeline: extracting data from sources, transforming it into a usable format, and loading it into a destination.
Question 5: A checksum is primarily used in data processing to:
- Compress data before transmission
- Detect errors in transmitted or stored data (Correct answer)
- Encrypt data for secure storage
- Index data for faster retrieval
Correct answer: Detect errors in transmitted or stored data
A checksum is a computed value appended to data so the receiver can verify integrity by recomputing it.
Question 6: Which normal form eliminates transitive dependencies in a relational table?
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF) (Correct answer)
- Boyce-Codd Normal Form (BCNF)
Correct answer: Third Normal Form (3NF)
Third Normal Form (3NF) requires that non-key attributes depend only on the primary key, eliminating transitive dependencies.
Question 7: In data processing, 'data deduplication' refers to:
- Encrypting duplicate records for security
- Removing redundant copies of repeated data (Correct answer)
- Sorting data to place duplicates side by side
- Creating backup copies of critical data
Correct answer: Removing redundant copies of repeated data
Data deduplication identifies and eliminates duplicate records to reduce storage usage and improve data quality.
Data Processing Computer-Based Test On Data-Processing 2
Which data structure stores elements in a last-in, first-out (LIFO) order?