Q298
What will be the output of of the following SQL statement? SELECT person_id, Fname, lname FROM person;
A.
Show only columns (person_id, Fname, lname) and rows related to these columns
AnswerB.
Show only columns (person_id, Fname, lname)
C.
Show all rows
D.
Show all columns except (person_id, Fname, lname)
Answer: Option A
Solution
Answer: Option A
Solution:
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.