Improve Your MySQL Ability : Part-3

Improve Your MySQL Ability

Q. 15. ) Is Mysql query has LETTERCASE?

A. YES
B. NO

Q. 16. ) 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

Q. 17. ) 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
D. False

Q. 18. ) Can I define multiple unique constraints on a table?

A. Yes
B. No

Q. 19. ) A view is nothing but a ________ table or a stored query

A. Dynamic
B. Real
C. Virtual
D. Static

Q. 20. ) BLOB data type can have default column value.

A. True
B. False

Q. 21. ) User() function returns the current users user name and ___________

A. password
B. host name
C. both a and b above
D. database name associated with the user

                Previous--------------------------------Next