Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
151
The SQL clause `ORDER BY` is used to:
Answer:
Sort the records
`ORDER BY` is the SQL equivalent of the "Sort" row in the design grid. For example, `ORDER BY LastName ASC` would sort the results by last name in ascending order.
152
To see the SQL code that Access generates for your query, you would switch to:
Answer:
SQL View
Access provides an SQL View that shows the text-based SQL statement equivalent to the query you built in the graphical Design View.
153
What is the purpose of an "Append Query"?
Answer:
To add a group of records from one or more tables to the end of another table
An Append Query is used to copy records in bulk. For example, you could use one to move records from a "NewLeads" table into your main "Customers" table.
154
The `*` (asterisk) wildcard in an Access query criterion represents:
Answer:
Any number of unknown characters
The asterisk is used for matching patterns. For example, the criterion `Like "S*"` in a name field would find all names that start with the letter S.
155
To sort the results of a query in ascending order by last name, you would set the "Sort" row for the LastName field to:
Answer:
Ascending
In the design grid, the "Sort" row allows you to specify Ascending (A-Z, 1-100) or Descending (Z-A, 100-1) order for one or more fields.
156
What does a "Crosstab Query" do?
Answer:
It summarizes data in a spreadsheet-like format, with row headings, column headings, and a calculated value
Crosstab queries are excellent for analysis. For example, you could use one to show total sales (the value) for each product (the row heading) across different years (the column headings).
157
A "Parameter Query" is a query that:
Answer:
Prompts the user for input (a criterion) every time it is run
This makes a query flexible. Instead of hard-coding a specific city, you can create a parameter query that pops up a box asking "Enter City:" each time it runs.
158
Which SQL clause specifies which tables to retrieve data from?
Answer:
FROM
The `FROM` clause lists the table or tables that contain the data you want to query (e.g., `FROM Customers`).
159
Which SQL clause is used to specify the condition for filtering records?
Answer:
WHERE
The `WHERE` clause is the SQL equivalent of the "Criteria" row in the Access design grid. It filters the records based on the specified condition (e.g., `WHERE City = 'London'`).
160
SQL stands for:
Answer:
Structured Query Language
SQL is the standard language for communicating with and managing data in relational databases. Access uses it behind the scenes for all its queries.