vkl SQL Basics Quiz

A is a subset of DML that just deals with information retrieval.

• Query Language

• Structure Language

• Both a) and b)

• None of the above

A is a language that enables users to access and manipulate data in a database.

• Data Manipulation Language (DML)

• Data Definition Language (DDL)

• Both a) and b)

• None of the above

What SQL clause is used to specify the columns you want to retrieve from a table?

• SELECT

• FROM

• WHERE

• INSERT

Which SQL clause specifies the table from which data should be retrieved?

• SELECT

• FROM

• WHERE

• UPDATE

What SQL operator is used for exact value matching in a WHERE clause?

• LIKE

• BETWEEN

• =

• AND

Which SQL operator is used to check if a column value falls within a specified range?

• LIKE

• BETWEEN

• =

• AND

What is the purpose of the IS NULL operator in SQL?

• It checks if a column contains a specific value.

• It checks if a column is empty.

• It checks if a column is not empty.

• It checks if a column exists.

Which logical operator combines multiple conditions in a WHERE clause with an OR relationship?

• AND

• OR

• NOT

• XOR

What SQL statement is used to add new records to a database table?

• INSERT

• DELETE

• UPDATE

• ALTER

Which SQL clause is used to delete records from a database table?

• INSERT

• DELETE

• UPDATE

• ALTER