Q1. Define Data Abstraction and Instance.
Q2. Define : i) Candidate key ii) Primary key.
Q3. State any two advantages of DBMS.
Q4. Define Normalization. Enlist its types.
Q5. Write syntax for creating and Renaming a table.
Q6. Write syntax for creating and dropping views
Q7.Write down any four Dr. E.F Codd's rules.
Q8. List disadvantages of typical file processing system.
Q9. State the use of group by and order by clauses.
Q10. Describe commit and rollback with syntax and example
Q11. Draw the overall architecture of DBMS. Explain storage
manager and query processor components.
Q12. Enlist any four aggregate functions.
Q13. Explain Cursor. List the two types of cursor.
Q14. Enlist arithmetic and logical SQL operators.
Q15. Explain three level architecture of Database system.
Q16. Write SQL queries for following: i) Create table student with
following attributes using suitable data types.. Roll no., as
primary key, name, marks as not null and city. ii) Add column
Date of Birth in above student table. iii) Increase the size of
attribute name by 10 in above student table. iv) Change name of
Student table to stud.
Q17.Write and Explain the syntax for creating and dropping
indexes with an example.
Q18. Write a PL/SQL code to print reverse of a number.
Q19.Distinguish between network model and hierarchical
model.
Q20. Describe exception handling in brief.
Q21. Explain joins in SQL with examples.
Q22. Explain function in PL/SQL with example.
Q23. Explain ACID properties of transaction.
Q24. Describe any four responsibilities of Database
administrator.
Q25. Write and Explain the syntax for creating database trigger.
Q26. Explain Database Recovery techniques in detail.
Q27. Write the SQL queries for following EMP table. Emp
(empno, deptno, ename, salary, designation, city.) i) Display
average salary of all employees. ii) Display names of employees
who stay in Mumbai or Pune. iii) Set the salary of employee
'Ramesh' to 50000. iv)Display names of employees whose
salaries are less than 50000. v) Remove the Record of employees
whose deptno is 10. vi) Remove the column deptno from EMP
table.
Q28. Write and Explain the syntax for creating, Altering and
dropping the sequence.
Q29. Explain View and its type?
Q30. Explain Index and its type with example?
