DATA INDEPENDENCE IN DBMS WITH EXAMPLE PDF FORM HOW TO

DATA INDEPENDENCE IN DBMS WITH EXAMPLE PDF FORM HOW TO

_ DML requires a user to specify what data is needed and how to get it.Ĥ4. DML is a language that enables users to access or manipulate as organized by the appropriate _.Ĥ3. Database management systems provide a facility known as the _, which can be used to define the conceptual schema.Ĥ2. The _ consists of physical files and memory components.Ĥ1. Oracle 9i Database product is made up _ main components.Ĥ0. In _ the data storage mechanism must be transparent to the users who purchase the application.ģ9. _ systems must be capable of handling thousands of orders placed at the same time.Īns. There is only _ conceptual schema per database.ģ7. Each transactional table handler implements its own _ to handle all locking and concurrency needs.ģ6. Buffer manager subsystem handles all memory management issues between requests for data by the _ and the Storage Manager.ģ5. The _ interfaces with the operating system (OS) to write data to the disk efficiently.ģ4. The _ decomposes the SQL commands it receives from calling programs into a form that can be understood by the MySQL engine.ģ3. The MySQL architecture consists of _ primary subsystems.ģ2. _ level describes what data are actually stored in the database.ģ1. The highest level of abstraction as seen by a user is called _view.ģ0.

In general, the database system supports one physical schema, one conceptual schema and several _.Ģ9. The overall design of the database is called the _ schema.Ģ8. The physical database is the data that is stored on _ storage devicesĢ7. A significant disadvantage of the DBMS system is _.Ģ6. Data is of _ importance to an organization and may be confidential.Ģ5. _ means that the data contained in the database is both accurate and consistent.Ģ4. The relational model is based on _ its accuracy and usefulness as a basis in mathematics.Ģ3.

Relational/SQL data is _ to query than hierarchical, CODASYL, or some other model.Ģ2. Any redundancies that exist in the DBMS are controlled and the system ensures that these multiple copies are _.Ģ1. Logical data independence is more _ to achieve than physical independence.Ģ0.

_ data independence implies that application programs need not be changed if fields are added to an existing record.ġ9. The database administrator is the focus of the _ control.ġ8. An entity in B, however, can be associated with at most _ entity in A.ġ7. In one-to-many relationships, an entity in A is associated with any number of entities in B. An entity in A is associated with at most one entity in B, and an entity B is associated with at most one entity in A, this type of relationship is _.ġ6. A particular occurrence of an entity is called an entity _.ġ5. The E-R data model based on a perception of the real-world that consists of a set of basic objects called _.ġ4. Data modelling is preceded by _ and analysis.ġ3. _ data independence allows changes in physical storage devices.ġ2. The _ is one part of the conceptual design process.ġ1.

Data independence is usually considered from _ points of view.ġ0. In _ database is used for keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about the communication networks.ĩ. The _ machines came along and let users interact directly with databases.Ĩ. _ were among the first to use databases in a geographically distributed manner.ħ. Logical data independence is more _ to achieve than physical independence.ĥ. _ data independence implies that application programs need not be changed if fields are added to an existing record.Ĥ. _ data independence allows changes in the physical storage devices.ģ. Data independence is usually considered from _ points of view.Ģ. DBMS MCQ questions – DBMS multiple choice questions with answers pdfġ.

Data independence in dbms with example pdf form