MySQL MCQ Test – 1
Que.1. BLOB data type can have default
column value.
A. True
B. False
Right Answer: B
Que.2. User() function return the
current user name and ___________
A. password
B. host
name
C. both
a and b above
D. database
name associated with the user
Right Answer: B
Que.3. Can DISTINCT command be used for
more than one column?
A. No
B. Yes
Right Answer: B
Que.4. How much storage space does
DATETIME require?
A. 4
bytes
B. 2
bytes
C. 8
bytes
D. 1
bytes
Right Answer: C
Que.5. Which of the following file extension
is valid MyISAM file extension?
A. .ism
B. .myd
C. .my
D. .mys
Right Answer: B
Que.6. –i-am-a-dummy flag is used Make
the MySQL engine refuse UPDATE and which other command?
A. WHERE
B. INSERT
C. DELETE
D. TRUNCATE
Right Answer: C
Que.7. On executing DELETE command, if
you get an error “foreign key constraint” – what does it imply?
A. Foreign
key not defined
B. Table
is empty
C. Connectivity
issue
D. Data
is present in the other table
Right Answer: D
Que.8.
Can I call a trigger directly
from an application?
A. Yes
B. No
Right Answer: B
Que.9. What is a candidate key?
A. Used
to uniquely identify a row
B. Alias
for primary key
C. Used
to identify a column
D. Alias
for foreign key
Right Answer: A
Que.10. Which is the default order of
sort in ORDER BY clause?
A. Ascending
B. Descending
Right Answer: A
Que.11. Can I define multiple unique
constraints on a table?
A. Yes
B. No
Right Answer: A
Que.12. How can we get the number of
records or rows in a table?
A. Using
COUNT
B. Using
NUM
C. Using
NUMBER
D. Both
a and c above
Right Answer: A
Que.13. Which of the following ways
below are the correct way to get the current date?
A. SELECT
CURTIME();
B. SELECT
CURDATE();
C. SLELCT
CURRRENT_TIME()
D. All
of the above
Right Answer: D
Que.14. USE keyword is used to select a ____________________
A. Table
B. Column
C. Database
D. All
of the above
Right Answer: C
Que.15. How do I find out all databases
starting with `test to which I have access to ?
A. SHOW
DATABASES LIKE `%test%`;
B. SHOW
DATABASES LIKE `%test;
C. SHOW
DATABASES LIKE `’test’%’;
D. SHOW
DATABASES LIKE `%test%’;
Right Answer: D
Que.16. A view is nothing but a
_____________ table or a stored query.
A. Dynamic
B. Real
C. Virtual
D. Static
Right Answer: C
Que.17. When do we use a HAVING clause?
A. To
limit the output of a query
B. To
limit the output of a query using an aggregate function only
C. When
GROUP by is used
D. Both
a and c above
Right Answer: B
Que.18. An outer join requires each
record in the two joined tables to have a matching record
A. True
B. False
Right Answer: B
Que.19. Enum values are stored according
to their index numbers
A. True
B. False
Right Answer: A
Que.20. If an ENUM column is declared
NOT NULL, its default value is the
first element of the list of allowed values.
A. True
B. False,
ENUM column cannot be null
C. False,
its default value is the last element of the list of allowed values
Right Answer: A
