1. Write the name any five DBMS that are based on Hierarchical Data Model.

2. Write the name any five DBMS that are based on Network Data Model.
3. Write the name any Ten DBMS that are based on Relational Data Model. Also write the name
of the companies who are the owner that DBMS.
4. Write the name any five DBMS that are based on Object-Oriented Data Model.
5. Write the name any five DBMS that are based on Object-Relational Data Model.
6. What is Referential Integrity Constraint? Who it can be practically implemented using SQL?
Explain with an example.
7. What is the use of On delete cascade and on update cascade? Explain with example.
8. What is the difference between char, varchar & number? Which is faster and which is
memory efficient.
9. How Roll Back and Save point command can be practically implemented in SQL.
10. What is the difference between delete, drop & Truncate command? Explain with example.
11. Write the command in SQL to add a new column in an existing table.
12. Write the command in SQL to delete column from an existing table.
13. Write the command in SQL to change the name of a column in an existing table.

14. Write the command in SQL to change data type and size of a column in an existing table.
15. What is the use of Referential Integrity Constraint? Explain with example.
16. Write commands in SQL to Create fallowing tables and also write commands
in SQL to perform fallowing Queries.
Employee Table
EMP_ ADDR
EMP_NAME DESIGNATION DOJ SALARY DEPT_NO
NO

1001 Amy Officer 21-Dec-1995 1000 10 Mathura

1002 Fay Clerk 14-May-1982 500 20 Delhi

1003 Ray Manager 23-Dec-1984 3500 30 Bombay

1004 James Analyst 22-Jul-1990 5000 30 Mathura

1005 Amy Analyst 22-Jul-1990 4900 50 Delhi

1006 Jones Clerk 16-Apr-1986 950 40 Delhi

1007 Narayan Manager 06-Aug-1995 1001 40 Delhi

1008 Samarth Clerk 31-Jul-1999 500 30 Mathura

Department Table
DEPT DEPT DEPT_LOC

NO NAME

10 MARKETIN LONDON
G

20 ACCOUNTS AMERICA

30 SALES NEWYORK

40 SOFTWARE BOSTON

50 PRODUCTI BOSTON
ON

ALLOWANCE TABLE

DESIG SP_AALO CONVEYANCE

Manager 1000 500

Officer 800 400

Analyst 1200 500

Clerk 500 300

1. List the employees who are not live in Delhi.

2. List names of all employees whose designation is 'Analyst’.
3. Display the description of the EMP table.
4. Display the details of all employees.
5. Display unique Jobs from EMP table.
6. List the employee names those are having three characters in their Names.
7. List the employee names those are starting with ‘J’ and with five characters.
8. List the emp. names those are having Seven character and fifth char. must be ‘y’.
9. List the employee names ending with ‘y’.
10. List the employees in the order of their Salaries.
11. List the details of the employees in order of the ascending of Deptno and
descending of Jobs.
12. List the names of employees who work in either ‘officer’, ‘manager’ or ‘clerk’
position.
13. Delete all employees in the department no 20, delete the department no 20 from
department table as well.
14. Modify the salaries of all employees by giving 10% raise in their salaries.
15. Increment the salary of the employees by 1000 whose salary is less than 1000
and belong to dept no 30.
16. Delete the employees who are getting less than 1000 rupees.

17. Write the name any five DBMS that are based on Hierarchical Data Model.
18. Write the name any five DBMS that are based on Network Data Model.
19. Write the name any Ten DBMS that are based on Relational Data Model. Also write the name
of the companies who are the owner that DBMS.
20. Write the name any five DBMS that are based on Object-Oriented Data Model.
21. Write the name any five DBMS that are based on Object-Relational Data Model.
22. What is Referential Integrity Constraint? Who it can be practically implemented using SQL?
Explain with an example.
23. What is the use of On delete cascade and on update cascade? Explain with example.
24. What is the difference between char, varchar & number? Which is faster and which is
memory efficient.
25. How Roll Back and Save point command can be practically implemented in SQL.
26. What is the difference between delete, drop & Truncate command? Explain with example.
27. Write the command in SQL to add a new column in an existing table.
28. Write the command in SQL to delete column from an existing table.
29. Write the command in SQL to change the name of a column in an existing table.

30. Write the command in SQL to change data type and size of a column in an existing table.
31. What is the use of Referential Integrity Constraint? Explain with example.

32. Convert the above relational schema into tables with proper constraints that are required.
Employee
FName Minit LName SSN BDate Address Sex Salary SuperSSN DepNo

Department
DName DepNo MgrSSN MgrSDate

Dept_Locations
DepNo DLocation

Project

PName PNumber PLocation DepNo

Works_On

ESSN PNo Hours

Dependent

ESSN Dependent_Name Sex BDate Relationship