MCQOPTIONS
Bookmark
Saved Bookmarks
→
Structured Query Language (SQL)
→
Status Variables in Structured Query Language (SQL)
→
If the PIPES_AS_CONCAT is disabled, ‘abc’ || ..
1.
If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________
A.
1
B.
0
C.
error
D.
-1
Answer» C. error
Show Answer
Discussion
No Comment Found
Post Comment
Related MCQs
0x61 + 0 results in _____________
Which of the following is the correct order of precedence (high to low)?
The number of strings among the following matched with ‘%all%’ is _____________
The expression ‘HI’ LIKE NULL results in _____________
The expression ‘2 BETWEEN 2 AND 5’ results in ____________
‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, results in ____________
If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________
WHICH_OF_THE_FOLLOWING_IS_THE_CORRECT_ORDER_OF_PRECEDENCE_(HIGH_TO_LOW)??$
0x61_+_0_results_in______________$
If the operands are non binary strings, LIKE compares them according to their collation.
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply