Data Processing questions to test candidates’ acquisition of basic skills of data processing and knowledge in the application of ICT in facilitating business transactions and education.
In distributed database management system, breaking a relation into smaller relations is known as
Replication
Fragmentation
Indexing
Normalization
Correct answer is B
No explanation has been provided for this answer.
Ensuring the correctness and consistency of data is referred to as data
Security
Reliability
Productivity
Integrity
Correct answer is D
No explanation has been provided for this answer.
Which of the following file organization requires a primary key?
Indexed file organization
Random file organization
Serial file organization
Sequential file organization
Correct answer is A
No explanation has been provided for this answer.
One unique feature of index file is that it contains
Reference number
Relative number
Sequential number
Static number
Correct answer is A
No explanation has been provided for this answer.
The arrangement that gives the correct order of magnitude of the database elements is
Character, field, record, table, database, file
Character, field, record, table, file, database
Database, table, file, record, field, character
Database, record, file, field, table, character
Correct answer is B
No explanation has been provided for this answer.