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. Tuple
B. Attribute
C. Degree
D. Entity
Answer: Option B
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
Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?
A. Modification Anomaly
B. Insertion Anomaly
C. Deletion Anomaly
D. Update Anomaly

Correct Answer: Option B


Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which operator in SQL is used to exclude specific data records from a search based on a collection of negative criteria?
A. MINUS
B. REMOVE
C. NOT IN
D. EXCEPT

Correct Answer: Option C


Explanation:
The NOT IN operator filters the query results to exclude records whose values match any element within the provided list or subquery.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a view in a database?
A. A backup of a table
B. A virtual table based on the result of a SELECT query
C. A physical table stored on disk
D. An index on a table

Correct Answer: Option B


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)