Skip to main content
Chapter 38 of 38
Practice Quiz

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.

112 questions32 flashcards5 concepts

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/4

Tap an answer to check it instantly. No sign-up needed for these 4.

1

A supplier has total purchase amount of ₹18,500 and total amount paid of ₹11,250. What is the outstanding amount?

2

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?

3

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?

4

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?

112 Questions·
multiple choicemultiple correct

Sample Questions

1multiple choice
3 marks

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.

2multiple choice
3 marks

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.

3multiple choice
3 marks

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.

4multiple choice
3 marks

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 All

Frequently Asked Questions

What are the important topics in Database Management System for NIOS Class 12 Accountancy?
Key topics in Database Management System include Database and DBMS Basics, Structure Design of Database, Account Classification and Coding Scheme, Accounts Table and Account Type Table. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How many practice questions are there for Database Management System?
There are 112 questions on Database Management System. Try the 4-question sample quiz on this page first; each answer shows an explanation when you tap it.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

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.