Which of the following SQL commands is used to view data?
2019
Which of the following SQL commands is used to view data?
- A.
CREATE
- B.
INSERT
- C.
SELECT
- D.
UPDATE
- E.
None of these
Attempted by 1418 students.
Show answer & explanation
Correct answer: C
To view data in a database, the correct SQL command is SELECT. Let's analyze each option: 1. CREATE: This command is used to create a new table or database. It does not retrieve or display data. 2. INSERT: This command adds new records into a table. It is used for data entry, not for viewing existing data. 3. SELECT: This command retrieves data from one or more tables. It allows you to view specific columns or rows based on conditions. This is the correct command for viewing data. 4. UPDATE: This command modifies existing records in a table. It changes data but does not display it. 5. None of these: This option is incorrect because SELECT is a valid command for viewing data.