MySQL Mock Test 1 - Sanfoundry

10%

Question 1 of 10

1. What does 'abc' & 'xyz' specify in the following SQL statement?

CREATE TABLE abc (xyz);

table name and number of columns

table name and number of rows

column specs and table name

table name and column specs

Question 1 of 10

Question 2 of 10

2. When no modes are enabled, what does this SQL statement return?

SELECT @@SESSION.sql_mode;

empty value

a negative value

zero

a garbage value

Question 2 of 10

Question 3 of 10

3. The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

True

False

Question 3 of 10

Question 4 of 10

4. Which table stores information about the threads executing within the server?

LIST

THREADSLIST

PROCESSLIST

PROCESS

Question 4 of 10

Question 5 of 10

5. Which of the following options tells mysql to ask for entering the password?

-h

-p

-e

-u

Question 5 of 10

Question 6 of 10

6. The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

SCHEMATA

FILES

VIEWS

STATISTICS

Question 6 of 10

Question 7 of 10

7. The special database that always exists after setting up MySQL in a computer is __________

information_schema

mysql

sampdb

readme_db

Question 7 of 10

Question 8 of 10

8. The number of attributes in the following SQL table is ______________

CREATE TABLE employee (
		emp_name CHAR(30),
		emp_id INT
	);

Question 8 of 10

Question 9 of 10

9. Which clause is used to sort query elements?

GROUP

ORDER BY

ORDER

GROUP BY

Question 9 of 10

Question 10 of 10

10. Post MySQL 6.0, utf8 was ___________

6 bytes

3 bytes

4 bytes

5 bytes

Question 10 of 10