What will be the output of of the following SQL statement?

SELECT person_id, Fname, lname
FROM person;

Solution (By Examveda Team)

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.