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
6211
What is a "Trusted Location" in Access security settings?
Answer:
A folder on your computer or network that you have designated as safe, allowing databases in it to run without security warnings
By setting up trusted locations, you can bypass the security warnings for databases you have created yourself or that you know are from a reliable source.
6212
When you open an Access database from an untrusted location, a yellow ____________ often appears below the Ribbon.
Answer:
Message Bar with a security warning
The Message Bar is a security feature that warns you that potentially unsafe active content (like macros or certain queries) has been disabled. You must explicitly click "Enable Content" to allow it to run.
6213
What is a Macro in Microsoft Access?
Answer:
A tool for automating tasks and adding functionality to your database without writing programming code
A macro is a saved sequence of actions that Access can execute. It allows you to automate common or repetitive tasks, like opening a form or running a query when a button is clicked.
6214
The process of linking the tables of a database to a separate "front-end" file is known as:
Answer:
Splitting the database
Splitting a database involves creating a back-end file (containing only the tables) and a front-end file (containing everything else, with links to the back-end tables). This is a best practice for security and multi-user environments. ### Access Macros and Security
6215
Can you import data directly from a web page (HTML file)?
Answer:
Yes, but only if the data is in a properly formatted table on the web page
Access has an import wizard for HTML files, but it is designed to recognize and import data that is structured within HTML `<table>` tags.
6216
The "XML File" import/export option is used for:
Answer:
Exchanging data in a structured, text-based format that is both human-readable and machine-readable
XML (eXtensible Markup Language) is a standard for encoding data. Access can both import XML data and export data along with its schema (structure) into an XML format.
6217
If you export a query to Excel, what gets exported?
Answer:
The data records that are returned when the query is run
The export process first runs the query and then saves the resulting datasheet of records into a new Excel spreadsheet.
6218
Before importing a large text file, it is good practice to:
Answer:
Open the text file to check for inconsistencies, such as missing delimiters or incorrect data
Cleaning the source data before you begin the import process can save you from dealing with numerous import errors and data integrity problems inside Access.
6219
To ensure that an exported report maintains its exact visual layout, fonts, and colors, the best format is:
Answer:
PDF or XPS
PDF and XPS are "page layout" formats designed specifically to preserve the look and feel of a document, making them ideal for distributing finished reports.
6220
The "Saved Exports" button on the External Data tab allows you to:
Answer:
Manage and re-run export operations that you have saved
Similar to saved imports, this feature provides a one-click method for repeating a routine export task.