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
What is the purpose of "signing" a database with a digital certificate?
Answer:
To prove to users that the database is from a trustworthy source and has not been tampered with
When a user opens a digitally signed database, they can choose to trust all publications from that publisher. This allows the active content to run without showing the security warning each time.
2
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.
3
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.
4
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.
5
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.
6
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.
7
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.
8
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.
9
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.
10
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.