MySQL Questions and Answers – MySQL Setup – 1

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “MySQL Setup – 1”.

1. Which of the following clauses is used to display information that match a given pattern?
a) LIKE
b) WHERE
c) IS
d) SAME
View Answer

2. What column names are displayed when this SQL command is executed?

SHOW COLUMNS FROM tbl_name LIKE '%name';

a) suffixed with ‘name’
b) prefixed with ‘name’
c) suffixed with ‘%name’
d) prefixed with ‘%name’
View Answer

3. The special database that always exists after setting up MySQL in a computer is __________
a) sampdb
b) mysql
c) information_schema
d) readme_db
View Answer

4. In the following SQL code, InnoDB is __________

CREATE TABLE student (
		name CHAR(30),
		student_id INT,
		PRIMARY KEY (student_id)
	) ENGINE = InnoDB;

a) database name
b) table name
c) reference engine
d) storage engine
View Answer

5. Identify the table name in the following SQL statement.

	INSERT INTO student VALUES('Kyle','M',NULL);

a) Student
b) Values
c) Kyle
d) M
View Answer

6. What is ‘xyz’ in the following SQL statement?

	SELECT abc FROM xyz;

a) row name
b) column name
c) table name
d) database name
View Answer

7. Which operator is used to perform integer divisions in MySQL?
a) /
b) \
c) DIV
d) //
View Answer

8. The NULL value also means ___________
a) value equal to zero
b) unknown value
c) negative values
d) a large value
View Answer

9. What does comparing a known value with NULL result into?
a) zero
b) a positive value
c) a negative value
d) null
View Answer

10. Which clause is used to sort query elements?
a) GROUP
b) GROUP BY
c) ORDER
d) ORDER BY
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.