Which option executes all SQL statements in a SQL script irrespective of the number of errors?(a) –ensure(b) –violent(c) –force(d) –runI had been asked this question during an online exam.This is a very interesting question from MySQL Programs in division MySQL Programming of MySQL

Which option executes all SQL statements in a SQL script irrespective

1.	Which option executes all SQL statements in a SQL script irrespective of the number of errors?(a) –ensure(b) –violent(c) –force(d) –runI had been asked this question during an online exam.This is a very interesting question from MySQL Programs in division MySQL Programming of MySQL
Answer» Correct choice is (c) –force For explanation I would say: 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

Which API provides the lowest level interface to the server?(a) C API(b) Perl(c) PHP(d) PythonThe question was posed to me during an interview.This intriguing question comes from Choosing an API topic in division MySQL Programming of MySQL
Which is the correct decreasing order for highly developed text manipulation capabilities?(a) Perl, PHP, C(b) Perl, C, PHP(c) PHP, Perl, C(d) C, PHP, PerlI have been asked this question during an online interview.This interesting question is from Choosing an API topic in section MySQL Programming of MySQL
There is a startup penalty for a standalone interpreter.(a) True(b) FalseThe question was asked in an interview.My question comes from Choosing an API topic in chapter MySQL Programming of MySQL
The protocol CGI is _____________(a) computer graphics interface(b) common graphics interface(c) computer gateway interface(d) common gateway interfaceThe question was posed to me in final exam.I want to ask this question from Choosing an API in section MySQL Programming of MySQL
For a heavily used program, which of these languages should be preferred?(a) C(b) Perl(c) PHP(d) PythonI had been asked this question during an online interview.This intriguing question comes from Choosing an API topic in portion MySQL Programming of MySQL
Compiled programs execute faster than interpreted scripts.(a) True(b) FalseI have been asked this question by my college director while I was bunking the class.My query is from Choosing an API in chapter MySQL Programming of MySQL
The CGI.pm module for website development is a part of _____________(a) Perl(b) Java(c) Python(d) C++This question was posed to me in an online interview.Enquiry is from Choosing an API in chapter MySQL Programming of MySQL
Among the following, for which language is image processing least simple?(a) PHP(b) Perl(c) Python(d) CThe question was posed to me in an online interview.This intriguing question originated from Choosing an API in division MySQL Programming of MySQL
Which of these is the most general purpose language?(a) C(b) Perl(c) Python(d) PHPThe question was asked in an interview for internship.My doubt is from Choosing an API topic in chapter MySQL Programming of MySQL
The MySQL APIs are libraries to connect applications to database servers.(a) True(b) FalseThis question was posed to me in my homework.I'm obligated to ask this question of APIs Available for MySQL in section MySQL Programming of MySQL

Which option executes all SQL statements in a SQL script irrespective of the number of errors?(a) –ensure(b) –violent(c) –force(d) –runI had been asked this question during an online exam.This is a very interesting question from MySQL Programs in division MySQL Programming of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment