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
6221
When would linking to a data source be a better choice than importing?
Answer:
When the data source is constantly being updated by other people and you need to see the most current data
Linking is the best option for live or shared data. Importing is better for data that does not change, or when you need to perform significant restructuring that you don't want to affect the original source.
6222
Can you export the results of a query to a new table in another Access database?
Answer:
Yes, using the "Export > Access" option and specifying the destination database
Access provides tools to export objects, including tables created from queries, directly into another .accdb file.
6223
What is a potential problem with importing data from an Excel file where a column contains mixed data types (e.g., numbers and text)?
Answer:
Access might guess the wrong data type for the field, causing some data to be imported incorrectly or not at all
Access scans the first several rows to determine a field's data type. If it sees only numbers, it may set the data type to "Number," and any text values further down in that column could be lost or cause errors during the import.
6224
To import data from a SharePoint list, you would find the option under:
Answer:
External Data > New Data Source > From Online Services
SharePoint is considered an online service, and Access has a dedicated connector for importing or linking to SharePoint lists.
6225
A "fixed-width" text file is one where:
Answer:
Each field occupies a specific, fixed number of character spaces in each row
In a fixed-width file, there are no delimiters. The import wizard determines where one field ends and the next begins based on character position (e.g., characters 1-10 are the first name, 11-25 are the last name).
6226
You can export an Access object directly to an email message as:
Answer:
A file attachment in various formats (e.g., PDF, Excel)
The "Email" command in the Export group allows you to quickly export an object and attach the resulting file to a new Outlook email message in one step.
6227
What is a key consideration when importing data into an existing table?
Answer:
The data types of the source fields must be compatible with the data types of the destination fields
The append operation will fail if you try to put text data into a number field, or a non-date value into a date field. The columns must align in a compatible way.
6228
Which export option would you use to create a document for a mail merge in Microsoft Word?
Answer:
Rich Text Format (.rtf) or Word (.docx)
Access has a specific "Word Merge" feature that guides you through exporting query data and launching Microsoft Word to perform a mail merge for letters or labels.
6229
The "Append a copy of the records to the table" option in the import wizard is used when you want to:
Answer:
Add the imported data as new records to an existing table
This option is used when you have a table already set up and you want to add more records to it from an external file, assuming the columns match.
6230
When you link to a data source, can you change the table's structure (e.g., add or delete fields) from within Access?
Answer:
No, the structure of a linked table can only be changed in the original source application
Since a linked table is just a pointer, its fundamental design (field names, data types) is controlled by the source file (e.g., the Excel spreadsheet or the source Access database).