MCQs > IT & Programming > SQL MCQs > General MCQs

General MCQ for SQL

1. Choose correct clause: SELECT CountryCode, COUNT(*) FROM City GROUP BY CountryCode _____ COUNT(*) > 20;

2. What syntax would you use to write a query to select all teams that won either 2, 4, 6 or 8 games?

3. Which of the following is NOT a valid aggregate function?

4. The command to remove rows from a table 'CUSTOMER' is:

5. Which statement about non-clustered index is true?

6. With SQL, how do you select all the records from a table named "Companys" where the value of the column "Name" ends with an "d"?

7. How many types of indexes?

8. After describing the EMPLOYEES table, you discover that the SALARY column has a data type of NUMBER(8,2). Which SALARY value(s) will not be permitted in this column?

SQL MCQs | Topic-wise

MCQ on Basic SQL General SQL MCQs
Buy us a coffee
SQL Subjects
Basic SQL MCQs
More Resources
SQL Skill Assessment
SQL PDF
Related MCQs
Swift
Symfony2
System Analysis
System Programming
TCP/IP
search
Buy us a coffee
SQL Subjects
Basic SQL MCQs
More Resources
SQL MCQ
SQL Skill Assessment
SQL PDF
Related MCQs
Swift
Symfony2
System Analysis
System Programming
TCP/IP
Logo

Join our newsletter for the latest updates.

play store app store
Coming Soon

Our Products

Skill Assessment
Categories
MCQs
PDFs
Buy us a coffee

Company

About
Advertising
Privacy Policy
Terms & Conditions
Sitemap
Contact
Blog
Back to top back to top
Logo
play store app store
Coming Soon
Buy us a coffee

© Copyrights 2025 Quizack.com