Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 229
Q3101:
Which of the following is NOT a type of query in MS Access?
A. Select
B. Insert
C. Update
D. Sort
Correct Answer:
D
Chapter: 229
Q3102:
Which SQL keyword is used to retrieve data from a database?
A. INSERT
B. DELETE
C. SELECT
D. UPDATE
Correct Answer:
C
Chapter: 229
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
Correct Answer:
B
Chapter: 229
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
Correct Answer:
C
Chapter: 229
Q3105:
Which tab in MS Access is used to start creating a query?
A. Home
B. Design
C. Create
D. Database Tools
Correct Answer:
C
Chapter: 229
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
Correct Answer:
C
Chapter: 229
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
Correct Answer:
A
Chapter: 229
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
Correct Answer:
C
Chapter: 229
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
Correct Answer:
C
Chapter: 229
Q3110:
Which button do you click after designing a query to execute it in MS Access?
A. Save
B. Run
C. Finish
D. Create
Correct Answer:
B
Chapter: 229
Q3111:
In Query Design View, which clause can be added to further filter query results?
A. JOIN
B. ORDER BY
C. GROUP BY
D. WHERE
Correct Answer:
D
Chapter: 229
Q3112:
What is the generic SQL syntax to update records in a table?
A. UPDATE table_name SET field1=newvalue1
B. INSERT INTO table_name VALUES
C. DELETE FROM table_name WHERE criteria
D. SELECT * FROM table_name
Correct Answer:
A
Chapter: 229
Q3113:
Which view in MS Access allows you to design a query with additional parameters?
A. Datasheet View
B. Form View
C. Design View
D. SQL View
Correct Answer:
C
Chapter: 229
Q3114:
Fill in the blank: To view the SQL syntax of a query in MS Access, right-click the query tab and select ______.
A. Design View
B. SQL View
C. Form View
D. Datasheet View
Correct Answer:
B
Chapter: 230
Q3115:
What is the primary purpose of a web browser in relation to HTML?
A. To edit HTML code
B. To display HTML tags
C. To interpret and compose HTML into web pages
D. To save HTML files
Correct Answer:
C
Chapter: 230
Q3116:
What file extension is commonly associated with web pages?
A. .txt
B. .html
C. .exe
D. .doc
Correct Answer:
B
Chapter: 230
Q3117:
Which HTML tags define the start and end of a web page?
A. <body> and </body>
B. <h1> and </h1>
C. <p> and </p>
D. <html> and </html>
Correct Answer:
D
Chapter: 230
Q3118:
What is the purpose of the <h1> tag in HTML?
A. To create a paragraph
B. To start a new line
C. To create the first heading
D. To insert an image
Correct Answer:
C
Chapter: 230
Q3119:
Which HTML tag is used to display a paragraph?
A. <p>
B. <h1>
C. <a>
D. <img>
Correct Answer:
A
Chapter: 230
Q3120:
Fill in the blank: The <img> tag in HTML is used to _______.
A. create a link
B. insert an image
C. add a heading
D. create a table
Correct Answer:
B