Skip to content
Software Testing Material Logo
  • Blog
  • TutorialsExpand
    • Expand
      • Manual Testing
      • Selenium
      • TestNG
      • Maven
      • Jenkins
      • Framework
    • Expand
      • Java
      • Agile
      • API Testing
      • Postman
      • SQL
      • VBScript
  • ToolsExpand
    • Recommended ToolsExpand
      • PractiTest
      • TestPad
      • Qase
      • WebLoad
      • Testiny
      • Test Lodge
      • Froglogic Squish
      • CrossBrowserTesting
    • Expand
      • ActiveBatch
      • Kobiton
      • JScape
      • Redwood
      • TestCaseLab
      • Sikuli
      • Postman
      • TestRail
    • Best ToolsExpand
      • Enterprise Job Scheduler
      • Test Management
      • Automation Testing
      • Codeless Testing
      • Selenium Alternatives
      • Bug Tracking
      • Mobile App Testing
      • Cross Browser Testing
    • Expand
      • API Testing
      • Unit Testing
      • Regression Testing
      • Continuous Testing
      • Functional Testing
      • Penetration Testing
      • Performance Testing
  • Interview Q & AExpand
    • Expand
      • Selenium
      • TestNG
      • Test Framework
      • Explain Framework
      • API
      • SOAP
      • Protractor
    • Expand
      • Manual Testing
      • Software QA
      • Agile
      • JIRA
      • Java
      • Python
      • SQL
  • Free Resources
  • QuizExpand
    • Selenium Quiz
    • ISTQB Quiz
    • Java Quiz
    • SQL Quiz
  • Jobs
Software Testing Material Logo

SQL Quiz

1. 

Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns

2. 

The OR operator displays a record if any of the conditions separated by OR is TRUE

3. 

What is the keyword you use to group the result by a column's values?

4. 

A NULL value is different than a zero value or a field that contains spaces

5. 

Which of the following keyword you use to modify the existing value in an UPDATE query?

6. 

The table columns are also known as

7. 

The AND operator displays a record if all the conditions separated by AND are TRUE

8. 

Which SQL statement is used to delete complete data from an existing table & table structure from the database?

9. 

Which SQL statement is used to return only different values?

10. 

With SQL, how do you select a column named "FirstName" from a table named "Employees"?

11. 

Which type of database management system represents relations using tables?

12. 

Which SQL statement is used to insert new rows of data to a table in a database

13. 

The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column

14. 

Which SQL statement is used to extract data from a database?

15. 

The result of a SELECT statement can contain duplicate rows

16. 

The table rows are also known as

17. 

Which function returns the difference between two dates

18. 

Subqueries can be nested multiple times

19. 

Which of the following is not a Data Definition Language (DDL) statement?

20. 

Which SQL statement is used to remove rows from a table?

21. 

Which of the following is not a part of SQL

22. 

Which of the following is not an SQL Aggregate function

23. 

With SQL, how do you select all the columns from a table named "Employees"?

24. 

Which SQL keyword you use to merge two tables based on a matching column?

25. 

What does SQL stand for?

26. 

Which SQL statement is used to modify the existing records in a table?

27. 

Which SQL statement is used to delete complete data from an existing table?

28. 

Which of the following is not a RDBMS?

29. 

Which statement is correct

30. 

The UNION operator is used to

clock.png

Time is Up!

clock.png

Time's up

ABOUT STM

We provide a diverse range of courses, tutorials, interview questions, resume formats to help individuals get started with their professional careers.

FOLLOW US ON

Facebook Twitter Linkedin YouTube

NAVIGATION

About Us
Contact Us
Privacy Policy
Terms of Use
Disclaimer
Guest Post
Sitemap
Free Testing Resources

© 2023 Software Testing Material • All Rights Reserved.

Scroll to top
  • Blog
  • Tutorials
    • Manual Testing
    • Selenium
    • TestNG
    • Maven
    • Jenkins
    • Framework
    • Java
    • Agile
    • API Testing
    • Postman
    • SQL
    • VBScript
  • Tools
    • PractiTest
    • Qase
    • WebLoad
    • ActiveBatch
    • Kobiton
    • Testiny
  • Interview Q&A
    • Selenium
    • Manual Testing
    • TestNG
    • Java
    • Python
    • SQL
    • Explain Framework
  • Free Resources
  • Quiz
    • Selenium Quiz
    • ISTQB Quiz
    • Java Quiz
    • SQL Quiz
Search