11. Identify the table name in the following SQL statement.
INSERT INTO student VALUES('Kyle','M',NULL);
INSERT INTO student VALUES('Kyle','M',NULL);
12. The special database that always exists after setting up MySQL in a computer is . . . . . . . .
13. Which of the following statements is/are correct?
14. Which clause is used to sort query elements?
15. The maximum number of indexes on MyISAM table is . . . . . . . .
16. For the same input parameters, if the stored function returns the same result, it is called . . . . . . . .
17. Find 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);
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);
18. Which of the following statements does not modify the table?
19. To see the table structure, which of the following SQL commands is issued?
20. Suppose you want to select a database named 'sampledb' as the default database. Which of the following commands do you use?
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 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12