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
6191
A "Conditional Block" (If/Else/End If) in a macro allows you to:
Answer:
Run different actions based on whether a certain condition is true or false
This adds logic to your macros. For example, `IF [TotalAmount] > 1000 THEN` you could run an action to require manager approval.
6192
Before you can encrypt a database with a password, you must:
Answer:
Open it in "Exclusive" mode
To perform certain administrative tasks like setting a password, you must be the only user with the database file open. Opening it in exclusive mode ensures this.
6193
What is the `SetTempVar` macro action used for?
Answer:
To create a temporary variable that can store a value to be used later in the macro or by other objects
Temporary variables are useful for passing values between different parts of your application, for example, storing a `CustomerID` from one form to be used to filter a report that the macro then opens.
6194
A macro can be triggered by a "key press" event on a form.
Answer:
True
Form and control events are very granular. You can trigger macros based on events like `On Key Down`, `On Key Press`, and `On Key Up` to capture keyboard input.
6195
Why might a company choose to disable all macros by default across their organization via group policy?
Answer:
As a security measure to prevent users from accidentally running malicious code from an untrusted email attachment
Because macros can be used to deliver malware (macro viruses), many organizations enforce a strict security policy that disables them, only allowing them to run from centrally managed trusted locations.
6196
The "Single Step" mode for debugging a macro allows you to:
Answer:
Run the macro one action at a time, pausing after each step
Single-stepping is a crucial debugging tool. It lets you walk through your macro's logic step-by-step to identify exactly where an error is occurring.
6197
To run a macro that opens a report and then closes the database, you would need how many actions in the Macro Builder?
Answer:
Two
You would create a macro with two sequential actions: the first would be `OpenReport` (with the report name as an argument), and the second would be `QuitAccess`.
6198
What is the role of an "argument" for a macro action?
Answer:
It provides the specific information needed for an action to run, such as which form to open or which query to run
When you select an action like `OpenForm`, you must provide arguments like the "Form Name" to tell Access exactly which form you want it to open.
6199
If you forget the password you used to encrypt an Access database:
Answer:
The data is generally considered unrecoverable
The encryption used by Access is strong. There is no "backdoor" or master key. Forgetting the password means losing access to the data permanently.
6200
A "data macro" is a type of macro that is attached to:
Answer:
A table event (e.g., Before Change, After Insert)
Data macros are triggered by data events directly at the table level. This allows you to enforce business logic regardless of how the data is being changed (whether through a form, a query, or directly in the datasheet).