What is the term for a column in a database table? MCQ with Answer and Explanation

Question

Share Report Error

What is the term for a column in a database table?

A. Attribute

B. Entity

C. Relation

D. Tuple

Answer: Option A

Solution (By JKSSB Mock Tests)

An attribute is a column or field in a table, representing a property of the entity.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Which of the following is a valid SQL statement to update a record?

A. CHANGE table_name SET column1 = value1 WHERE condition;

B. UPDATE table_name SET column1 = value1 WHERE condition;

C. MODIFY table_name SET column1 = value1 WHERE condition;

D. UPDATE table_name column1 = value1 WHERE condition;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

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

Question #2

The range of all permissible and valid values that an attribute can hold is formally defined as its what?

A. Schema

B. Domain

C. Relation

D. Tuple

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Domain is the pool of legal, atomic values from which an attribute can take its value.

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

Question #3

Which statement about primary keys in a relational database table is completely true?

A. A primary key column can accept a single NULL value.

B. Primary keys must always be numeric integers.

C. A table can have multiple distinct primary keys.

D. A table can contain at most one primary key.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A relational database table can have exactly one primary key constraint defined, which uniquely identifies each record and strictly forbids NULLs.

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

Explore All Database Management System (DBMS) MCQs