Q801
Open questionWhich statement can be used to specify the sql_mode system variable at runtime?
Select an option to see the answer and solution.
MySQL · all questionsMySQL
MySQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
1,185
Questions
41/60
Page
Pick an option on a question to see the right answer and solution.
Q802
Open questionWhat does 'abc' || 'xyz' result in if the PIPES_AS_CONCAT is disabled?
Select an option to see the answer and solution.
Q803
Open questionThe clause that enables mapping a short command to a long command is . . . . . . . .
Select an option to see the answer and solution.
Q804
Open questionTo create a database only if it doesn't already exist, which clause is used?
Select an option to see the answer and solution.
Q805
Open questionWhat does mysql_fetch_row() return?
Select an option to see the answer and solution.
Q806
Open questionWhat does a fully qualified table name consist of?
Select an option to see the answer and solution.
Q807
Open questionA DEFAULT value cannot be supplied to spatial types.
Select an option to see the answer and solution.
Q808
Open question'x' in the following MySQL statement is . . . . . . . .
DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;Select an option to see the answer and solution.
Q809
Open questionHow many of the following can be used in stored procedures?
PREPARE, EXECUTE, DEALLOCATE PREPARESelect an option to see the answer and solution.
Q810
Open questionThe default value in seconds in the system variable 'long_query_time' is . . . . . . . .
Select an option to see the answer and solution.
Q811
Open questionIdentify the table name in the following SQL statement.
INSERT INTO student VALUES('Kyle','M',NULL);Select an option to see the answer and solution.
Q812
Open questionThe special database that always exists after setting up MySQL in a computer is . . . . . . . .
Select an option to see the answer and solution.
Q813
Open questionWhich of the following statements is/are correct?
Select an option to see the answer and solution.
Q814
Open questionWhich clause is used to sort query elements?
Select an option to see the answer and solution.
Q815
Open questionThe maximum number of indexes on MyISAM table is . . . . . . . .
Select an option to see the answer and solution.
Q816
Open questionFor the same input parameters, if the stored function returns the same result, it is called . . . . . . . .
Select an option to see the answer and solution.
Q817
Open questionFind the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST, Birth_date)
(1,’s’,’p’, 24-1991-01);Select an option to see the answer and solution.
Q818
Open questionWhich of the following statements does not modify the table?
Select an option to see the answer and solution.
Q819
Open questionTo see the table structure, which of the following SQL commands is issued?
Select an option to see the answer and solution.
Q820
Open questionSuppose you want to select a database named 'sampledb' as the default database. Which of the following commands do you use?
Select an option to see the answer and solution.