The capacity to change the conceptual schema without having to change the external schemas or additional programs is called as ............... .
एक्सटर्नल स्कीमा या अतिरिक्त प्रोग्राम्स को बदले बिना कन्सेप्चुअल स्कीमा को बदलना ---------- कहलाता है।
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. Logical Data Independenceलॉजिकल डेटा इन्डिपेन्डेन्स
Explanation
Logical data independence: the conceptual schema can change without changing external schemas or application programs. Physical independence is the same for the internal schema.
लॉजिकल डेटा इंडिपेंडेंस: कॉन्सेप्चुअल स्कीमा बदलने पर भी एक्सटर्नल स्कीमा/प्रोग्राम नहीं बदलने पड़ते।
More Database Management & SQL questions
- In SQL terminology a ................ is a single table that is derived from other tables.
- SQL command used to add a new column in an existing table is :
- In context of deadlock prevention in DBMS, wait-die and wound-wait schemes are ........ techniques.
- In context of databases consider set operations on relation R and S, and select a true statement :
- In context of 2-phase locking protocol in DBMS, a transaction issues lock requests in ......... phase and unlock requests in ........ phase.
- Choose the SQL commands to perform following operations on a relation R : I : Retain Relation R in database, but delete all tuples in R. II…