sql practice questions - Quiz Questions (Page 1 of 2)
This quiz contains 20 questions.
Question 1: What does SQL stand for?
- Structured Query Language (Correct Answer)
- Simple Query Language
- Sequential Query Language
- Standard Query Language
Question 2: Which keyword is used to remove duplicates?
- DELETE
- DISTINCT (Correct Answer)
- UNIQUE
- ERASE
Question 3: How do you select all columns from a table?
- SELECT * FROM table_name (Correct Answer)
- SELECT all FROM table_name
- GET all FROM table_name
- VIEW * FROM table_name
Question 4: Which SQL clause is used to filter records?
- ORDER BY
- GROUP BY
- WHERE (Correct Answer)
- SELECT
Question 5: How do you rename a column in SQL?
- ALTER COLUMN name TO new_name
- MODIFY COLUMN name TO new_name
- RENAME COLUMN name TO new_name (Correct Answer)
- CHANGE COLUMN name TO new_name
Question 6: What is a primary key?
- A unique identifier for a record (Correct Answer)
- A command to update data
- A query to sort data
- A foreign key relation
Question 7: Which function calculates the mean in SQL?
- MEDIAN()
- SUM()
- AVG() (Correct Answer)
- MEAN()
Question 8: How do you add a new column to a table?
- MODIFY TABLE ADD column_name
- ALTER TABLE ADD column_name (Correct Answer)
- CREATE COLUMN column_name
- INSERT COLUMN column_name
Question 9: What command is used to remove a table?
- DELETE TABLE table_name
- DROP TABLE table_name (Correct Answer)
- REMOVE TABLE table_name
- TRUNCATE TABLE table_name
Question 10: How do you retrieve unique records?
- SELECT UNIQUE column FROM table_name
- SELECT DIFFERENT column FROM table_name
- SELECT DISTINCT column FROM table_name (Correct Answer)
- SELECT VARIED column FROM table_name
Test your SQL skills with this quiz made for everyone, from beginners to experienced users. The questions range from writing basic queries to handling advanced database design and schema management. Practice how to manipulate data and build strong databases in a simple and friendly way. This quiz is perfect for anyone in India looking to improve their SQL abilities for jobs in database management and analytics.
