Database (DBMS) - MCQ Practice Questions

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

What does the WHERE clause do in SQL?

Which keyword is used to eliminate duplicate rows in SQL results?

What is the correct syntax for inserting data into a table?

Which SQL aggregate function returns the total sum of a numeric column?

What will be the output of: SELECT COUNT(*) FROM employees;

Which statement is used to modify existing data in a table?

In SQL, which clause is used to filter groups based on aggregate function results?

Which data type in SQL is used to store large text documents or binary data?

What is the purpose of the DISTINCT keyword in SQL?

Which SQL JOIN returns only matching rows from both tables?

What will be the result of: SELECT 10 % 3; in SQL?

What is the result of: SELECT CASE WHEN 1=1 THEN 'A' WHEN 2=2 THEN 'B' ELSE 'C' END;?

Which SQL command is used to remove all records from a table without removing the table structure?

In a student enrollment database, you need to find students enrolled in multiple courses. Which JOIN type should be used to match course_id from enrollment table with course table?

What is the default sort order for ORDER BY clause in SQL?

Which aggregate function ignores NULL values in SQL?

Which SQL statement is used to add a new column to existing table?

Which feature of SQL allows preventing duplicate values in a column?