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

Question

Share Report Error

What is a column in a relational database table formally called?

A. Attribute

B. Tuple

C. Degree

D. Entity

Answer: Option A

Solution (By JKExamLibrary)

A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

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

The total number of attributes (columns) present in a relation determines its what?

A. Degree

B. Schema

C. Domain

D. Cardinality

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The number of attributes or columns in a relation is defined as the degree of that relation.

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

Question #2

What is a view in a database?

A. A backup of a table

B. A physical table stored on disk

C. A virtual table based on the result of a SELECT query

D. An index on a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A view is a logical representation of data, derived from one or more tables, but does not store data physically.

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

Question #3

Which of the following is a valid SQL statement to add a primary key to an existing table?

A. Both A and C

B. ALTER TABLE table_name ADD PRIMARY KEY (column_name);

C. ALTER TABLE table_name ADD CONSTRAINT pk_name PRIMARY KEY (column_name);

D. ADD PRIMARY KEY ON table_name (column_name);

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both syntaxes are valid: ADD PRIMARY KEY (column) and ADD CONSTRAINT ... PRIMARY KEY (column).

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

Explore All Database Management System (DBMS) MCQs