Scribd
Upload
12 views1 page

DBE QB-Final

The document is a question bank covering various topics in database management, including schema vs. instance, relational algebra, database architecture, indexing methods, normalization, SQL joins, triggers, and ACID properties. It also includes practical SQL queries and PL/SQL examples, as well as discussions on database failures, deadlock handling, and user roles. Each question aims to test the understanding of fundamental database concepts and their applications.

Uploaded by

devab52664
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views1 page

DBE QB-Final

The document is a question bank covering various topics in database management, including schema vs. instance, relational algebra, database architecture, indexing methods, normalization, SQL joins, triggers, and ACID properties. It also includes practical SQL queries and PL/SQL examples, as well as discussions on database failures, deadlock handling, and user roles. Each question aims to test the understanding of fundamental database concepts and their applications.

Uploaded by

devab52664
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

DBE Question Bank

1. Differentiate between schema and instance in the context of a relational database.


2. Explain the concept of relational algebra and provide example queries.
3. Explain the purpose of database systems and the different views of data.
4. Discuss the architecture of a database system and its components.
5. Write in detail about Hash based Indexing and Tree based Indexing?
6. What are Views and Materialized Views in SQL? Give an example of each. Differentiate
between them.
7. Define normalization? Explain 1NF, 2NF, 3NF Normal forms?
8. What is a Join? Discuss about various joins used in SQL with example.
9. Discuss two phase locking protocol and strict two phase locking protocol?
10. What is a trigger? Explain the types of triggers in PL/SQL with syntax and examples.
11. Explain PLSQL stored procedures with examples.
12. Define the following terms.
i) Functional Dependency ii) Data Dictionary iii) Data redundancy
13. Explain ACID properties and illustrate them through examples?
14. Discuss various types of failure that may occur in a system.
15. Discuss temporal functional dependencies with examples.
16. Explain the concept of serializability and how it is tested.
17. Describe deadlock handling techniques in databases.
18. Given a 'Students' table with attributes (StudentID, Name, Age, Department), write an SQL
query to find the average age of students in each department.
19. Write an SQL query to retrieve the names of employees who earn more than the average
salary in the 'Employees' table (attributes: EmployeeID, Name, Salary, Department).
20. Write an SQL query to display the total number of orders placed by each customer from an
'Orders' table (attributes: OrderID, CustomerID, OrderDate).
21. Given a 'Products' table (ProductID, ProductName, Category, Price), write an SQL query to
find the most expensive product in each category.
22. Write a PLSQL block to update the salary of employees in the 'Employees' table by 10% if
their current salary is less than 30,000.
23. Write short notes on:
(a) Database Users and Administrators
(b) E-R Model Generalization
(c) Schema-Instance Distinction
(d) Join Dependencies and 5NF
(e) Hash Indices
(f) Validation-Based Protocols
(g) Multiple Granularities
(h) Checkpoints in Database Recovery
(i) Stable Storage Implementation

You might also like