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
6231
What is a "delimited" text file?
Answer:
A text file where the columns are separated by a specific character, such as a comma or a tab
Delimited files are a common way to structure data. The "delimiter" is the character that signals the end of one field and the beginning of the next.
6232
The "Get & Transform Data" features (also known as Power Query) in modern Access and Excel are used for:
Answer:
Advanced data cleaning, shaping, and transformation before the final import
Power Query is a powerful tool that allows you to perform complex data manipulation steps, such as splitting columns, unpivoting data, or merging files, as part of the import process.
6233
To start the process of bringing data from an Excel spreadsheet into a new Access table, you would go to:
Answer:
External Data > New Data Source > From File > Excel
All import operations are initiated from the "New Data Source" group on the External Data tab of the Ribbon.
6234
Which of the following is NOT a common source for importing data into Access?
Answer:
A Photoshop (.psd) File
Access is designed to work with structured, tabular data. While it can store image files in attachments, it cannot import data directly from a proprietary image editing format like PSD.
6235
When linking to a table in another Access database, what does Access create in your current database?
Answer:
A shortcut, or pointer, to the original table
Linking creates a table object in your Navigation Pane that looks and acts like a normal table, but the data itself remains stored in the original source database. This is fundamental to splitting a database.
6236
What is the purpose of saving import or export steps?
Answer:
To allow you to quickly re-run the same import or export operation in the future without going through the wizard again
If you have a task you perform regularly, like importing a new sales report every week, saving the steps allows you to turn it into a one-click operation.
6237
If you want to send a formatted, non-editable version of an Access report to a colleague who does not have Access, which is the best export format?
Answer:
PDF (.pdf)
Exporting a report to PDF creates a document that preserves all the formatting, layout, and graphics of the report. It can be opened by anyone with a free PDF reader and cannot be easily edited.
6238
When importing data from an Excel file, the Import Wizard allows you to:
Answer:
All of the above
The Import Wizard guides you step-by-step through the process, giving you options to ensure the data is brought into Access correctly, including interpreting column headers and setting a primary key.
6239
Which file format is commonly used for importing and exporting tabular data and is easily opened by spreadsheet programs?
Answer:
.csv (Comma Separated Values)
A CSV file is a plain text file that uses commas to separate the values in each column, making it a universal and simple format for exchanging data between different applications.
6240
Which tab on the Ribbon contains all the commands for importing and exporting data?
Answer:
External Data
The External Data tab is the central location for all tools related to moving data into and out of your Access database.