Data independence means data must not be dependent on the
|
62. Data independence meansA. data is defined separately and not included in programs.B. programs are not dependent on the physical attributes of dataC. programs are not dependent on the logical attributes of dataD. both B and CAnswer: D Show 63. A.........is used to define overall design of the database Get answer to your question and much more
64. Key to represent relationship between tables is called Get answer to your question and much more 65. Grant and revoke are.......statements. Get answer to your question and much more Green- EasyRed- IntermediateBlack- Challenging66. DBMS helps achieveA. Data independenceB. Centralized control of dataC. Neither A nor BD. Both A and BAnswer: D 67...........command can be used to modify a column in a table Get answer to your question and much more 68. The ascending order of a data hirerchy is: Get answer to your question and much more 69. Which of the following is true of a network structure? Get answer to your question and much more 70. Which of the following is a problem of file management system?A.difficult to updateB.lack of data independenceC.data redundancyD.program dependence Green- EasyRed- IntermediateBlack- ChallengingE.all of aboveAnswer: E71. One data dictionery software package is called Get answer to your question and much more 72. The function of a database is ... Get answer to your question and much more 73. What is the language used by most of the DBMSs for helping their users to access data? Get answer to your question and much more 74. The model for a record management system might beA.handwritten listB.a Rolodex card fileC.a business formD.all of aboveAnswer: D 75. Primitive operations common to all record management system include Get answer to your question and much more Green- EasyRed- IntermediateBlack- Challenging Get answer to your question and much more Get answer to your question and much more Upload your study docs or become a Course Hero member to access this document Upload your study docs or become a Course Hero member to access this document End of preview. Want to read all 50 pages? Upload your study docs or become a Course Hero member to access this document If a database system is not multi-layered, then it becomes difficult to make any changes in the database system. Database systems are designed in multi-layers as we learnt earlier. Data IndependenceA database system normally contains a lot of data in addition to users’ data. For example, it stores data about data, known as metadata, to locate and retrieve data easily. It is rather difficult to modify or update a set of metadata once it is stored in the database. But as a DBMS expands, it needs to change over time to satisfy the requirements of the users. If the entire data is dependent, it would become a tedious and highly complex job. Metadata itself follows a layered architecture, so that when we change data at one layer, it does not affect the data at another level. This data is independent but mapped to each other. Logical Data IndependenceLogical data is data about database, that is, it stores information about how data is managed inside. For example, a table (relation) stored in the database and all its constraints, applied on that relation. Logical data independence is a kind of mechanism, which liberalizes itself from actual data stored on the disk. If we do some changes on table format, it should not change the data residing on the disk. Physical Data IndependenceAll the schemas are logical, and the actual data is stored in bit format on the disk. Physical data independence is the power to change the physical data without impacting the schema or logical data. For example, in case we want to change or upgrade the storage system itself − suppose we want to replace hard-disks with SSD − it should not have any impact on the logical data or schemas. What is the data independence means?Data independence is the type of data transparency that matters for a centralized DBMS. It refers to the immunity of user applications to changes made in the definition and organization of data. Application programs should not, ideally, be exposed to details of data representation and storage.
What is the meaning of data independence Mcq?Explanation: The term "Data independence" refers that the program should not be dependent on either the logical attributes of data or physical attributes of data.
What is the purpose of data independence?Data Independence is defined as a property of DBMS that helps you to change the Database schema at one level of a database system without requiring to change the schema at the next higher level. Data independence helps you to keep data separated from all programs that make use of it.
What does independence of data mean quizlet?Data independence is the condition in which data access is unaffected by changes in the physical data storage characteristics. It lacks in file systems because every time you make changes in the file structure, you have to modify the application program that uses it.
|
