The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________(a) –ensure(b) –force(c) –violent(d) –runThis question was addressed to me in final exam.Asked question is from Structure of the Data Directory in chapter MySQL Data Directory 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) –ensure(b) –force(c) –violent(d) –runThis question was addressed to me in final exam.Asked question is from Structure of the Data Directory in chapter MySQL Data Directory of MySQL
Answer» Right choice is (b) –force The explanation is: 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 command is used to make a script file ‘run_me.sh’ executable?(a) chmod +e run_me.sh(b) chmod +a run_me.sh(c) chmod +y run_me.sh(d) chmod +x run_me.shThe question was posed to me during an interview for a job.This intriguing question comes from Relocating Data Directory Contents in section MySQL Data Directory of MySQL
Mysql cannot be used to execute script files.(a) True(b) FalseThe question was posed to me in an interview for internship.The question is from Relocating Data Directory Contents topic in section MySQL Data Directory of MySQL
In which file are the statements entered in ‘mysql’ saved?(a) .mysql_queries(b) .queries(c) .mysql_history(d) .historyI had been asked this question in an internship interview.I want to ask this question from Relocating Data Directory Contents in section MySQL Data Directory of MySQL
What is the special database that always exists after setting up MySQL on a computer?(a) sampdb(b) mysql(c) information_schema(d) readme_dbI have been asked this question during an interview for a job.The question is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
When relocating an individual table, the table to be relocated should be ______________(a) MyISAM(b) InnoDB(c) TRANSACTION(d) ENGINEThis question was addressed to me during an interview.My enquiry is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
Before relocation of database, the server should be stopped if running.(a) True(b) FalseI have been asked this question during an online interview.My enquiry is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
For which of these is the startup option best suited?(a) entire data directory(b) individual database tables(c) server PID file(d) individual database directoriesI have been asked this question in an online quiz.I'd like to ask this question from Relocating Data Directory Contents in portion MySQL Data Directory of MySQL
Symlink is an applicable relocation method for ______________(a) entire data directory(b) individual database tables(c) server PID file(d) log filesI had been asked this question in my homework.Enquiry is from Relocating Data Directory Contents topic in portion MySQL Data Directory of MySQL
What is the statement used to select a default database?(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was posed to me in semester exam.My question comes from Structure of the Data Directory in portion MySQL Data Directory of MySQL
What is the synonym for CHARACTER SET?(a) CSET(b) CHSET(c) CHARSET(d) CHCSETI got this question in class test.This interesting question is from Structure of the Data Directory in section MySQL Data Directory of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment