Tribhuvan University · BCA Semester IV
BCA 4th Semester Database Management System Past Questions
Tribhuvan University BCA Semester IV Database Management System past questions from 2020, 2021 and 2023, covering DBMS fundamentals, relational algebra, SQL, normalization, transactions, concurrency control, ER diagrams, indexing, query processing and database security.
Exam pattern: Group B asks students to attempt any six questions for 30 marks. Group C asks students to attempt any two questions for 20 marks. The page is designed to work inside your existing WordPress theme without replacing your GeneratePress menu or header.
Database Management System Past Questions 2020
CACS225 · Semester IV60 Marks · Pass 24 · 3 Hours
Group B
Attempt any SIX · 6 × 5 = 302. What is a database? Discuss the importance of DBMS. [1+4]
3. Define union compatibility. Given the Director and Actor relations, show the resulting relation of Director ∪ Actor and Actor ∩ Director. [2+3]
4. How are ORDER BY and GROUP BY HAVING clauses in SQL different? Illustrate with suitable examples. [3+2]
5. Why is normalization needed? When is a relation said to be in 1NF and 2NF? [1+4]
6. How is the cost of a query measured during query processing? Construct a query expression tree for the given relational algebra query. [3+2]
7. How is a wait-for graph constructed? How can you use it to detect deadlocks in a schedule of transactions? Support your answer with an example. [2+2+1]
8. How are read and write operations performed in a transaction? List the various states where transactions can enter. [3+2]
9. How are read and write operations performed in a transaction? List the various states where transactions can enter into. [3+2]
Group C
Attempt any TWO · 2 × 10 = 2010. Given the schema below, write relational algebra and SQL queries for the following: [10]
- Sailors(sid, sname, rating, age)
- Boats(bid, bname, colour)
- Reserves(sid, bid, reservedate)
- Find name, rating and age of all sailors.
- Find the name and color of boats having color blue.
- Find the name of boats reserved on 2021/07/20.
- Find names of boats and sailors who have reserved green boats.
- Use LEFT and RIGHT OUTER JOIN between Sailors and Reserves.
11. Design an ER diagram of your choice containing at least five entities, including one weak entity. Include appropriate attributes, a one-to-one relationship, a one-to-many relationship and a many-to-many relationship. Then convert the ER diagram into equivalent relational tables.
12. Define stored procedures and triggers. Explain their application in databases and illustrate how to create BEFORE and AFTER triggers on an INSERT query. [3+2+5]
Database Management System Past Questions 2021
CACS255 · Semester IV60 Marks · Pass 24 · 3 Hours
Group B
Attempt any SIX · 6 × 5 = 302. What is DBMS? Describe the advantages and disadvantages of using DBMS. [1+4]
3. Describe the three-schema architecture of a database. [5]
4. What are the roles and responsibilities of a DBA? [5]
5. Why is indexing essential in a database? Differentiate dense index from sparse index with a suitable example. [1+4]
6. What are the states of the transaction model? Describe the ACID properties of a transaction. [2+3]
7. Describe the use of an ER diagram. Draw an ER diagram for a university database. [5]
8. What are DDL and DML queries? Consider the Borrower and Loan relations and write a relational algebra expression to find all customers who took a loan from branch “B1”. [3+2]
Group C
Attempt any TWO · 2 × 10 = 209. Define normalization. Describe its importance in DBMS. Describe 1NF, 2NF and 3NF with examples. [2+2+6]
10. Differentiate between stored procedure and trigger. Why is concurrency control needed? Describe timestamp-based concurrency protocol. [2+2+6]
11. What is a data model? What are its types? Describe the structure of a database. [2+4+4]
Database Management System Past Questions 2023
CACS255 · Semester IV · Batch 202060 Marks · Pass 24 · 3 Hours
Group B
Attempt any SIX · 6 × 5 = 302. Define database and DBMS. Explain the benefits of DBMS in detail. [2+3]
3. What are the different SQL constraints to specify rules for data in a database? Explain. [5]
4. What is relational algebra? Explain different relational algebra operations. [1+4]
5. How is a candidate key different from a primary key? Also explain a foreign key in detail. [2+3]
6. What is a stored procedure? How can it be used in a database? Explain with an example. [2+3]
7. What are the main purposes of concurrency control? Explain the two-phase locking protocol in detail. [1+4]
8. What is database security? Describe the steps of query processing. [2+3]
Group C
Attempt any TWO · 2 × 10 = 209. What are full and partial functional dependencies? Explain 2NF and 3NF in detail. [4+6]
10. How can different join operations be performed? Explain with proper examples. Consider a shipment company database where shipped items are received at a single retail center and travel to their destination through one or more scheduled transportation events. Create an ER diagram to represent this information.
11. Consider the following tables:
- Book(BookID, Title, publisher, publishedDate, price)
- Book_Authors(BookID, Author_name)
- Borrower(CardNo, Name, Address, Contact)
- BookIssue(BookID, CardNo, IssuedDate, DueDate)
- Find the names of books taken by Ramesh Sharma.
- Find the issued book name and borrower’s name for the specified date conditions.
- Find the borrower’s name who has taken a book written by Laxmi Prashad Devkota.
- Find the number of books issued on 25 April 2023.
- Find the borrower who has taken a book having price more than the average price.
BCA 4th Semester DBMS Exam Preparation
Important recurring topics include DBMS fundamentals, three-schema architecture, relational algebra, SQL, keys and constraints, normalization, functional dependencies, ER diagrams, indexing, transactions, ACID properties, concurrency control, two-phase locking, timestamp protocols, stored procedures, triggers, query processing, database security and database design.
More eSikhcha resources: BCA 4th Semester Study Materials · BCA Study Materials · Tribhuvan University Resources.