SQL

The SQL WHERE clause:

• limits the column data that are returned.

• limits the row data that are returned.

• Both A and B are correct

• Neither A nor B is correct

The ……………. key word eliminates duplicate rows from the result of a SELECT statement. 

(a)  

Arrange the order of clauses in the select statement

• HAVING

• ORDER BY

• GROUP BY

• FROM

• WHERE

Match the following

• Will not allow duplicate

• Delete

• Restrict the output after grouping

• Distinct

• Remove specific rows

• Check

• Eliminate duplicate values

• Unique

• Used to limit column values to specific values

• Having

Drag the correct option into the correct box

SELECT ​ ​ (a)   ​ (b)   users ​ (c)   ​ (d)   ='user1';

• password
• from
• where
• username

The command to remove rows from a table 'CUSTOMER' is:

• REMOVE FROM CUSTOMER ...

• DROP FROM CUSTOMER ...

• DELETE FROM CUSTOMER WHERE ...

• UPDATE FROM CUSTOMER ...

How can you change 'Thomas' to 'Michael' in the LastName column in the user table

• UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

• MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

• MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

• UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

Complete the query by drag the correct option into the correct boxes.

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

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

• FROM
• WHERE
• ORDER BY
• DESC

Match the following

• UPDATE

• DDL

• ROLLBACK

• DCL

• GRANT

• TCL

• ALTER

• DML

Reorder the following

Order of keywords for SQL SELECT statements?

• SELECT

• ORDER BY

• FROM

• WHERE

• GROUP B Y