Loading, please wait...

My SQL MCQ Quiz (Multiple Choice Questions And Answers)

Search here for MCQs

Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:

List of Programming Full Forms 

11. In a LIKE clause, you can ask for any 6 letter value by writing:

  • LIKE ______ (that’s six underscore characters)
  •  LIKE .{6}
  • LIKE ^.{6}$
  • LIKE …… (that’s six dots)

12. Which of the following is available in MySQL:

  • CREATE VIEW
  • CREATE SCHEMA
  • CREATE TRIGGER
  • CREATE DATABASE

13. Which of these field types would be best to hold a .jpg image?

  • char binary
  • nchar binary
  • text
  • blob

14. What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?

  • Only SHOW FIELDS FROM can take a LIKE clause
  • Nothing – they’re the same thing
  •  Only DESCRIBE can take a LIKE clause

15. To remove duplicate rows from the result set of a SELECT use the following keyword:

  • NO DUPLICATE
  • UNIQUE
  • DISTINCT
  • None of the above