In the following SQL command "*" stands for?
SELECT * FROM person;
SELECT * FROM person;A. Retrieve all data from the table
B. Retrieve data of primary key only
C. Retrieve NULL data
D. None of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question asks about the meaning of the asterisk (*) symbol in a SQL query.Let's break down the query:
SELECT * FROM person;
* SELECT: This keyword tells the database you want to retrieve data.
* FROM person: This tells the database which table to get the data from (in this case, a table called "person").
* * : This is where the asterisk comes in. It's a wildcard symbol.
So, what does the asterisk mean?
It means you want to retrieve all the columns (data fields) from the "person" table.
Therefore, the correct answer is Option A: Retrieve all data from the table.

Join The Discussion