11. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by . . . . . . . .
12. abc in the following MySQL statement is . . . . . . . .
CREATE VIEW xyz (abc) AS SELECT a FROM t;
CREATE VIEW xyz (abc) AS SELECT a FROM t;
13. Which statement terminates the execution of a function?
14. How many storage engines among the following are transaction-safe?
InnoDB, Falcon, MyISAM, MEMORY
InnoDB, Falcon, MyISAM, MEMORY
15. What is the default format for "Time" data type?
16. Consider 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?
SELECT intern_id
FROM db_name
WHERE subject IN (SELECT subject FROM db_name WHERE subject_value = 3);
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);
17. Which clause is mandatory with clause "SELECT" in Mysql?
18. What represents an 'attribute' in a relational database?
19. What is the maximum non zero values for DOUBLE?
20. What 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 *
FROM employee
WHERE start_date>=’2007-01-01’ AND
Start_date<=’2005-01-01’
Read More Section(MySQL Miscellaneous)
Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.
- MySQL Miscellaneous - Section 1
- MySQL Miscellaneous - Section 2
- MySQL Miscellaneous - Section 3
- MySQL Miscellaneous - Section 4
- MySQL Miscellaneous - Section 5
- MySQL Miscellaneous - Section 6
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12