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
6261
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.
6262
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.
6263
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.
6264
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).
6265
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.
6266
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`).
6267
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'`).
6268
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.
6269
What does an "Update Query" do?
Answer:
It modifies the data in existing records within a table
An Update Query is used for bulk changes. For example, you could use one to increase the price of all products in a certain category by 10%.
6270
Which type of query makes changes to the data in your tables?
Answer:
Action Query
Action Queries are used to modify data. There are four types: Make-Table, Append, Update, and Delete queries.