Skip to content

Database Management System

CSE · Quiz · Spring 26

Paper 4 of 8Batch 64Switch

Batch 64

Paper 4 of 8

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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