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
6321
The "Property Sheet" is a pane that allows you to:
Answer:
View and modify the detailed settings and characteristics of an object or a control
Every object, and every element on a form or report (like a text box), has a set of properties (e.g., size, color, data source) that can be customized in the Property Sheet.
6322
A "Subform" or "Subreport" is an object that is:
Answer:
A form or report that is inserted into another "main" form or report to show related data
Subforms are powerful tools for displaying one-to-many relationships. For example, a main form could show customer information, while a subform shows all the orders placed by that specific customer.
6323
What is the purpose of setting a "Data Type" for a field in a table?
Answer:
To determine what kind of data can be stored in the field (e.g., text, number, date)
Setting a data type is crucial for data integrity. It ensures that users can only enter valid data (e.g., you can't enter a name into a field set to the "Date/Time" data type).
6324
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.
6325
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.
6326
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.
6327
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.
6328
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).
6329
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.
6330
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.