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ġ.
0 kommentar(er)
