COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What would this SQL query display? SQL Forename, Surname FROM Pupils
|
It would only display pupils forename and surname from the Pupils table.
|
|
It is not a SQL statement.
|
|
It would display all pupils forenames from Pupils table.
|
|
It would not display any pupils.
|
Explanation:
Detailed explanation-1: -select FirstName +’ ‘+ MiddleName +’ ‘ + Lastname as Name from TableName.
Detailed explanation-2: -21. What SQL statement do we use to print out the records of all students whose first name or last name ends in ‘A’? Correct Answer: a) SELECT * FROM EXAM RESULTS WHERE FIRST NAME LIKE ‘%A’ OR LAST NAME LIKE ‘%A’;
Detailed explanation-3: -The SQL statement would be: ename like ‘S%S’ .
There is 1 question to complete.