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
1
To protect the intellectual property contained in your forms and reports, you should distribute your application as a(n) ________ file.
Answer:
ACCDE
The ACCDE "execute only" format prevents users from entering Design View for forms, reports, and modules, thereby protecting your design and source code.
2
The `RunCode` action in a macro is used to:
Answer:
Execute a custom function written in VBA
This action provides a bridge between the simplified macro system and the more powerful VBA programming language, allowing you to call custom code from within a macro.
3
User-Level Security, a feature of older Access MDB files, allowed an administrator to:
Answer:
Assign detailed permissions (e.g., read, edit, delete) to specific users and groups for individual objects
This complex security model was removed from the newer ACCDB format. Security for modern Access databases is typically handled by file system permissions or by using a more robust back-end like SQL Server.
4
An "AutoExec" macro is a special macro that:
Answer:
Automatically executes when the database is first opened
If you create a macro and name it "AutoExec", Access will automatically run it every time the database starts, making it a useful tool for initialization tasks.
5
Disabling macros in the Trust Center will:
Answer:
Prevent any macros from running in any database you open, unless it is in a trusted location
The Trust Center settings provide a global level of control over how Access handles active content.
6
The back-end of a split database contains only the:
Answer:
Tables
The back-end file (`_be.accdb`) is purely a data container. It holds the tables and the relationships between them. All the application logic and user interface are in the front-end.
7
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.
8
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.
9
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.
10
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.