Q1: Which SQL statement is used to retrieve data from a database?
Q2: Which SQL keyword is used to sort the result-set?
Q3: Which SQL keyword is used to filter the result-set?
Q4: Which SQL operator is used to test for NULL values?
Q5: Which SQL keyword is used to remove duplicate rows from a result-set?
Q6: What does ACID stand for in database transactions?
Q7: Which SQL command is used to add a new column to a table?
Q8: Which SQL command is used to modify existing data in a table?
Q9: Which type of join returns all rows from the left table, and the matching rows from the right table?
Q10: Which SQL keyword is used to group rows with the same value in a column?
Q11: Which SQL function is used to count the number of rows in a table?
Q12: Which SQL function is used to calculate the average of a set of values?
Q13: Which SQL function returns the highest value in a column?
Q14: What is the purpose of a primary key?
Q15: What is the purpose of a foreign key?
Q16: Which SQL statement is used to create a new table?
Q17: Which SQL statement is used to delete a table?
Q18: What does SQL stand for?
Q19: Which clause is used with GROUP BY to filter groups based on a condition?
Q20: Which command is used to grant permissions to a user?
Q21: Which command is used to revoke permissions from a user?
Q22: What is a subquery?
Q23: What is the purpose of the `JOIN` operation?
Q24: What is an index in SQL?
Q25: Which keyword is used to define a default value for a column?
Q26: Which data type is used to store dates?
Q27: What is a stored procedure?
Q28: What is a trigger?
Q29: What is a view?
Q30: What is normalization in SQL?
Your Score: 0 / 30
How many correct answers out of total questions.comment in the below comment section.
