An attribute that can be broken down into smaller, independent sub-parts with independent meanings (such as Name into First_Name and Last_Name) is called a what? MCQ with Answer and Explanation

An attribute that can be broken down into smaller, independent sub-parts with independent meanings (such as Name into First_Name and Last_Name) is called a what?
A. Multi-valued Attribute
B. Simple Attribute
C. Composite Attribute
D. Derived Attribute
Answer: Option C
Solution (By JKSSB Mock Tests)
A Composite Attribute is one that can be divided into smaller sub-components or meaningful independent fields.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
The total number of tuples (rows) contained within a relational database table is called its what?
A. Density
B. Dimension
C. Cardinality
D. Degree

Correct Answer: Option C


Explanation:
The number of tuples or rows in a relation is defined as the cardinality of that relation.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a 'foreign key' constraint specifically designed to prevent?
A. Actions that would destroy links or introduce invalid references between tables.
B. The use of duplicate data values within the primary key column.
C. Slow search execution times.
D. Unauthorized login attempts to the database.

Correct Answer: Option A


Explanation:
A Foreign Key constraint enforces referential integrity, preventing updates or deletions that would leave orphaned child records pointing to non-existent parent rows.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?
A. Consistency
B. Durability
C. Atomicity
D. Isolation

Correct Answer: Option A


Explanation:
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.

This question belongs to: Computer Database Management System (DBMS)