COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
select name from students;
|
|
Will give you all information
|
|
|
Will give you last name information
|
|
|
Will give you Name information
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users. And all the other options are incorrect.
Detailed explanation-2: -An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria. The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2=’value’;
There is 1 question to complete.