ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What will be the output of of the following SQL statement?
SELECT person_id, Fname, lname
FROM person;

Answer & Solution
Correct Answer: Option A
This SQL statement is asking the database to show you some information from a table called "person".
Let's break down the parts:
SELECT person_id, Fname, lname : This tells the database to select only the columns named "person_id", "Fname" (first name), and "lname" (last name).
FROM person : This tells the database to get this data from the table called "person".
So, the correct answer is Option A: Show only columns (person_id, Fname, lname) and rows related to these columns. It will display all the rows in the "person" table, but only show the data from the "person_id", "Fname", and "lname" columns.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.