LearnPythonDjango.com
Home
Tutorials
Courses
Quiz
Blog
Demo
About
Contact Us
Login
Register
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