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
6311
Which data type would be most appropriate for storing a person's date of birth?
Answer:
Date/Time
The Date/Time data type is specifically designed to store dates and times, and it allows you to perform date-based calculations and formatting.
6312
The tabs that appear at the top of the main workspace, allowing you to switch between open objects, are called:
Answer:
Object Tabs
When you have multiple tables, forms, or other objects open at the same time, Access displays them as a series of tabs, making it easy to navigate between them.
6313
What is the purpose of a Macro object in Access?
Answer:
To automate a sequence of actions or commands without needing to write code
Macros provide a simplified way to add functionality to your database, such as opening a form, running a report, or validating data when a button is clicked.
6314
A "calculated field" in a query is a field that:
Answer:
Derives its value from a calculation performed on other fields in the query
You can create new fields directly in a query. For example, you could create a "TotalPrice" field by writing the expression `[Quantity] * [UnitPrice]`. This calculated value exists only when the query is run.
6315
Which view for Forms and Reports allows you to see the live data while still being able to make design changes like resizing fields?
Answer:
Layout View
Layout View is a hybrid view that strikes a balance between Design View (no data) and Form/Report View (can't make changes). It's ideal for making visual adjustments because you can see the effect on your actual data immediately.
6316
In a report, the "Group & Sort" feature is used to:
Answer:
Organize records into sections based on a field's value (e.g., group all sales by country)
Grouping is a key feature of reports. It allows you to create subtotals and other summary calculations for each group of records.
6317
When you open an Access database, the first object that can be set to open automatically is called a:
Answer:
Start-Up Form
In the Access Options, you can specify a "Display Form" that will open automatically every time the database is launched, providing a main menu or starting point for the user.
6318
The "Filter by Form" feature allows you to:
Answer:
Filter records by entering criteria into a blank version of the current form or datasheet
This is a user-friendly way to filter data. It provides an empty view where you can type criteria into one or more fields to find matching records.
6319
What is the function of a "lookup field" in a table?
Answer:
To provide a dropdown list of values for easier and more consistent data entry
A lookup field simplifies data entry by letting the user pick a value from a predefined list or from another table, which helps to prevent spelling mistakes and ensures data consistency.
6320
Which of the following is NOT one of the four main types of database objects in Access?
Answer:
Spreadsheets
While Access can import data from spreadsheets (like Excel), a spreadsheet itself is not a native Access object. Modules (for VBA code) and Macros are the other object types in addition to the main four.