Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q3101: Which of the following is NOT a type of query in MS Access?
- A: Select
- B: Insert
- C: Update
- D: Sort
View Answer
D
Q3102: Which SQL keyword is used to retrieve data from a database?
- A: INSERT
- B: DELETE
- C: SELECT
- D: UPDATE
View Answer
C
Q3103: Fill in the blank: The SQL syntax to retrieve all fields from a table is SELECT * FROM ________;.
- A: field_name
- B: table_name
- C: query_name
- D: database_name
View Answer
B
Q3104: What does the WHERE clause in a SQL query do?
- A: Inserts new data
- B: Deletes a table
- C: Sets criteria for data selection
- D: Joins two tables
View Answer
C
Q3105: Which tab in MS Access is used to start creating a query?
- A: Home
- B: Design
- C: Create
- D: Database Tools
View Answer
C
Q3106: What is the first step in creating a query using the Query Wizard in MS Access?
- A: Select the table
- B: Open Design View
- C: Click Create tab
- D: Enter SQL View
View Answer
C
Q3107: Which fields are selected in the exercise to create a query for the Student table?
- A: sname and ssems
- B: sname and cid
- C: ssems and ctitle
- D: sname and cinstructor
View Answer
A
Q3108: After creating a query, where can you view its SQL syntax in MS Access?
- A: Design View
- B: Datasheet View
- C: SQL View
- D: Form View
View Answer
C
Q3109: Fill in the blank: In the criteria box of the field ssems, type __ to view records of students in the 3rd semester.
- A: 2
- B: 1
- C: 3
- D: 4
View Answer
C
Q3110: Which button do you click after designing a query to execute it in MS Access?
- A: Save
- B: Run
- C: Finish
- D: Create
View Answer
B