SQL Video Tutorial Quiz

What is the primary characteristic of SQL that differentiates it from procedural languages?

• It is a procedural language.

• It is a compiled language.

• It is a declarative language.

• It is an object-oriented language.

Which SQL command is used to retrieve data from a database?

• DELETE

• SELECT

• UPDATE

• INSERT

What does the wildcard '*' represent in an SQL SELECT statement?

• Selects fields with null values

• Selects a single field

• Selects all fields

• Selects no fields

In SQL, what does the 'LIKE' keyword do?

• It deletes records.

• It updates records.

• It matches a pattern in a field.

• It inserts new records.

Which SQL command is used to add new records to a table?

• JOIN

• DELETE

• SELECT

• INSERT INTO

What is the purpose of the SQL 'DELETE' command?

• To select records

• To update records

• To remove records

• To add new records

Which SQL command is used to modify existing records in a table?

• INSERT

• DELETE

• SELECT

• UPDATE

What is the function of the SQL 'JOIN' command?

• To combine data from multiple tables

• To delete tables

• To insert new records

• To update records

What does the SQL 'DROP TABLE' command do?

• Creates a new table

• Deletes a table and all its data

• Updates a table

• Selects data from a table

Which SQL command is used to create a new table?

• ALTER TABLE

• INSERT INTO

• DROP TABLE

• CREATE TABLE