The ability to modify the physical schema without forcing application programs to be rewritten is called what? MCQ with Answer and Explanation

The ability to modify the physical schema without forcing application programs to be rewritten is called what?
A. Physical Data Independence
B. Logical Data Independence
C. Data Redundancy
D. Structural Integrity
Answer: Option A
Solution (By JKSSB Mock Tests)
Physical Data Independence is the ability to modify the physical schema (like storage devices or file structures) without changing the conceptual or external schemas.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL keyword is used within a SELECT query to filter records matching a specified pattern using wildcards?
A. LIKE
B. EXISTS
C. IN
D. BETWEEN

Correct Answer: Option A


Explanation:
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the difference between a database and a database management system?
A. They are the same
B. A database is the data; DBMS is the software that manages it
C. Database is a file; DBMS is a table
D. DBMS is the data; database is the software

Correct Answer: Option B


Explanation:
A database is a collection of structured data, while a DBMS is the software used to interact with and manage that data.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the alternative mathematical term used for a 'Table' in a relational database model?
A. Tuple
B. Relation
C. Domain
D. Attribute

Correct Answer: Option B


Explanation:
In relational model terminology introduced by E.F. Codd, a table is formally referred to as a relation.

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