We have compiled the NCERT MCQ Questions for Class 11 Accountancy Chapter 15 Accounting System Using Database Management System with Answers Pdf free download covering the entire syllabus. Practice MCQ Questions for Class 11 Accountancy with Answers on a daily basis and score well in exams. Refer to the Accounting System Using Database Management System Class 11 MCQs Questions with Answers here along with a detailed explanation.
Accounting System Using Database Management System Class 11 MCQs Questions with Answers
Fill in the blanks
Question 1.
A …………….. when appearing in another table, is known as ……………..
Answer
Answer: Primary key, Foreign key
Question 2.
A software using Database Management System without facility of ……………… is not complete.
Answer
Answer: Report generating
Question 3.
Tables can be created by using any of the three methods, namely ……………, ……………… and ……………….
Answer
Answer: Datasheet View, Table Wizard, Design View
Question 4.
…………….. query does not involve use of any query functions to produce a summary of data.
Answer
Answer: Simple
Question 5.
When saved as ………………… the contents of reports cannot be modified by the user.
Answer
Answer: Snapshots
Question 6.
The purpose of ………….. is to organise the information of report into categories whereas …………… average information into numerical or alphabetical order.
Answer
Answer: Sorting
Question 7.
…………….. clause is used to specify the field to display data or information.
Answer
Answer: SELECT
Question 8.
……………… query promotes the user to enter criteria for selecting a set of records.
Answer
Answer: Parameter
Question 9.
A unique identification given to an object is known as ………………….
Answer
Answer: Primary key
Question 10.
……………… are the reports that the system generates as programmed.
Answer
Answer: Programmed reports
State whether the following statements are True or False
Question 1.
The unique number given to an object is known as primary key.
Answer
Answer: True
Question 2.
In MS Access, forms are present and can also be designed according to the need.
Answer
Answer: True
Question 3.
A primary’ key appearing in another table is known as sub-primary key.
Answer
Answer: False
Question 4.
In MS Access, data entered can only be text data.
Answer
Answer: False
Question 5.
Select queries in Access help in generating information.
Answer
Answer: True
Question 6.
Every Accounting Report is prepared with a definite objective.
Answer
Answer: True
Question 7.
Ledger may be generated in Access by adhering to report generation process.
Answer
Answer: True
Question 8.
The forms created with wizard have unlimited visual appeal.
Answer
Answer: False
Question 9.
Enforcing data integrity constraints is not the capability of MS Access.
Answer
Answer: False
Question 10.
Domain integrity is implemented in Access by setting the properties of fields in the table.
Answer
Answer: True
Answer in one word / sentence:
Question 1.
Which item purpose is to organize the record data into categories?
Answer
Answer: Sorting Data
Question 2.
Which item purpose is to organize the record data into categories?
Answer
Answer: Card Sorting
Question 3.
Which content of statements once recorded cannot be changed by the individuals?
Answer
Answer: Snapshot
Question 4.
State few capabilities of MS Access.
Answer
Answer: The few capabilities of MS Access are.
1. It helps in storing data in an organized way
2. Supports various views of data and information
3. Provides data sharing and different user transaction processing.
Question 5.
Mention steps that are required to create a new database in Access.
Answer
Answer: The steps that are required to create a new database in Access are.
1. First, open the access window. Choose blank access database, and click OK button.
2. Click the displayed new file database dialogue box, this will enable the user to enter the file name and set a location for the database. Now click Create button.
3. If the task pane does not open, you can choose the file from the menu bar and click open to open a task pane and create a new database.
Question 6.
The need for which report is not anticipated?
Answer
Answer: Casual
Question 7.
Name the query that does not include the use of any inquiry function to generate a summary of data.
Answer
Answer: Simple query
Question 8.
Which query indicates an individual to access criteria for picking a collection of records.
Answer
Answer: Parameter
Question 9.
Which clause is applied to designate the fields to represent data or information?
Answer
Answer: SELECT
Question 10.
Which item is determined to add a page number, date and time of the report?
Answer
Answer: Design View
Hope the information shed above regarding NCERT MCQ Questions for Class 11 Accountancy Chapter 15 Accounting System Using Database Management System with Answers Pdf free download has been useful to an extent. If you have any other queries of CBSE Class 11 Accountancy Accounting System Using Database Management System MCQs Multiple Choice Questions with Answers, feel free to reach us so that we can revert back to us at the earliest possible.