Vidyalelo
MySQL · Q54

MySQL

Programming · MySQL · question 54

Q54

Find the missing clause from the following SQL statement? CREATE VIEW person_1 AS SELECT fname, lname, person_id _________ person;

A.
FROM
Answer
B.
WHERE
C.
SELECT
D.
None of the mentioned

Answer: Option A

Solution

Answer: Option A
Solution:
FROM: In SQL, the FROM clause is used to specify the table or tables from which data will be selected. In this context, the FROM clause is required to indicate the source table (person) from which the columns fname, lname, and person_id are selected.
WHERE: The WHERE clause is used to specify conditions that filter the rows returned by the query. It is not necessary in this context since the SELECT statement does not include any filtering conditions.
SELECT: The SELECT keyword is already present in the SQL statement, so it is not the missing clause.
None of the mentioned: This option is not applicable as there is indeed a missing clause that needs to be identified.

Therefore, the missing clause from the SQL statement is Option A: FROM.