The mode used to turn on strict mode and all of the additional restric – McqOptions

MCQOPTIONS

1.	The mode used to turn on strict mode and all of the additional restrictions is _____________.
A.	TRADITIONAL
B.	ERROR_WHEN_DIVIDE_BY_ZERO
C.	STRICT_ALL_TABLES
D.	ERROR_FOR_DIVISION_BY_ZERO
E.	None of these
Answer» B. ERROR_WHEN_DIVIDE_BY_ZERO

Discussion

No Comment Found

Related MCQs

Identify the table name in the following statement.INSERT INTO Employee VALUES('Ajit','M',NULL);
x in the following statement is ____________.DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
In the following code, InnoDB is __________.CREATE TABLE Employee( Emp_name CHAR(30), Emp_id INT(10), PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;
What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';
abc in the following statement is ___________.DELETE FROM xyz WHERE abc = 5;
The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'
What is tamp in the following command?mysql -h xyz.host.try.net -p -u tamp
What is the host name in the following command?mysql -h interview.mania.com -p -u sampadam
The number of attributes in the following table is ______________.CREATE TABLE Student( name CHAR(30), id INT(11) );
What does Student & name specify?CREATE TABLE Student (name);