COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which query would return the fields Name and Form?
|
|
SELECT Name, Set FROM Pupils
|
|
|
SELECT Name, Group FROM Pupils
|
|
|
SELECT Name, Form FROM Pupils
|
|
|
SELECT Name, Gender FROM Pupils
|
Explanation:
Detailed explanation-1: -mysql field type function will return the type of field associated with the field.
Detailed explanation-2: -A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data manipulation language (DML) command. As SQL is a declarative programming language, SELECT queries specify a result set, but do not specify how to calculate it.
There is 1 question to complete.