IT THEORY IEB REAL EXAM 2025 COMPLETE 250 QUESTIONS
WITH CORRECT AND DETAILED ANSWERS (VERIFIED 100%)
|ALREADY GRADED A+!!!!.
IT THEORY IEB
Database Management System (DBMS) - - ANS - -Software that manages and
controls a database. This
includes permissions, backup, referential integrity and access control.
Accuracy - - ANS - -Accuracy is the degree to which the stored value measures
against the true value. For example, the number of decimal
places for numeric data.
Correctness - - ANS - -Data is correct if it conforms to an approved or conventional
standard or agreeing with fact, logic, or known truth.
Currency - - ANS - -Data is current if it is up-to-date or not outdated.
Completeness - - ANS - -Data is complete if all required data is known
SQL Injection - - ANS - -A web security vulnerability that allows an attacker to
interfere with the queries that an application makes to
its database. For example, view data that should not
,be accessible.
Non-relational databases /
NoSQL - - ANS - -NoSQL databases are unstructured, flexible and store data
without having a predefined schema.
Data Warehouse - - ANS - -A data warehouse combines data from a variety of
sources
within an organisation for purposes of producing reports
and analysis. These reports are created from complex
queries within the data warehouse to make business
decisions.
Big Data - - ANS - -Big data is a massive volume of both structured and
unstructured data that is so large that it is difficult to process
using traditional database and software techniques.
Data Mining - - ANS - -Data mining is a set of techniques for discovering hidden,
valid and potentially useful patterns or trends in a data set.
Schema - - ANS - -The logical design of the database which includes the
design of the tables and fields.
Field - - ANS - -Stores a single data item such as ID number or surname.
,Record - - ANS - -A collection of fields.
Table - - ANS - -A collection of records.
Verification - - ANS - -Data verification ensures the user enters what they
intended, to eliminate mistakes when data is inputted.
For example, double entry of data (such as when
creating a password or email) to prevent incorrect data
input.
Validation - - ANS - -Validation is about checking the input data to ensure it
conforms with the data requirements of the system to
avoid data errors. For example, range check, format
check, check digit etc.
Presence Check - - ANS - -Test to determine if the data for a field must be
entered.
Range Check - - ANS - -Test to determine if the data falls between a lower and
upper bound.
Uniqueness Check - - ANS - -Test to determine if the data value is not duplicated.
, Length Check - - ANS - -Test to determine if the data has a set number of
characters.
Type Check - - ANS - -Test to determine if the data is of the correct type,
such as a String or real number.
Format Check - - ANS - -Test to determine if the data is structured in
predetermined format.
Logical Check - - ANS - -Test to determine if the data is consistent for the
scenario. For example, a student in a high school
cannot be 30 years of age.
Check Digit - - ANS - -Test to determine if a digit in a number, satisfies a
certain algorithm, usually based on existing digits in
the number.
Check Sum - - ANS - -Test to verify data transfer by performing a calculation
(such as a sum) on the bits transferred.
Parity - - ANS - -Test to verify data transfer by inserting a 9th bit after 8
bits to create an odd or even number of bits.
WITH CORRECT AND DETAILED ANSWERS (VERIFIED 100%)
|ALREADY GRADED A+!!!!.
IT THEORY IEB
Database Management System (DBMS) - - ANS - -Software that manages and
controls a database. This
includes permissions, backup, referential integrity and access control.
Accuracy - - ANS - -Accuracy is the degree to which the stored value measures
against the true value. For example, the number of decimal
places for numeric data.
Correctness - - ANS - -Data is correct if it conforms to an approved or conventional
standard or agreeing with fact, logic, or known truth.
Currency - - ANS - -Data is current if it is up-to-date or not outdated.
Completeness - - ANS - -Data is complete if all required data is known
SQL Injection - - ANS - -A web security vulnerability that allows an attacker to
interfere with the queries that an application makes to
its database. For example, view data that should not
,be accessible.
Non-relational databases /
NoSQL - - ANS - -NoSQL databases are unstructured, flexible and store data
without having a predefined schema.
Data Warehouse - - ANS - -A data warehouse combines data from a variety of
sources
within an organisation for purposes of producing reports
and analysis. These reports are created from complex
queries within the data warehouse to make business
decisions.
Big Data - - ANS - -Big data is a massive volume of both structured and
unstructured data that is so large that it is difficult to process
using traditional database and software techniques.
Data Mining - - ANS - -Data mining is a set of techniques for discovering hidden,
valid and potentially useful patterns or trends in a data set.
Schema - - ANS - -The logical design of the database which includes the
design of the tables and fields.
Field - - ANS - -Stores a single data item such as ID number or surname.
,Record - - ANS - -A collection of fields.
Table - - ANS - -A collection of records.
Verification - - ANS - -Data verification ensures the user enters what they
intended, to eliminate mistakes when data is inputted.
For example, double entry of data (such as when
creating a password or email) to prevent incorrect data
input.
Validation - - ANS - -Validation is about checking the input data to ensure it
conforms with the data requirements of the system to
avoid data errors. For example, range check, format
check, check digit etc.
Presence Check - - ANS - -Test to determine if the data for a field must be
entered.
Range Check - - ANS - -Test to determine if the data falls between a lower and
upper bound.
Uniqueness Check - - ANS - -Test to determine if the data value is not duplicated.
, Length Check - - ANS - -Test to determine if the data has a set number of
characters.
Type Check - - ANS - -Test to determine if the data is of the correct type,
such as a String or real number.
Format Check - - ANS - -Test to determine if the data is structured in
predetermined format.
Logical Check - - ANS - -Test to determine if the data is consistent for the
scenario. For example, a student in a high school
cannot be 30 years of age.
Check Digit - - ANS - -Test to determine if a digit in a number, satisfies a
certain algorithm, usually based on existing digits in
the number.
Check Sum - - ANS - -Test to verify data transfer by performing a calculation
(such as a sum) on the bits transferred.
Parity - - ANS - -Test to verify data transfer by inserting a 9th bit after 8
bits to create an odd or even number of bits.
