Order PDF of any content from our website with a little minor Fee to donate for hard work. Online MCQs are fully free but PDF books are paid. For details: contact whatsapp +923028700085 Important notes based PDF Books are available in very little price, starting from 500/-PKR; Order Now: contact whatsapp +923028700085

NSCT – Structured Query Language (SQL) MCQs

20 min Score: 0 Attempted: 0/20 Subscribe
1. . SQL stands for:





2. . Which SQL command is used to retrieve data from a database?





3. . To add a new row in a table, which SQL command is used?





4. . Which SQL command is used to modify existing data in a table?





5. . To remove rows from a table, which SQL command is used?





6. . The SQL command to permanently remove a table is:





7. . TRUNCATE TABLE is used to:





8. . Which clause is used in SQL to filter records based on a condition?





9. . The ORDER BY clause is used to:





10. . GROUP BY in SQL is used to:





11. . HAVING clause in SQL is used to:





12. . The SQL keyword DISTINCT is used to:





13. . Which SQL function returns the number of rows?





14. . Which SQL function returns the highest value in a column?





15. . Which SQL function returns the average of a column?





16. . To combine rows from two or more tables based on a related column, which SQL clause is used?





17. . INNER JOIN returns:





18. . LEFT JOIN returns:





19. . UNION in SQL is used to:





20. . The main purpose of SQL is to:





Contents Copyrights Reserved By T4Tutorials