SQL

A visually appealing graphic depicting elements of a database, SQL code snippets, and a computer screen showing a SQL query interface.

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

10 Questions2 MinutesCreated by LearningCoder42

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 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'

Master SQL: Test Your Knowledge!

More Quizzes