COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT Username AND Password FROM Users
|
|
|
SELECT Username, Password FROM Users
|
|
|
SELECT Username, Password WHERE Username = ‘user1’
|
|
|
None of the Mentioned
|
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: -The correct answer is Select, where, group by, having.
Detailed explanation-3: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.
Detailed explanation-4: -The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.
Detailed explanation-5: -The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator: The percent sign (%) represents zero, one, or multiple characters. The underscore sign ( ) represents one, single character.