Database Management System
CSE · Quiz · Spring 26
Paper 4 of 8Batch 64Switch
Batch 64
Paper 4 of 8
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Daffodil International University
Faculty of Science & Information Technology
Department of Computer Science & Engineering
Quiz-01 Examination, Spring-2026
Course Code: CSE311, Course Title: Database Management System
Level: Term: Batch: 64
Time: 00:30 Mins
Marks: 15
Answer ALL Questions
[The figures in the right margin indicate the full marks and corresponding course outcomes. All portions of each question must be answered sequentially.]
1. a) What are the disadvantages of the conventional flat file system? Explain any five disadvantages briefly. | 3 | CO1
2. a) Table: Payments | 9 | CO2
PaymentID | CustomerID | AmountPaid | PaymentDate | Country
1 | C101 | 5000 | 2024-01-10 | Bangladesh
2 | C102 | 3000 | 2024-01-12 | India
3 | C101 | 2000 | 2024-01-15 | Bangladesh
4 | C103 | 7000 | 2024-01-18 | USA
5 | C104 | 4000 | 2024-01-20 | India
Write SQL query to create the above table and insert records.
Write an SQL query to calculate the total amount paid (SUM) by all customers.
Write an SQL query to display all information of customers who are from India.
Write an SQL query to find the average payment amount (AVG) made by customers.
Write an SQL query to find the highest and lowest payment amounts from the table.
Write an SQL query to display the total amount paid by each country using the GROUP BY clause.
3. a) Write down ACID properties in DBMS. | 3