Free Data Processing MCQ Question and Answers

Question 1

When a virus is present on a computer,

Accepted Answer

The hard drive is filling up

Answer

Computer viruses often replicate themselves, creating numerous copies or generating large log files, which can rapidly consume disk space. This activity leads to the hard drive filling up, causing the computer to slow down, exhibit errors, or even crash. While viruses have various effects, consuming disk space is a common symptom of their presence and malicious activity.

Question 2

Viruses can be acquired through

Accepted Answer

Cracked software

Answer

Cracked software, which is pirated or illegally modified software, is a common vector for computer viruses and malware. These programs often contain hidden malicious code inserted by the crackers, allowing them to bypass security measures and infect the user's system. Downloading and installing such software poses a significant security risk.

Question 3

Among the benefits of database security is

Accepted Answer

Ensure the data confidentiality

Answer

Database security aims to protect sensitive information from unauthorized access and disclosure. Ensuring data confidentiality means that only authorized individuals or systems can view or access specific data, preventing breaches and maintaining privacy. This is a primary benefit, alongside ensuring data integrity and availability.

Question 4

Three commonly accepted classifications of confidentiality-related issues in database systems include all but

Accepted Answer

Accepting and initiating unwanted popups.

Answer

Confidentiality-related issues in database systems primarily concern unauthorized access or disclosure of sensitive data, such as improper information release, inference, and aggregation. Accepting and initiating unwanted popups, while a security nuisance or a sign of malware, is generally classified as an issue related to browser security or adware, not a core confidentiality issue within database systems themselves.

Question 5

One explanation for why people disregard index is because

Accepted Answer

They may make your queries slower instead of faster

Answer

While indexes are generally designed to speed up data retrieval, they can sometimes slow down data modification operations (INSERT, UPDATE, DELETE) because the index itself must also be updated. Furthermore, poorly designed or excessive indexes can sometimes lead to the query optimizer choosing inefficient execution plans, paradoxically making certain queries slower. This potential for performance degradation during writes or with improper use is a reason why indexes might be disregarded or carefully managed.

Data Processing Practice Test

Data Processing Practice Test

Free Data Processing MCQ Question and Answers