What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person? MCQ with Answer and Explanation

What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person?
A. Derived Attribute
B. Complex Attribute
C. Multi-valued Attribute
D. Composite Attribute
Answer: Option C
Solution (By JKSSB Mock Tests)
A Multi-valued Attribute is an attribute that can store multiple distinct values for a single entity instance (e.g., skill_set, phone_numbers).

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which clause is used in SQL to sort the final query result set in ascending or descending order?
A. SORT BY
B. GROUP BY
C. ORDER BY
D. ARRANGE BY

Correct Answer: Option C


Explanation:
The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL command deletes all rows from a table without deleting the structural schema, cannot be rolled back easily in some systems, and does not fire delete triggers?
A. REMOVE
B. DELETE
C. DROP
D. TRUNCATE

Correct Answer: Option D


Explanation:
TRUNCATE is a DDL command that quickly removes all records from a table by deallocating the data pages, bypassing row-level logging and triggers while leaving the table structure intact.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following represents raw, unorganized, and unprocessed facts that lack contextual meaning?
A. Knowledge
B. Data
C. Metadata
D. Information

Correct Answer: Option B


Explanation:
Data refers to raw, unorganized, and unprocessed facts, figures, or symbols that do not convey a specific meaning on their own. When data is processed and organized, it becomes information.

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