Database Management System — Practice Quiz
NIOS · Class 12 · Accountancy
4 MCQs on Database Management System for NIOS Class 12 Accountancy: tap an answer to check it and see why. The full chapter test has 112 questions.
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 practice quiz and more.
Free trial, no card needed.
Quick Quiz: Database Management System
0/4Tap an answer to check it instantly. No sign-up needed for these 4.
A supplier has total purchase amount of ₹18,500 and total amount paid of ₹11,250. What is the outstanding amount?
Supplier_Mst shows Tot_Pur_Amt of ₹42,000 and Tot_Amt_Paid of ₹27,500. If a new purchase bill of ₹6,500 is added, what will the updated outstanding amount be after the bill is entered?
Supplier_Mst shows Tot_Pur_Amt of ₹57,000 and Tot_Amt_Paid of ₹39,200. If a new payment of ₹8,300 is recorded, what is the updated outstanding amount?
A business records a purchase bill of ₹12,450 for a supplier whose previous Tot_Pur_Amt was ₹38,750. What will the updated Tot_Pur_Amt become?
Sample Questions
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 practice questions are there for 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
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
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.