The total number of attributes (columns) present in a relation determines its what? MCQ with Answer and Explanation

The total number of attributes (columns) present in a relation determines its what?
A. Schema
B. Degree
C. Domain
D. Cardinality
Answer: Option B
Solution (By JKSSB Mock Tests)
The number of attributes or columns in a relation is defined as the degree of that relation.

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 view in a database?
A. An index on a table
B. A virtual table based on the result of a SELECT query
C. A physical table stored on disk
D. A backup of 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)
Question #2
In relational database terminology, a row in a table is precisely called a what?
A. Relation
B. Field
C. Tuple
D. Attribute

Correct Answer: Option C


Explanation:
A single row or record in a relational database table is formally called a tuple.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a database cursor?
A. A type of index
B. A user account
C. A control structure that enables traversal over rows in a result set
D. A backup file

Correct Answer: Option C


Explanation:
A cursor allows row-by-row processing of query results, often used in procedural extensions of SQL.

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