Chapter 4: Structured Query Language(SQL)

This puzzle will test understanding regarding the concept in SQL statement in database.

			1				2
	3
4						5

6	7				8


		9


				10

Across

3. __________ command will delete row(s) of a table.

6. _________ STUDENT SET LastName=’Aiman’ WHERE LastName=’Arman’;. Complete the command to modify LastName from Arman to Aiman.

9. The _____________ qualifier must be included to remove duplicate rows from the results of an SQL SELECT statement.

10. _______ is a set of commands used to update and query a database.

Down

1. ORDER BY age DESC; will sort the age in _____________ sequence.

2. The CORRECT order of keywords for search in SQL SELECT statements is SELECT FROM _________.

4. ___________ function will calculate the amount of record available in the table.

5. __________ INTO stdinfo VALUES (“15”, “Perak”, 45, 5000);. Complete the command to add the record.

7. __________ command delete the structure and content (data) of the table.

8. SELECT MAX(salary) from EMPLOYEE will display ____________ salary from table EMPLOYEE.

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!