Which of the following is a characteristic of a DBMS? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a characteristic of a DBMS?

A. Data redundancy control

B. Data independence

C. All of the above

D. Security and access control

Answer: Option C

Solution (By JKSSB Mock Tests)

A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

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

A candidate key is:

A. A foreign key only

B. A minimal super key

C. Any key with duplicates

D. Always the primary key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A candidate key is a minimal set of attributes that can uniquely identify a tuple.

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

Question #2

In the context of databases, what is a 'tuple'?

A. A column of a table

B. A key constraint

C. A row of a table

D. A table itself

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In relational databases, a tuple is a single row or record of a table.

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

Question #3

What is the default sorting order when using the ORDER BY clause in an SQL statement?

A. Descending

B. Alphabetic only

C. Random

D. Ascending

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
By default, the ORDER BY clause sorts the query results in ascending order unless specified otherwise using the DESC keyword.

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

Explore All Database Management System (DBMS) MCQs