What is a column in a relational database table formally called? MCQ with Answer and Explanation

What is a column in a relational database table formally called?
A. Attribute
B. Degree
C. Entity
D. Tuple
Answer: Option A
Solution (By JKSSB Mock Tests)
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is a pivot table in a database context?
A. A stored procedure
B. A view
C. A type of index
D. A technique to rotate rows into columns for data summarization

Correct Answer: Option D


Explanation:
Pivoting transforms data by turning unique values from one column into multiple columns, often for reporting.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following is NOT an aggregate function in standard SQL?
A. LENGTH()
B. SUM()
C. AVG()
D. COUNT()

Correct Answer: Option A


Explanation:
SUM(), AVG(), and COUNT() are aggregate functions operating on multiple rows, whereas LENGTH() is a scalar function acting on a single text value.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a method to avoid deadlock?
A. Lock ordering
B. All of the above
C. Deadlock detection and resolution
D. Using a timeout

Correct Answer: Option B


Explanation:
Strategies to handle deadlocks include timeout, lock ordering, and detection with rollback.

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