Quiz Home
Mysql Quiz
1: What does SQL stand for?
  Structured Query Language
  Simple Query Language
  Server Query Language
  Standard Query Language



2: What is the purpose of the SELECT statement in SQL?
  To update data in a database
  To delete records from a table
  To retrieve data from a database
  To insert data into a table



3: Which SQL command is used to retrieve all records from a table?
  SELECT * FROM table_name
  RETRIEVE FROM table_name
  GET ALL table_name
  FETCH * FROM table_name



4: What is a primary key in a database table?
  A key used for encryption
  A key used to access a database
  A unique identifier for a record in a table
  A foreign key



5: What is the purpose of the WHERE clause in an SQL query?
  To specify which columns to retrieve
  To filter records based on a condition
  To order the results
  To join multiple tables



6: Which SQL command is used to update data in a database?
  MODIFY
  ALTER
  UPDATE
  MODIFY TABLE



7: What is the purpose of the ORDER BY clause in SQL?
  To filter records
  To group records
  To sort records in ascending or descending order
  To limit the number of records



8: What is a foreign key in a database table?
  A key used for encryption
  A key used to access a database
  A key that references another table's primary key
  A primary key



9: Which SQL command is used to delete records from a table?
  DELETE
  REMOVE
  ERASE
  DISCARD



10: What is the purpose of the GROUP BY clause in SQL?
  To order records
  To filter records
  To group records based on a column
  To join multiple tables