Each database has a data directory located under database directory.
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
5/60
Page
Pick an option on a question to see the right answer and solution.
The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.
Select an option to see the answer and solution.
The following MySQL query belongs to which condition types?
SELECT fname
FROM person
WHERE title=’TELLER’;Select an option to see the answer and solution.
Deletion of an employee from table also deletes that employee from another table. This kind of delete is called . . . . . . . .
Select an option to see the answer and solution.
The default case sensitivity of the database and table names depends on . . . . . . . .
Select an option to see the answer and solution.
What is the default format for "Year" data type?
Select an option to see the answer and solution.
Association between one or more MyISAM tables and the named key cache is set by . . . . . . . .
Select an option to see the answer and solution.
In the following SQL code, InnoDB is . . . . . . . .
CREATE TABLE student (
name CHAR(30),
student_id INT,
PRIMARY KEY (student_id)
) ENGINE = InnoDB;Select an option to see the answer and solution.
Which command is used for showing current date and time in Mysql command line tool?
Select an option to see the answer and solution.
Which datatype means a variable length non binary string?
Select an option to see the answer and solution.
MySQL does not support the shared-memory connections on Windows.
Select an option to see the answer and solution.
Transactional processing provides strong guarantees about the outcome of operations.
Select an option to see the answer and solution.
The command to see the warning messages is . . . . . . . .
Select an option to see the answer and solution.
What will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id IN (‘sav’, ‘chd’, ‘mm’);
Select an option to see the answer and solution.
The right shift operator is . . . . . . . .
Select an option to see the answer and solution.
The expression 'HI' LIKE NULL results in . . . . . . . .
Select an option to see the answer and solution.
The number of strings among the following matched with '%all%' is . . . . . . . .
Ball, baller, tall, tallestSelect an option to see the answer and solution.
The MySQL double dashed comment style is the same as the SQL standard.
Select an option to see the answer and solution.
Input handling can be customized with MySQL.
Select an option to see the answer and solution.
Q100
Open question'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in . . . . . . . .
Select an option to see the answer and solution.