CBSE MCQ Class 11 Accountancy Chapter 14 Structuring Database For Accounting With Answer

MCQ Class 11 Accountancy Chapter 14 : MCQ Questions for Class 11 Accountancy Chapter 14 Structuring Database for Accounting with Answers PDF Free Download prepared here according to the latest CBSE RBSE and Other State Board syllabus and NCERT curriculum.

Page Contents

MCQ Class 11 Accountancy Chapter 14 Wise with answer and Free PDF Download

MCQ Class 11 Accountancy Chapter 14 Structuring Database for Accounting with answre

Fill in the blanks, an appropriate word(s)

Q1. A ………………. does not have key attributes of its own.

weak entity

Q2. The ……………… for binary relationship specifies the number of relationship instances that an entity can participate in.

computer based

Q3. Each simple attribute of an entity type is associated with a value set called …………… of values.

Q4. When structure of AIS is based on both human and computer resources. It is called ……………….. AIS.

liveware

Q5. A ……………….. is a collection of all entities of a particular entity type.

total participation

Q6. A weak entity type always has a …………….. constraint with respect to its identifying relationship.

multi-valued

Q7. When a relation has more than one attribute with unique values, each such attribute is called ………………..

Q8. Every relation has at least one super key by default, which is the combination of all its attributes.

True

Q9. Data transformation is called information.

True

Q10. Referential integrity constraint arises because of relationships between various entities.

True

Q11. The complete absence of WHERE clause in SELECT statement implies that no tuples of a relation shall be selected.

Q12. ER model is an example of representational data model.

False

Q13. State three concept of structuring database for accounting.

The three concepts of structuring database for accounting are. 1. Documentation of Transaction 2. Computerised Accounting 3. Accounting Database

Q14. Define Data Processing Cycle.

Data processing cycle is a process of transforming the data into useful information for making an important decision.

Q15. What are the steps required in Data Processing Cycle?

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

Q16. What are the elements required for conceptualising data model?

The elements required for conceptualising data mode are. 1. Reality 2. ER Design 3. Relational Data Model 4. Normalisation 5. Refinement

Q17. Does all the relation have one default super key, which is the unification of all its attributes? Is it true or false?

True

Q18. Do you agree with the statement that Data transformation is known Information. Is it true or false?

True

Q19. Referential integrity limitation rises because of the links between various entities. Is it true or false?

Q20. 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?

False

Q21. The example of a representational data model is the ER model. Is it true or false?

False

Q22. Which attribute has more than one attribute with unique values

Full functional

MCQ Questions for Class 11 Accountancy with Answers Chapter Wise PDF Download

MCQ Questions for Class 11 Accountancy: Financial Accounting

PDF Free Download for Telegram