The clause that is used to display information that matches a given pattern is _____________(a) WHERE(b) IS(c) SAME(d) LIKEI got this question during a job interview.The above asked question is from SQL Statement Syntax (Non-Compound Statements) topic in section SQL Syntax of MySQL

The clause that is used to display information that matches a given pa

1.	The clause that is used to display information that matches a given pattern is _____________(a) WHERE(b) IS(c) SAME(d) LIKEI got this question during a job interview.The above asked question is from SQL Statement Syntax (Non-Compound Statements) topic in section SQL Syntax of MySQL
Answer» Correct choice is (d) LIKE For explanation I would SAY: The ‘LIKE’ clause FILTERS information that matches a given pattern. ‘WHERE’ clause selects information that is SPECIFIED by a condition. ‘IS’ is used to match the EXACT condition specified.

Discussion

No Comment Found

Related InterviewSolutions

The file that can be used to execute multiple compile statements is _________________(a) makefile(b) dofile(c) putfile(d) pushfileI have been asked this question by my school principal while I was bunking the class.I want to ask this question from Comment Syntax topic in chapter SQL Syntax of MySQL
Which option is used for specifying the executable name while compiling with gcc?(a) -e(b) -o(c) -a(d) -bThis question was addressed to me in an interview for internship.This key question is from Comment Syntax in division SQL Syntax of MySQL
The option that is necessary to compile a C program having math functions is _____________(a) -lm(b) -ln(c) -lp(d) -lqThis question was addressed to me in an interview for internship.This intriguing question originated from Comment Syntax in division SQL Syntax of MySQL
The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________(a) –force(b) –run(c) –ensure(d) –violentThe question was asked in a job interview.This intriguing question originated from Comment Syntax in portion SQL Syntax of MySQL
Input handling can be customized with MySQL.(a) True(b) FalseThe question was posed to me at a job interview.My question is taken from Comment Syntax in portion SQL Syntax of MySQL
The statement that exits a labeled flow-control construct is _____________(a) DESCRIBE(b) LEAVE(c) LOOP(d) RETURNThe question was posed to me during an interview for a job.The doubt is from Comment Syntax in portion SQL Syntax of MySQL
What sets the association between one or more MyISAM tables and the named key cache?(a) BEGIN(b) CACHE INDEX(c) ALTER DATABASE(d) ALTER EVENTThe question was posed to me in homework.This key question is from Comment Syntax topic in division SQL Syntax of MySQL
The MySQL double dashed comment style is the same as the SQL standard.(a) True(b) FalseI got this question during an online exam.This intriguing question originated from Comment Syntax topic in section SQL Syntax of MySQL
Which of these is not a comment specifying construct?(a) #(b) /* */(c) —(d) !#I got this question in an international level competition.The query is from Comment Syntax in section SQL Syntax of MySQL
What can be used interchangeably with MYSQL_VERSION_ID?(a) LIBMYSQL_VERSION(b) LIBMYSQL_VERSION_ID(c) MYSQL_VERSION_ID(d) MYSQL_IDI had been asked this question in examination.My question is taken from Compound Statement Syntax topic in chapter SQL Syntax of MySQL

The clause that is used to display information that matches a given pattern is _____________(a) WHERE(b) IS(c) SAME(d) LIKEI got this question during a job interview.The above asked question is from SQL Statement Syntax (Non-Compound Statements) topic in section SQL Syntax of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment