Practice Questions

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

Practice Questions

Uploaded by

Copyright:

Available Formats

Practice Questions

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Practice Questions

Uploaded by

Copyright:

Available Formats

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

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

DESIG SP_AALO CONVEYANCE

Manager 1000 500

Officer 800 400

Analyst 1200 500

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

PName PNumber PLocation DepNo

ESSN PNo Hours

ESSN Dependent_Name Sex BDate Relationship

You might also like