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
6251
How do you include a field in your query but not show it in the results?
Answer:
Uncheck the "Show" checkbox for that field in the design grid
This is useful when you need to use a field for criteria or sorting but don't need to see its value in the final output.
6252
The `?` (question mark) wildcard in an Access query criterion represents:
Answer:
A single unknown character
The question mark is used to match a single character in a specific position. For example, the criterion `Like "Sm?th"` would find "Smith" and "Smyth".
6253
The `SELECT` clause in an SQL statement specifies:
Answer:
The fields (columns) to include in the result
The `SELECT` clause is where you list the columns you want to see in your output (e.g., `SELECT FirstName, LastName, City`).
6254
What is the purpose of a "Delete Query"?
Answer:
To delete records from one or more tables that meet a certain criteria
This is a powerful action query used for removing records in bulk. For example, you could delete all orders that are more than 10 years old.
6255
A query can be based on:
Answer:
One or more tables, or other queries
Queries are very flexible. You can pull data directly from tables, or you can build complex queries by basing a new query on the results of one or more existing queries.
6256
What does the "Totals" row in the Query Design grid allow you to do?
Answer:
Perform aggregate calculations like Sum, Avg, Count, Max, Min on your data
The Totals query is used for summarizing data. For example, you could group by country and then use the `Sum` function on the SalesAmount field to get the total sales for each country.
6257
Which of the following criteria would find all products with a price between $10 and $50 (inclusive)?
Answer:
`Between 10 And 50`
The `Between...And...` operator is an efficient way to select values that fall within a specified range, including the start and end values.
6258
A query that creates a new table from the results of the query is called a:
Answer:
Make-Table Query
This action query is useful for creating a snapshot of data at a specific point in time, for creating a backup of a table before making changes, or for creating a table to be used in a report.
6259
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.
6260
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.