ASSIGNMENT ON SQL CLASS-12 CS

 

SQL COMMANDS

ASSIGNMENTS

1. What is MySQL?

2. How is a database related to a table ?

3. Write MySql command that will be used to open an already existing database “CONTACTS”.

4. Write a SQL command to view the constraints of EMP table.

5. Mentioned two categories in which MySQL commands are broadly classified?

6. Is NULL value the same as 0 (zero)? Write the reason for your answer.

7. Write the UPDATE command to increase the commission (column name :COMM) by 500 of all the salesman who have achieved sales (Column name : SALES) more than 200000. The table’s name is COMPANY.

8. Write one similarity and one difference between CHAR and VARCHAR data types.

9. In a hospital, the patients are allocated to wards. A database named ‘Hospital’ is created. One table in this database is: WARD with WardId, WardName, NumOfBeds as columns and WardId as the primary key. Write another suitable table you could expect to see in the ‘Hospital’  database, with 3 suitable columns identifying Primary key and Foreign key in the table that you expect.

10. Which clause should be used to arrange records in a specific order?