SQL 2

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

Drag the options into the correct boxes to complete the query

To display the detail of employee having "e" in their name in descending order of salary

SELECT * ​ (a)   emp ​ (b)   ename ​ (c)   %e%" ​ (d)   SAL ​ (e)   ;

• FROM
• WHERE
• LIKE "
• ORDER BY
• DESC

Which of the following queries is valid

• SELECT name, course_name FROM student WHERE age>50 and <80;   

• SELECT name, course_name FROM student WHERE age>50 and age <80;

• SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

• None of these

In an SQL SELECT statement querying a single table, the asterisk (*) means that:

• All records are to be returned.

• None the options is correct.

• All fields of the table are to be returned

• All records meeting the full criteria are to be returned.

How do we select all rows for the "Designer" table?

• SELECT * FROM Designer

• SELECT [All] FROM Designer

• SELECT Designer.*

• SELECT FROM Designer

How would we script a SQL query to select "Description" from the Item table?

• SELECT Item.Description

• EXTRACT Description FROM Item

• SELECT Item FROM Description

• SELECT Description FROM Item

Which query would return only the fields DesignerID and Designer?

• SELECT * FROM Designers

• SELECT DesignerID, Name FROM Designers

• SELECT DesignerID AND Designer FROM Designers

• SELECT DesignerID, Designer FROM Designers

How would you display Chairs in the Items table that have a Price greater than £50.

• SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

• SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

• SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

• SELECT * FROM Items WHERE Price > 50

Match the following SQL term with a description - SELECT

• The fields to display

• The table used in the query

• The criteria which must be met

• The field and order used to sort the results

Match the following SQL term with a description - WHERE

• The table used in the query

• The fields to display

• The field and order used to sort the results

• The criteria which must be set