SQL
Master SQL: Test Your Knowledge!
Welcome to the SQL Knowledge Quiz! This quiz is designed to challenge your understanding of SQL basics and syntax through a series of 10 engaging questions.
Perfect for beginners and seasoned developers alike, the quiz covers:
- Data extraction
- Updating records
- Inserting new records
- Basic SQL statements
Which SQL statement is used to extract data from a database?
1. EXTRACT
2. GET
3. SELECT
4. OPEN
Which SQL statement is used to update data in a database?
1. SAVE AS
2. UPDATE
3. MODIFY
4. SAVE
Which SQL statement is used to delete data from a database?
1. DELETE
2. REMOVE
Which SQL statement is used to insert new data in a database?
1. INSERT NEW
2. ADD RECORD
3. ADD NEW
4. INSERT INTO
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
EXTRACT FirstName FROM Persons
SELECT Persons.FirstName
SELECT FirstName FROM Persons
With SQL, how do you select all the columns from a table named "Persons"?
1. SELECT * FROM Persons
2. SELECT Persons
3. SELECT *.Persons
4. SELECT [all] FROM Persons
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
1. SELECT [all] FROM Persons WHERE FirstName='Peter'
2. SELECT * FROM Persons WHERE FirstName='Peter'
3. SELECT * FROM Persons WHERE FirstName<>'Peter'
4. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
1. SELECT * FROM Persons WHERE FirstName='%a%'
2. SELECT * FROM Persons WHERE FirstName LIKE '%a'
3. SELECT * FROM Persons WHERE FirstName LIKE 'a%'
4. SELECT * FROM Persons WHERE FirstName='a'
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
1. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
2. SELECT FirstName='Peter', LastName='Jackson' FROM Persons
3. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the SQL Knowledge Quiz! This quiz is designed to challenge your understanding of SQL basics and syntax through a series of 10 engaging questions.Perfect for beginners and seasoned developers alike, the quiz covers:Data extractionUpdating recordsInserting new recordsBasic SQL statements","img":"https:/images/course6.png"}