Q601
Open questionThe best datatype for a column that is expected to store values up to 2 million is . . . . . . . .
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
31/60
Page
Pick an option on a question to see the right answer and solution.
Q602
Open questionWhat will be the result of the following MySQL command?
WHERE TITLE=’teller’ OR start_date=’2007-01-01’Select an option to see the answer and solution.
Q603
Open questionIf emp_id contain the following set {1, 2, 2, 3, 3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;Select an option to see the answer and solution.
Q604
Open questionThe 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.
Select an option to see the answer and solution.
Q605
Open questionThe MySQL server is poorly configurable.
Select an option to see the answer and solution.
Q606
Open questionThe AUTO_INCREMENT column attribute is best used with which type?
Select an option to see the answer and solution.
Q607
Open questionThe metadata log is . . . . . . . .
Select an option to see the answer and solution.
Q608
Open questionIn MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .
Select an option to see the answer and solution.
Q609
Open questionWhich is the MySQL instance responsible for data processing?
Select an option to see the answer and solution.
Q610
Open questionWhich file can be used to execute multiple compile statements?
Select an option to see the answer and solution.
Q611
Open questionFor InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by . . . . . . . .
Select an option to see the answer and solution.
Q612
Open questionabc in the following MySQL statement is . . . . . . . .
CREATE VIEW xyz (abc) AS SELECT a FROM t;Select an option to see the answer and solution.
Q613
Open questionWhich statement terminates the execution of a function?
Select an option to see the answer and solution.
Q614
Open questionHow many storage engines among the following are transaction-safe?
InnoDB, Falcon, MyISAM, MEMORYSelect an option to see the answer and solution.
Q615
Open questionWhat is the default format for "Time" data type?
Select an option to see the answer and solution.
Q616
Open questionConsider a database name "db_name" whose attributes are intern_id (primary key), subject, subject_value.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
Subject_value = {0, 0, 1, 1, 2, 2, 3, 3}
If these are one to one relation then what will be the output of the following MySQL statement?
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
Subject_value = {0, 0, 1, 1, 2, 2, 3, 3}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (SELECT subject FROM db_name WHERE subject_value = 3);Select an option to see the answer and solution.
Q617
Open questionWhich clause is mandatory with clause "SELECT" in Mysql?
Select an option to see the answer and solution.
Q618
Open questionWhat represents an 'attribute' in a relational database?
Select an option to see the answer and solution.
Q619
Open questionWhat is the maximum non zero values for DOUBLE?
Select an option to see the answer and solution.
Q620
Open questionWhat will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date>=’2007-01-01’ AND
Start_date<=’2005-01-01’Select an option to see the answer and solution.