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
121
A "Module" in Access is an object that contains:
Answer:
Custom programming code written in Visual Basic for Applications (VBA)
Modules are for advanced automation. When the capabilities of macros are not sufficient, developers write VBA code in modules to create complex custom functions and procedures. ### Relationships and Keys (Primary, Foreign)
122
When you first open an Access table, you are in _________ View.
Answer:
Datasheet
The default view for a table is Datasheet View, as this is the view used for viewing and interacting with the data itself.
123
In a report's Design View, controls in the "Report Header" section will appear:
Answer:
Only at the very beginning of the entire report
The Report Header is for titles, logos, or information that should only be printed once at the start of the report. The Page Header is for information that repeats on every page.
124
The "AutoNumber" data type is useful for:
Answer:
Automatically generating a unique number for each new record, often used as a primary key
AutoNumber ensures that every record has a unique identifier without requiring the user to manually enter one. Access handles the incrementing automatically.
125
To combine data from two separate tables that have a common field, you would use a:
Answer:
Query
Queries are the tool used to join related tables. By linking the tables on their common field (e.g., CustomerID), you can pull fields from both tables into a single result set.
126
The object that is considered the "engine" that retrieves and processes data behind the scenes for forms and reports is the:
Answer:
Query
While you can base a form or report directly on a table, it is best practice to base them on queries. This allows you to pre-filter, sort, and calculate the data before it even reaches the form or report, making them more efficient and powerful.
127
A "Control" in the context of an Access form or report is:
Answer:
An object on the form/report, such as a text box, label, or button, that displays data or performs an action
Controls are the individual elements you place on a form or report to build its interface and functionality.
128
Which data type would be most appropriate for storing a person's date of birth?
Answer:
Date/Time
The Date/Time data type is specifically designed to store dates and times, and it allows you to perform date-based calculations and formatting.
129
The tabs that appear at the top of the main workspace, allowing you to switch between open objects, are called:
Answer:
Object Tabs
When you have multiple tables, forms, or other objects open at the same time, Access displays them as a series of tabs, making it easy to navigate between them.
130
What is the purpose of a Macro object in Access?
Answer:
To automate a sequence of actions or commands without needing to write code
Macros provide a simplified way to add functionality to your database, such as opening a form, running a report, or validating data when a button is clicked.