The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________(a) –run(b) –ensure(c) –force(d) –violentI have been asked this question during an internship interview.This is a very interesting question from SQL Statement Syntax (Non-Compound Statements) in chapter SQL Syntax of MySQL

The option that executes all SQL statements in a SQL script irrespecti

1.	The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________(a) –run(b) –ensure(c) –force(d) –violentI have been asked this question during an internship interview.This is a very interesting question from SQL Statement Syntax (Non-Compound Statements) in chapter SQL Syntax of MySQL
Answer» The correct answer is (c) –force Easy explanation: If SQL queries in a file are RUN USING mysql in batch mode, mysql either QUITS after the first error. If the –force option is specified all the queries are executed INDISCRIMINATELY.

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment