Loading, please wait...

Become An Author

SQL (Structured Query Language) 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 

6. Which of the following are TCL commands?

  • UPDATE and TRUNCATE
  • SELECT and INSERT
  • GRANT and REVOKE
  • ROLLBACK and SAVEPOINT
View Answer

7. ___ is not a category of SQL command.

  • TCL
  • SCL
  • DCL
  • DDL
View Answer

8. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ____

  • ASC
  • DESC
  • There is no default value
  • None of the mentioned
View Answer

9. Which of the following statement is true?

  • DELETE does not free the space containing the table and TRUNCATE free the space containing the table
  • Both DELETE and TRUNCATE free the space containing the table
  • Both DELETE and TRUNCATE does not free the space containing the table
  • DELETE free the space containing the table and TRUNCATE does not free the space containing the table
View Answer

10. What is the purpose of the SQL AS clause?

  • The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
  • The AS clause is used with the JOIN clause only
  • The AS clause defines a search condition
  • All of the mentioned
View Answer

JOIN TUTORIALS LINK

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

CONTRIBUTE

MOBILE APP

Google Play

Follow us

Copyright © 2024. All Rights Reserved.