Software Testing Material

A site for software testers. We provide free online tutorials on Manual Testing, Automation Testing - Selenium, QTP, LoadRunner, Testing Tools and many more.

SQL Quiz | Software Testing Material

Last Updated on by Leave a Comment

Welcome to your SQL Quiz. This quiz consists of 30 multiple-choice questions. There is no negative marking in this. Click on NEXT button to Start this Java Quiz.

1. Which SQL keyword you use to merge two tables based on a matching column?
2. Which of the following is not a Data Definition Language (DDL) statement?
3. Which SQL statement is used to extract data from a database?
4. Which type of database management system represents relations using tables?
5. Which SQL statement is used to modify the existing records in a table?
6. Which of the following is not a part of SQL
7. Which function returns the difference between two dates
8. The UNION operator is used to
9. Which of the following is not a RDBMS?
10. Which statement is correct
11. With SQL, how do you select a column named "FirstName" from a table named "Employees"?
12. The table rows are also known as
13. A NULL value is different than a zero value or a field that contains spaces
14. Which of the following is not an SQL Aggregate function
15. Subqueries can be nested multiple times
16. The AND operator displays a record if all the conditions separated by AND are TRUE
17. The table columns are also known as
18. Which SQL statement is used to remove rows from a table?
19. Which SQL statement is used to insert new rows of data to a table in a database
20. Which SQL statement is used to delete complete data from an existing table?
21. Which SQL statement is used to delete complete data from an existing table & table structure from the database?
22. With SQL, how do you select all the columns from a table named "Employees"?
23. The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column
24. What is the keyword you use to group the result by a column's values?
25. What does SQL stand for?
26. Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns
27. Which of the following keyword you use to modify the existing value in an UPDATE query?
28. Which SQL statement is used to return only different values?
29. The result of a SELECT statement can contain duplicate rows
30. The OR operator displays a record if any of the conditions separated by OR is TRUE

SQL Quiz – You can test your knowledge with this SQL Quiz. We have created this SQL Quiz Online Test to help you master SQL.

Knowledge Base:

 

SUBSCRIBE TO GET FREE EBOOK AND REGULAR UPDATES ON SOFTWARE TESTING

About the Author

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

Leave a Reply

Your email address will not be published. Required fields are marked *

TUTORIALS

  • Manual Testing Tutorial
  • Selenium Tutorial
  • TestNG Tutorial
  • VBScript Tutorial
  • Agile Methodology
  • SQL Tutorial for Testers

    • INTERVIEW QUESTIONS

  • Framework Interview Questions
  • Real Time Manual Testing
  • 100 Top Selenium Interview Questions
  • 30 Top TestNG Interview Questions
  • Agile Interview Questions
  • 80 SQL Interview Questions

    • TESTING TOOLS

  • Test Lodge
  • FrogLogic Squish
  • Cross Browser Testing
  • BrowserStack
  • Test Case Lab
  • Sikuli