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

Question

Share Report Error

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

A. Cardinality

B. Degree

C. Schema

D. Domain

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.

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

What is a composite key in a database?

A. A key that is made up of multiple columns

B. A key that is a single column

C. A key that references another table

D. A key that is always a foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A composite key is a primary key that consists of two or more columns to uniquely identify a row.

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

Question #2

Which of the following is a valid SQL statement to create a view?

A. CREATE VIEW view_name (columns) AS SELECT ...;

B. Neither

C. CREATE VIEW view_name AS SELECT ...;

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both syntaxes are valid: CREATE VIEW view_name AS SELECT ... and with column aliases.

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

Question #3

Which of the following is a property of a database that ensures transactions are isolated from each other?

A. Atomicity

B. Isolation

C. Consistency

D. Durability

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Isolation ensures that concurrent execution of transactions results in a state that is equivalent to some serial execution.

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

Explore All Database Management System (DBMS) MCQs