We have compiled the NCERT MCQ Questions for Class 11 Accountancy Chapter 14 Structuring Database for Accounting 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 Structuring Database for Accounting Class 11 MCQs Questions with Answers here along with a detailed explanation.
Structuring Database for Accounting Class 11 MCQs Questions with Answers
Fill in the blanks
Question 1.
A ………………. does not have key attributes of its own.
Answer
Answer: weak entity
Question 2.
The ……………… for binary relationship specifies the number of relationship instances that an entity can participate in.
Answer
Answer: computer based
Question 3.
Each simple attribute of an entity type is associated with a value set called …………… of values.
Answer
Answer: timeware
Question 4.
When structure of AIS is based on both human and computer resources. It is called ……………….. AIS.
Answer
Answer: liveware
Question 5.
A ……………….. is a collection of all entities of a particular entity type.
Answer
Answer: total participation
Question 6.
A weak entity type always has a …………….. constraint with respect to its identifying relationship.
Answer
Answer: multi-valued
Question 7.
When a relation has more than one attribute with unique values, each such attribute is called ………………..
Answer
Answer: full functional
Indicate against each of the following statements, True or False.
Question 1.
Every relation has at least one super key by default, which is the combination of all its attributes.
Answer
Answer: True
Question 2.
Data transformation is called information.
Answer
Answer: True
Question 3.
Referential integrity constraint arises because of relationships between various entities.
Answer
Answer: True
Question 4.
The complete absence of WHERE clause in SELECT statement implies that no tuples of a relation shall be selected.
Answer
Answer: False
Question 5.
ER model is an example of representational data model.
Answer
Answer: False
Answer in one word / sentence:
Question 1.
State three concept of structuring database for accounting.
Answer
Answer: The three concepts of structuring database for accounting are.
1. Documentation of Transaction
2. Computerised Accounting
3. Accounting Database
Question 2.
Define Data Processing Cycle.
Answer
Answer: Data processing cycle is a process of transforming the data into useful information for making an important decision.
Question 3.
What are the steps required in Data Processing Cycle?
Answer
Answer: The steps required in Data Processing Cycle are.
1. Sources of document
2. Input of data
3. Data Storage
4. Manipulation of Data
5. Output of Data
Question 4.
What are the elements required for conceptualising data model?
Answer
Answer: The elements required for conceptualising data mode are.
1. Reality
2. ER Design
3. Relational Data Model
4. Normalisation
5. Refinement
Question 5.
Does all the relation have one default super key, which is the unification of all its attributes? Is it true or false?
Answer
Answer: True
Question 6.
Do you agree with the statement that Data transformation is known Information. Is it true or false?
Answer
Answer: True
Question 7.
Referential integrity limitation rises because of the links between various entities. Is it true or false?
Answer
Answer: True
Question 8.
The entire nonexistence of WHERE condition in the SELECT statement indicates that no tuples of a relation shall be chosen. Is it true or false?
Answer
Answer: False
Question 9.
The example of a representational data model is the ER model. Is it true or false?
Answer
Answer: False
Question 10.
Which attribute has more than one attribute with unique values
Answer
Answer: Full functional
Question 11.
Which entity does not have key attributes of its own
Answer
Answer: Weak entity
Question 12
What constraint does the weak entity type always have with respect to its identifying relationship?
Answer
Answer: Multi-valued constraint
Hope the information shed above regarding NCERT MCQ Questions for Class 11 Accountancy Chapter 14 Structuring Database for Accounting with Answers Pdf free download has been useful to an extent. If you have any other queries of CBSE Class 11 Accountancy Structuring Database for Accounting MCQs Multiple Choice Questions with Answers, feel free to reach us so that we can revert back to us at the earliest possible.