COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Feature begins with two 0’s
|
|
|
Feature ends with two 0’s
|
|
|
Feature has more than two 0’s
|
|
|
Feature has two 0’s in it, at any position
|
Detailed explanation-1: -The correct answer is option (D) Feature has two 0’s in it, at any position. Explanation: The meaning of LIKE ‘%0%0%’ is that ) Feature has two 0’s in it, at any position. The SQL Like is a logical operator that is used to determine whether a specific character string matches a specified pattern.
Detailed explanation-2: -0=0 is like TRUE. This is used when you want to dynamically append different conditions in the where clause of a select statement. In case there are no where clauses all records will be retured from the query.
Detailed explanation-3: -MySQLi MySQLDatabase. The symbol <> in MySQL is same as not equal to operator (!=). Both gives the result in boolean or tinyint(1). If the condition becomes true, then the result will be 1 otherwise 0. Case 1 − Using !=
Detailed explanation-4: -Basically, we have only three types of joins: Inner join, Outer join, and Cross join. We use any of these three JOINS to join a table to itself. Hence Self-join is not a type of SQL join.
Detailed explanation-5: -The maximum number of tables that can be referenced in a single join is 61. This also applies to the number of tables that can be referenced in the definition of a view.