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?
