19-01-2016, 02:58 PM
Shri G. S. Institute of Technology and Science, Indore
Department of Computer Engineering
B. E. [3rd Year ]
CO3405: Database Management System
Lab Assignment # 1(part 1)
1. Insert 10 rows in the table where client_no start from c0001 upto c0010.
2. Find out the name of all the clients.
3. Retrieve the entire contents of the CLIENT_MASTER.
4. Retrieve the list of names & the cities of all the clients.
5. Retrieve distinct city from CLIENT_MASTER.
6. List all the clients who are located in "mumbai" or “pune” or “banglore”.
7. Retrieve the name of clients who are located in “mumbai” and salary is greater than 30,000.
8. List all the clients who are not located in "indore" or “hydb”.
9. List the name of all clients having ‘a’ as the second letter in their name.
10. List the name of all clients having ‘b’ as the last letter in their name.
11. Find the name of client whose salary is greater than 30,000 and less than or equal to 50,000.
12. Remove all the records from CLIENT_MASTER where city is "jamshedpur".
13. Delete all the records having joining date before 25th august 2010.
14. Update joining_date column to 10th september 1991.
15. Update (change)the city of client_no '0005' to "ranchi"
16. Change the name of CLIENT_MASTER table to emp_master.
17. Rename the column name “client_no” to “client_id”.
18. Delete the column “address2” from CLIENT_MASTER.
19. Add column called "phone_no" of data type number and size='10' to CLIENT_MASTER table
20. Modify the size of “name” column upto 40.
21. Truncate table CLIENT_MASTER
22. Drop the table CLIENT_MASTER