Loading, please wait...

Become An Author

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 

21.  In order to add a new column to an existing table in SQL, we can use the command

  • MODIFY TABLE
  • EDIT TABLE
  • ALTER TABLE
  • ALTER COLUMNS
View Answer

22. Which datatypes are treated as arrays

  • Integer
  • Float
  • String
  • Booleans
View Answer

23. Which clause is used to sort the result of SELECT statement?

  • SORT BY
  • ORDER BY
  • ARRANGE BY
  • None of the above
View Answer

24. Which command returns current version on MySQL?

  • SELECT MySQLVERSION();
  • SELECT VERSION(“MySQL”);
  •  SELECT VERSION();
  • All of the above
View Answer

25. Which of these commands will delete a table called XXX if you have appropriate authority?

  • DROP XXX
  • DELETE XXX WHERE confirm = “YES”
  • DROP XXX WHERE confirm = “YES”
  • DROP TABLE XXX
View Answer

JOIN TUTORIALS LINK

Our Newsletter Will Let You Know When Any New
Articles, Tutorials and Video Are Released.

CONTRIBUTE

Follow us

Copyright © 2024. All Rights Reserved.