Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
91
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.
92
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).
93
What does "compiling" an Access database into an ACCDE file do?
Answer:
It compiles all VBA code, removes the source code, and prevents changes to the design of forms, reports, and modules
Creating an ACCDE file is a way to distribute an Access application to users. It protects your design and code from being viewed or modified, effectively locking the application down.
94
The `MsgBox` macro action is used to:
Answer:
Display a pop-up message box with information or a warning for the user
The `MsgBox` action is a simple way to provide feedback to the user, for example, to confirm that a record has been saved or to display a validation error.
95
What is the main security benefit of a split database design?
Answer:
Both A and B
Users interact with the data only through the forms and queries you provide in the front-end, which gives the developer more control. It also makes deploying updates much simpler.
96
By default, Access is typically configured to ___________ macros in databases from untrusted sources.
Answer:
Disable all with notification
This is the default security posture. Access blocks potentially dangerous content but informs the user via the Message Bar, giving them the choice to enable it if they trust the source.
97
An "embedded macro" is a macro that is:
Answer:
Stored as part of an object's event property, rather than as a separate object in the Navigation Pane
Embedding a macro directly into a button's "On Click" property is convenient because the macro logic travels with the form if you copy it to another database. Standalone macros are separate, reusable objects.
98
Where would you go to manage security settings like Trusted Locations and Macro Settings?
Answer:
The Access Options > Trust Center
The Trust Center is the central hub for all security and privacy settings in all Microsoft Office applications, including Access.
99
Splitting a database into a "front-end" and a "back-end" is a common strategy to:
Answer:
Improve performance and security in a multi-user environment
Each user gets a copy of the front-end (with forms, queries, etc.) on their computer, while the back-end (with the shared data tables) resides on a network server. This reduces network traffic and makes it easier to distribute updates.
100
Which of the following is an example of an "Action" you can choose in the Macro Builder?
Answer:
All of the above
The Macro Builder provides a dropdown list of dozens of predefined actions that allow you to manipulate almost every aspect of the database, from opening and closing objects to running queries and displaying messages.