Aspire's Library

A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET

Previous Year Question (PYQs)



Consider the following statements:

Statement I: Composite attributes cannot be divided into smaller subparts.

Statement II: Complex attribute is formed by nesting composite attributes and multivalued attributes in an arbitrary way.

Statement III: A derived attribute is an attribute whose values are computed from other attribute.

Which of the following is correct?





Solution

Statement I:

Composite attributes are attributes that can be divided into smaller subparts.

For example, Name can be divided into First Name, Middle Name and Last Name.

So, the statement "Composite attributes cannot be divided into smaller subparts" is false.

Therefore, Statement I is false.

Statement II:

Complex attributes are formed by combining composite attributes and multivalued attributes.

They may contain nested structures.

So, complex attributes can be formed by nesting composite attributes and multivalued attributes.

Therefore, Statement II is true.

Statement III:

A derived attribute is an attribute whose value is calculated from another attribute.

For example, Age can be derived from Date of Birth.

So, Statement III is true.

Therefore:

Statement I is false.

Statement II is true.

Statement III is true.


Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More


Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

Ask Your Question or Put Your Review.

loading...