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
6301
The most common type of relationship between two tables in a relational database is:
Answer:
One-to-Many
This relationship is very common. For example, one customer (the "one" side) can have many orders (the "many" side).
6302
What is a "Foreign Key"?
Answer:
A primary key from one table that is placed into a second table to form a relationship
A foreign key is the "link" between two tables. For example, the `CustomerID` (primary key in the Customers table) would be placed in the Orders table as a foreign key to link each order to a specific customer.
6303
What is a "Primary Key" in a database table?
Answer:
A field, or combination of fields, that uniquely identifies each record in the table
The primary key is crucial for ensuring that you can uniquely identify every single row. It cannot contain duplicate values and cannot be null (empty).
6304
A "Module" in Access is an object that contains:
Answer:
Custom programming code written in Visual Basic for Applications (VBA)
Modules are for advanced automation. When the capabilities of macros are not sufficient, developers write VBA code in modules to create complex custom functions and procedures. ### Relationships and Keys (Primary, Foreign)
6305
When you first open an Access table, you are in _________ View.
Answer:
Datasheet
The default view for a table is Datasheet View, as this is the view used for viewing and interacting with the data itself.
6306
In a report's Design View, controls in the "Report Header" section will appear:
Answer:
Only at the very beginning of the entire report
The Report Header is for titles, logos, or information that should only be printed once at the start of the report. The Page Header is for information that repeats on every page.
6307
The "AutoNumber" data type is useful for:
Answer:
Automatically generating a unique number for each new record, often used as a primary key
AutoNumber ensures that every record has a unique identifier without requiring the user to manually enter one. Access handles the incrementing automatically.
6308
To combine data from two separate tables that have a common field, you would use a:
Answer:
Query
Queries are the tool used to join related tables. By linking the tables on their common field (e.g., CustomerID), you can pull fields from both tables into a single result set.
6309
The object that is considered the "engine" that retrieves and processes data behind the scenes for forms and reports is the:
Answer:
Query
While you can base a form or report directly on a table, it is best practice to base them on queries. This allows you to pre-filter, sort, and calculate the data before it even reaches the form or report, making them more efficient and powerful.
6310
A "Control" in the context of an Access form or report is:
Answer:
An object on the form/report, such as a text box, label, or button, that displays data or performs an action
Controls are the individual elements you place on a form or report to build its interface and functionality.