Database Management System — Important Questions
NIOS · Class 12 · Accountancy
112 important questions from Database Management System for NIOS Class 12 Accountancy, with answers. Written for the board exams 2027.
Interactive on Super Tutor
Studying Database Management System? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for important questions and more.
Free trial, no card needed.
Important Questions from Database Management System
A supplier has previous Tot_Amt_Paid of ₹29,600. A payment voucher of ₹6,850 is entered. What is the updated Tot_Amt_Paid?
Show answer
₹36,450
Use the formula Update Tot_Amt_Paid = previous Tot_Amt_Paid + current Amt_Paid. So, ₹29,600 + ₹6,850 = ₹36,450.
Supplier_Mst has Tot_Pur_Amt of ₹85,000 and Tot_Amt_Paid of ₹63,250. If a new bill of ₹9,750 and a new payment of ₹4,500 are both entered, what is the final outstanding amount?
Show answer
₹27,000
First update Tot_Pur_Amt: ₹85,000 + ₹9,750 = ₹94,750. Then update Tot_Amt_Paid: ₹63,250 + ₹4,500 = ₹67,750. Outstanding amount = ₹94,750 - ₹67,750 = ₹27,000.
The Vouchers Table records one transaction with Amount ₹24,800. If the same account is first entered as a debit of ₹24,800 and later another voucher adds ₹15,200 to the same debit account, what is the total debit amount recorded for that account?
Show answer
₹40,000
Add the two debit entries: ₹24,800 + ₹15,200 = ₹40,000.
An account coding scheme uses 4-digit codes. If a current asset account is assigned code 3215 for Cash and the next code gap left for Bank is 3216, what is the numerical difference between these two codes?
Show answer
1
Subtract the codes: 3216 - 3215 = 1.
+108 more questions on Database Management System (NIOS Class 12 Accountancy)
Practise AllFrequently Asked Questions
What are the important topics in Database Management System for NIOS Class 12 Accountancy?
How many important questions are there in Database Management System?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Database Management System
For serious students
Get the full Database Management System chapter — start free.
Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.