Computer Science/IT MCQs
Topic Notes: Computer Science/IT
MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
3561
What does the abbreviation BCC mean when sending an email?
Answer:
Blind Carbon Copy
BCC stands for Blind Carbon Copy. When you add a recipient to the BCC field of an email, they receive a copy of the message, but their email address is hidden from all other recipients in the To, Cc, and BCC fields.
3562
What is junk e-mail also called?
Answer:
spam
Junk e-mail is more commonly known as spam. This term refers to unsolicited and unwanted electronic messages sent in bulk to a large list of recipients, typically for commercial advertising, phishing, or spreading malware.
3563
What facilitates the exchange of messages in an email system?
Answer:
Network
For an email system to function, a network is essential. The network (typically the Internet) provides the communication pathways for email messages to travel from the sender's mail server to the recipient's mail server, enabling the exchange of messages across geographical distances.
3564
Where do you put email addresses of individuals who should receive a copy of a message but remain hidden from other recipients?
Answer:
Recipient's email
To send a copy of an email to someone while keeping their address hidden from other recipients, you use the Bcc (Blind Carbon Copy) field. This is the correct place within the recipient's email section to add their address for private copying.
3565
What term describes unwanted, repeated messages like bulk emails sent without consent?
Answer:
Spam
Spam is the term used for unsolicited digital communication, most commonly email, sent in bulk. These messages are sent without the recipient's consent and are often for commercial purposes, but can also be malicious.
3566
A______________is a collection of data organized in a manner that allows access, retrieval and use of that data.
Answer:
Database
A database is a structured and organized collection of data stored electronically in a computer system. It is designed to be easily accessed, managed, updated, and retrieved, allowing for efficient data handling.
3567
What is represented by a column in a database table?
Answer:
Characteristics
In a relational database table, a column represents a specific attribute or characteristic of the entity the table describes. For example, in a 'Students' table, columns might represent characteristics like 'FirstName', 'LastName', and 'StudentID'.
3568
What types of language does SQL encompass?
Answer:
All of the above
SQL (Structured Query Language) is a comprehensive language for managing relational databases. It includes sublanguages for different tasks: Data Definition Language (DDL) for creating and modifying database structure (e.g., `CREATE TABLE`), Data Manipulation Language (DML) for adding, updating, and querying data (e.g., `SELECT`, `INSERT`), and Data Control Language (DCL) for managing permissions (e.g., `GRANT`).
3569
What term describes the state of data in a database at a specific moment?
Answer:
Extension
In database terminology, the 'extension' (or database state) refers to the actual data contained in the database at a particular point in time. This is the set of all tuples (rows) in all relations (tables). The 'intension', by contrast, refers to the database schema or structure.
3570
Under which circumstances is a 'batch processing' approach generally the most suitable method for data handling?
Answer:
When a significant volume of data transactions can be accumulated and processed together periodically.
Batch processing is a computing paradigm designed for efficiency when dealing with large volumes of data. It involves collecting and processing transactions or data records in groups (batches) at scheduled intervals rather than individually as they occur. This method reduces overhead associated with starting and stopping processes for each transaction, making it highly efficient for tasks like payroll processing, end-of-day banking reconciliations, or large-scale report generation, where immediate feedback is not critical. Option (a) describes real-time processing. Option (c) doesn't fully capture the essence as batch processing often runs on powerful systems, though it can be resource-efficient in its scheduling. Option (d) is incorrect because while data integrity is always important, batch processing inherently introduces delays compared to real-time systems.