In MS Access, which clause in SQL is used to specify the table from which to retrieve data? MCQ with Answer and Explanation

In MS Access, which clause in SQL is used to specify the table from which to retrieve data?
A. WHERE
B. SELECT
C. FROM
D. INTO
Answer: Option C
Solution (By JKSSB Mock Tests)
FROM clause specifies table.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Access, what type of table relationship layout is formed when a single record in Table A matches multiple records in Table B, but a record in Table B matches only one record in Table A?
A. One-to-Many Relationship
B. One-to-One Relationship
C. Many-to-Many Relationship
D. Self-Referential database link

Correct Answer: Option A


Explanation:
A One-to-Many relationship is the most common relationship type in relational databases, where a primary key record in one table links to multiple foreign key records in another table.

This question belongs to: Computer Microsoft Office
Question #2
What is the function of the keyboard shortcut Ctrl + Backspace when editing a document in MS Word?
A. Clears all clipboard memories
B. Deletes the single character immediately to the left of the cursor
C. Deletes the entire active row block layout
D. Deletes the entire word immediately to the left of the cursor

Correct Answer: Option D


Explanation:
While Backspace removes text character-by-character, pressing Ctrl + Backspace deletes the entire word to the left of the cursor position.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, what does an 'append query' do?
A. Deletes records from a table
B. Updates existing records
C. Adds records from one table to another
D. Creates a backup of the table

Correct Answer: Option C


Explanation:
Append query inserts records into a target table.

This question belongs to: Computer Microsoft Office