What is the concept of data independence? MCQ with Answer and Explanation

Question

Share Report Error

What is the concept of data independence?

A. The ability to store data in different formats

B. The ability to access data from multiple sources

C. The ability to move data between tables

D. The ability to change the database schema without affecting the application programs

Answer: Option D

Solution (By JKSSB Mock Tests)

Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.

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 the purpose of the SQL 'CONSTRAINT' keyword?

A. To join tables

B. To create views

C. To create indexes

D. To define rules for data integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.

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

Question #2

Which rule state that 'no component of a primary key can accept a NULL value'?

A. Security Integrity Rule

B. Referential Integrity Rule

C. Entity Integrity Rule

D. Domain Constraint Rule

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Entity Integrity Rule states that a primary key column cannot contain NULL values, ensuring each row can be explicitly identified.

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

Question #3

What is the difference between an inner join and an outer join?

A. Outer join is used for more than two tables

B. Inner join returns all rows; outer join returns matching only

C. Inner join returns only matching rows; outer join returns matching plus non-matching rows from one or both tables

D. They are the same

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Inner join returns rows where the join condition matches. Outer join (left, right, full) returns unmatched rows as well with NULLs.

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

Explore All Database Management System (DBMS) MCQs