What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?(a) 1(b) 0(c) error(d) -1I had been asked this question in an interview for internship.The query is from Using Perl DBI in Web Applications in division MySQL Programs Using Perl DBI and PHP of MySQL

What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is d

1.	What does ‘abc’ \|\| ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?(a) 1(b) 0(c) error(d) -1I had been asked this question in an interview for internship.The query is from Using Perl DBI in Web Applications in division MySQL Programs Using Perl DBI and PHP of MySQL
Answer» Right ANSWER is (b) 0 For explanation: When the SQL mode PIPES_AS_CONCAT is disabled, the SQL STANDARD ‘\|\|’ operation for string concatenation is not VALID in MySQL. Both operands are converted to zero. So the result is zero.

Discussion

No Comment Found

Related InterviewSolutions

What is the maximum number of indexes on MyISAM table?(a) 0(b) 1(c) 2(d) more than 1I got this question in an online interview.The origin of the question is Putting PHP to Work in section MySQL Programs Using Perl DBI and PHP of MySQL
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________(a) bad(b) good(c) illegal(d) fareThe question was asked in an interview for job.This intriguing question originated from Putting PHP to Work topic in section MySQL Programs Using Perl DBI and PHP of MySQL
What is the creation of a stored program similar to?(a) Trigger(b) Event(c) View(d) TableThe question was posed to me in final exam.Origin of the question is Putting PHP to Work topic in portion MySQL Programs Using Perl DBI and PHP of MySQL
The line used to turn on the event scheduler is ______________(a) event_scheduler = ON(b) eventscheduler = ON(c) event_scheduler_ON(d) events_scheduler_ONThis question was posed to me in exam.I need to ask this question from Putting PHP to Work topic in division MySQL Programs Using Perl DBI and PHP of MySQL
A stored program associated with a schedule is ______________(a) Trigger(b) Event(c) Stored function(d) Stored procedureThe question was asked in homework.Enquiry is from Putting PHP to Work topic in section MySQL Programs Using Perl DBI and PHP of MySQL
DBI scripts are located in the directory ______________(a) cgi-inc(b) cgi-bin(c) cgi-usr(d) cgi-perlThis question was posed to me in examination.This interesting question is from Putting PHP to Work in section MySQL Programs Using Perl DBI and PHP of MySQL
PHP scripts are located in the web server document tree.(a) True(b) FalseThe question was asked during a job interview.I want to ask this question from Putting PHP to Work topic in division MySQL Programs Using Perl DBI and PHP of MySQL
In PHP, which operator is used to access property of an object?(a) .(b) *(c) ->(d) @I have been asked this question in my homework.Question is from Putting PHP to Work topic in division MySQL Programs Using Perl DBI and PHP of MySQL
Arrays cannot have associative indices in PHP.(a) True(b) FalseThis question was addressed to me in an interview.The query is from Putting PHP to Work in portion MySQL Programs Using Perl DBI and PHP of MySQL
In PHP, if $a represents an array with numeric indices, how is the first element accessed?(a) $a[1](b) $a[0](c) $a.1(d) $a.0This question was addressed to me in examination.The doubt is from Putting PHP to Work in portion MySQL Programs Using Perl DBI and PHP of MySQL

What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?(a) 1(b) 0(c) error(d) -1I had been asked this question in an interview for internship.The query is from Using Perl DBI in Web Applications in division MySQL Programs Using Perl DBI and PHP of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment