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
141
To create a new table, query, form, or report, you would primarily use the commands on which tab of the Ribbon?
Answer:
Create
The Create tab is the central hub for generating new database objects. It contains wizards and design tools for all four major object types.
142
The Ribbon in Access is the:
Answer:
Toolbar at the top of the window containing tabs like "Home," "Create," and "External Data"
The Ribbon is the main command interface in Access, providing access to all the tools and features needed to create and manage your database.
143
Which view displays the data in a table in a row-and-column format similar to a spreadsheet?
Answer:
Datasheet View
Datasheet View is the primary view for looking at the actual data within a table or query. It allows for direct entry and editing of data in a grid format.
144
Which view is used to define the structure of a table, including field names, data types, and properties?
Answer:
Design View
Design View is the "behind-the-scenes" view where you build the blueprint of your object. For tables, this is where you set up the columns (fields) and their characteristics.
145
In Access, a row in a table represents a __________, and a column represents a __________.
Answer:
Record, Field
Each row is a unique record (e.g., a specific customer or product). Each column is a field, which is a specific piece of information about that record (e.g., Last Name or Price).
146
The main panel on the left side of the Access window that lists all your database objects is called the:
Answer:
Navigation Pane
The Navigation Pane is your primary tool for opening, organizing, and managing all the objects (tables, queries, forms, reports) within your database.
147
Which object is best suited for formatting and presenting your data in a professional, printable layout?
Answer:
Report
Reports are designed for summarizing and presenting data for printing or viewing online. They offer advanced formatting options, grouping, and calculations that are not available in other objects.
148
If you want to ask a question of your database to retrieve specific data, which object would you use?
Answer:
Query
A query is essentially a stored question. It allows you to pull information from one or more tables based on a set of criteria you define, letting you filter, sort, and calculate data.
149
Which Access object is designed to provide a user-friendly interface for entering, viewing, and editing data one record at a time?
Answer:
Form
Forms are used to create an easy-to-use screen for interacting with the data in your tables. They can be customized with buttons, text boxes, and other controls to simplify data entry.
150
In Microsoft Access, what is the primary object used for storing data?
Answer:
Table
Tables are the fundamental building blocks of a database. They store all the data in a structured format of rows (records) and columns (fields).