Important MCQ questions for Class 11 Accountancy Chapter 14-Structuring Database for Accounting
Get Important MCQ questions for Class 11 Accountancy Chapter 14-Structuring Database for Accounting with a detailed explanation of all the MCQ questions asked from Chapter 14-Structuring Database for Accounting prepared by the experts. Find below Selected MCQ-based questions Sets with Answer keys and detailed solutions for Chapter 14-Structuring Database for Accounting, to find the explanation click on the Answer.
MCQ Questions for Chapter 14-Structuring Database for Accounting class 11 Accountancy (Questions set-1)
Accounting - MCQ on Structuring database for accounting
Class XI
Q. 1. DBMS stands for:-
a. Dynamic basic management standards
b. Data base management system
c. Data base mining system
d. None
Answer:
(b)
Explanation:- Data base management system
Q. 2. Data processing involves the technique of:-
a. collecting
b. sorting
c. relating
d. all
Answer:
(d)
Explanation:- All are the techniques of data processing.
Q. 3.The necessary steps involved in data processing cycle are
a. data capturing
b. inputting
c. processing
d. all
Answer:
(d)
Explanation:- All are the steps of data processing cycle
Q. 4. The first step is to capture accounting data from:-
a. source documents
b. input of data
c. data storage
d. data
Answer:
(a)
Explanation:- Source documents are vouchers or initial documents to record the transactions.
Q. 5.A pre-designed data entry form used for:-
a. source documents
b. input of data
c. data storage
d. data
Answer:
(b)
Explanation:- Use to input data
Q. 6.the stores data is manipulated for necessary transformation to generate:-
a. final report
b. interpretation
c. summary
d. none
Answer:
(a)
Explanation: Final report
Q. 7. It reflect to some aspect of real world situation, for which database is to be designed:-
a. Reality
b. Flow chart
c. Relational
d. None
Answer:
(a)
Explanation:- Reality
Q. 8.The formal blue print with a pictorial presentation:-
a. reality
b. Relational data model
c. ER Design
d. None
Answer:
(c)
Explanation:- ER Design(Entity relationship model)
Q. 9._________ model concepts are used to represent description of reality
a. reality
b. Relational data model
c. ER Design
d. None
Answer:
(c)
Explanation:- ER Design
Q. 10. Under _______ the restriction in the form of rules are specified to ensure the consistency and integrity of stored data.
a. reality
b. Relational data model
c. ER Design
d. None
Answer:
(b)
Explanation:- Relational data model
Q. 11.The process of refining a database design is known as
a. reality
b. Relational data model
c. ER Design
d. Normalization
Answer:
(d)
Explanation:- Normalization
Q. 12.The possibility of duplicate or redundant data items is reduced by:-
a. reality
b. Relational data model
c. ER Design
d. Normalization
Answer:
(d)
Explanation:- Normalization
Q. 13.the outcome of the process of normalization is:-
a. Refinement
b. Relational data model
c. ER Design
d. Normalization
Answer:
(a)
Explanation;- Refinement
Q. 14. Rectangular box represents
a. Entity
b. Weak entity
c. Relationship
d. None
Answer:
(a)
Explanation:- Entity
Q. 15.Double lined rectangular box represents:
a. Entity
b. Weak entity
c. Relationship
d. None
Answer:
(b)
Explanation:- Weak entity
Q. 16. a diamond shaped box represents:-
a. Entity
b. Weak entity
c. Relationship
d. None
Answer:
(c)
Explanation:- Relationship
Q. 17. A double lined diamond shaped box represents:-
a. Relationship
b. Identifying relationship
c. Attribute
d. Key attribute
Answer:
(b)
Explanation:- Identifying relationship
Q. 18.names enclosed in ovals and attached to their entity by straight lines:-
a. Relationship
b. Identifying relationship
c. Attribute
d. Key attribute
Answer:
(c)
Explanation:- Attribute
Q. 19. Attributes by double ovals:-
a. multi-valued
b. key
c. attribute
d. none
Answer:
(a)
Explanation:- Multi-valued
Q. 20. Anything in the real world with independent existence is called:-
a. entity
b. attribute
c. relationship
d. none
Answer:
(a)
Explanation:- Entity such as an object with physical existence
Q. 21. Some properties of interest that further describe the entity is :-
a. entity
b. attribute
c. relationship
d. none
Answer:
(d)
Explanation:- Attributes are the characters of entity like height, shape, size
Q. 22.the situation which may require the use of null values:-
a. When a particular attribute does not apply to an entity
b. Value of an attribute is unknown, although it exists
c. Unknown because it does not exist
d. All
Answer:
(d)
Explanation:- All
Q. 23.a conceptual entity that is meant to express the various categories of accounts in accounting system:-
a. Account types
b. Accounting
c. Account techniques
d. None
Answer:
(a)
Explanation:- Account types
Q. 24. A collection of entities, which share a common definition in term of their attributes:-
a. Account type
b. Entity type
c. Attribute type
d. Relationship type
Answer:
(b)
Explanation:- Entity type
Q. 25.Which specifies the set of possible values that may be assigned to a particular attribute.
a. Vale set
b. Value relationship
c. Value attribute
d. None
Answer:
(a)
Explanation:- Value set, each simple attribute is associated twitch it.
Q. 26.An interaction among the entity types and their respective entities:-
a. Relationship
b. Attribute
c. Entity
d. None
Answer:
(a)
Explanation :- Relationship among two or more entity represent an interaction
Q. 27. Which one is the type of relationship:-
a. one-to-one
b. one-to-many
c. many-to-many
d. all
Answer:
(d)
Explanation :- All are the types of relationship
Q. 28.a relationship type is the number of participating entity type is :-
a. degree
b. role name
c. structural constraints
d. none
Answer:
(a)
Explanation:- Degree