SQL statements 1

In the SQL SELECT statement below which keyword is responsible for selecting all records starting with a:

Select * from studtb WHERE surname LIKE 'a%';

• SELECT

• LIKE

• WHERE

• FROM

• studtb

In the SQL SELECT statement below which keyword is responsible for filtering records by surname

Select * from studtb WHERE surname LIKE 'a%';

• SELECT

• LIKE

• WHERE

• FROM

• studtb

In the SQL SELECT statement below which keyword is responsible for specifying the source of the data

Select * from studtb WHERE surname LIKE 'a%';

• SELECT

• LIKE

• WHERE

• FROM

• studtb

In the SQL SELECT statement below which what is the table name?

Select * from studtb WHERE surname LIKE 'a%';

• SELECT

• LIKE

• WHERE

• FROM

• studtb

In the SQL SELECT statement below what keyword is used to choose all records / specific records in the database?

Select * from studtb WHERE surname LIKE 'a%';

• SELECT

• LIKE

• WHERE

• FROM

• studtb

What keyword is responsible for allowing records within a specific range to be selected?
SELECT * FROM Students

WHERE Age BETWEEN 22 AND 25;

• BETWEEN

• AND

• Students

• Age

• 22, 25

What keyword / operator is responsible for returning records only if both conditions are TRUE?
SELECT * FROM Students

WHERE Age BETWEEN 22 AND 25;

• BETWEEN

• AND

• Students

• Age

• 22, 25

What is the table name from the statement below?
SELECT * FROM Students

WHERE Age BETWEEN 22 AND 25;

• BETWEEN

• AND

• Students

• Age

• 22, 25

What is the column name from the statement below?
SELECT * FROM Students

WHERE Age BETWEEN 22 AND 25;

• BETWEEN

• AND

• Students

• Age

• 22, 25

What is the value range from the statement below?
SELECT * FROM Students

WHERE Age BETWEEN 22 AND 25;

• BETWEEN

• AND

• Students

• Age

• 22, 25