1. What is the synonym for CHARACTER SET?
2. Which statement is used to check how MySQL would execute a SELECT query?
3. The most important configurable resource for MyISAM is . . . . . . . .
4. What is the table name in the following SQL code?
INSERT INTO student VALUES('Kyle','M',NULL);
INSERT INTO student VALUES('Kyle','M',NULL);
5. What does mysql_query() return on failure?
6. Qualifying the name of column with the table name is not necessary in single-table updates.
7. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is . . . . . . . .
8. Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
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 (c, c++, oop);
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
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 (c, c++, oop);
9. The following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);
SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);
10. The program that copies the databases from one server to another is . . . . . . . .
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 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11