Mysql Setup
- What are X’61626364′ and X’61626364′?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
In the numeric contexts, each hexadecimal number constant is treated as a number. Without adding a zero to it, a hexadecimal literal is treated as a string. Hence it is displayed as abcd.
- What is x’ffff’ in decimal?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
In MySQL, string values are specified using the standard SQL notation x’val’. Here, val is pairs of hexadecimal digits ( ‘0’ through ‘ 9 ’ and ‘ a ’ through ‘ f ’). x’ffff’ is 65536 in decimal.
- The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
To turn off the special meaning of backslash in MySQL, and treat it as an ordinary character, the SQL mode named NO_BACKSLASH_ESCAPES is enabled. The escape sequence is treated as characters.
- ‘x’ in the following statement is ____________.
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
The ‘DELETE’ operation is being performed in the statement. The table names are ‘x’ and ‘y’. The column name is ‘col’. The rows from left join of x and y get deleted according to the condition given.
- abc in the following statement is ___________.
DELETE FROM xyz WHERE abc = 5;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
Here, the operation that is being performed in the statement is the ‘DELETE’ operation. The table name is ‘xyz’ and column name is ‘abc’. The rows having abc value equal to 5 get deleted.