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
41
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.
42
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).
43
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.
44
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.
45
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.
46
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.
47
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).
48
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.
49
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.
50
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.