Skip to main content

Posts

Showing posts with the label 10 SQL Multiple Choice Questions (MCQs)

10 SQL Multiple Choice Questions (MCQs)

10 SQL Multiple Choice Questions (MCQs)  1. Which SQL statement is used to retrieve data from a database? A. GET B. SELECT C. FETCH D. READ ✅ Answer: B. SELECT 2. What does the WHERE clause do in SQL? A. Groups records B. Filters records C. Sorts records D. Deletes records ✅ Answer: B. Filters records 3. Which SQL function is used to count the number of rows? A. COUNT() B. SUM() C. TOTAL() D. LENGTH() ✅ Answer: A. COUNT() 4. Which keyword is used to sort the result-set in SQL? A. ORDER B. GROUP C. SORT D. ORDER BY ✅ Answer: D. ORDER BY 5. What is the default sorting order of ORDER BY clause? A. Random B. Descending C. Ascending D. Alphabetical ✅ Answer: C. Ascending 6. What does the SQL JOIN clause do? A. Combines rows from multiple tables B. Deletes rows from a table C. Finds duplicates D. Creates new tables ✅ Answer: A. Combines rows from multiple tables 7. Which JOIN returns only the matching rows from both tables? A. LEFT JOIN B...