DBMS%20Reviewer%20(Basis%20on%20quizzes).pdf

DBMS Reviewer (Basis on quizzes) QUIZ 1: 1. The first general-purpose DBMS was designed by whom at General Electric? - Charles William Bachman III 2. This DBMS formed the basis for an alternative data representation framework called the hierarchichal data model - IMS. 3. Advantage of DBMS that...

DBMS Reviewer (Basis on quizzes) QUIZ 1: 1. The first general-purpose DBMS was designed by whom at General Electric? - Charles William Bachman III 2. This DBMS formed the basis for an alternative data representation framework called the hierarchichal data model - IMS. 3. Advantage of DBMS that states application programs should not, be exposed to details of data representation and storage, DBMS provides an abstract view of tha data that hides such details. - Data Independence 4. Advantage of DBMS that states when several users share the data, centralizing the management of data can offer significant improvements. - Data Administration 5. Advantage of DBMS that states the DBMS supports important functions that are common to many applications accessing data in the DBMS - Reduced Application Development Time 6. ______ are raw facts. The word raw indicates that the facts have not yet been processed to reveal their meaning. - Data 7. True or False. A key characteristic of knowledge is that "new" knowledge can be derived from "old" knowledge - True 8. is a discipline that focuses on the proper generation, storage, and retrieval of data. - Data Management 9. ______ are raw facts of interest to the end-user - End-user Data 10._______, or data about data, through which the end-user data are integrated and managed - Metadata 11. A multiuser database supports a relatively small number of users (Usually fewer than 50) or a specific department within an orgranization, is called ______ database. - Workgroup Database 12. A database used by the entire organization and supports many users ( more than 50, usually hundreds) across many departments, the database is known as an _______ database - Enterprise Database 13. A database that supports data located at a single site is called a ______ database - Centralized Database 14. Bitcoin is an example of what type of database system setup? - Decentralized Database 15. A character or group of characters (Alpabetic or numeric) that has a specific meaning. A _________ is used to define and store data. - Field 16. A logically connected set of one or more fields that describes a person, place, or thing. For example, the fields that constitute a ________ for a customer might consist of the customer's name, address, phone number, date of birth, credit limit, and unpaid balance. - Record 17. A collection of related records, For example a __________ might contain data about the students currently enrolled at GIgantic University - File 18. ACID Property in DBMS that simply says "All or Nothing". There is no intermidiate. - Atomicity 19. A file system exhibits __________ which means that access to a file is dependent on its structure - Structural Dependence 20.___________ exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. - Structural Independence 21. ___________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.- Data Independence 22. Exists when the same data are stored unnecessarily at different places. - Data Redundancy 23. develops when not all of the required changes in the redundant data are made successfully - Data Anomaly 24. ACID Property in DBMS wherin if you are performing multiple transaction on the single database operation from any transaction should not interfere with operation in other transactions. the execution of all transactions should be isolated from other transactions - Isolation 25. ACID Property in DBMS wherein the changes during the transaction should exist after completion of the transaction. Consistency QUIZ 2: 26. From a general management point of view, the ___________ is composed of the five major parts: hardware, software, people, procedures, and data. - Database System 27. Refers to all of the system's physical devices; for example, storage devices, printers, network devices etc. -Hardware 28. Software manages the database within the database system. - DBMS Software 29. are the instructions and rules that govern the design and use of the database system - Procedures 30. Covers the collection of facts stored in the database - Data 31. Relates to the activities that make the database perform more efficiently in terms of storage and access speed. - Performance Tuning 32. The DBMS function wherein DBMS transforms entered data to conform to the required data structures - Data Transformation and Presentation 33. deals with the recovery of the database after a failure, such as a bad sector in the disk or power failure. - Backup and Recovery Management 34. data model provides a high-level understanding of the data by abstracting it further away from the physical aspects of data storage. - Semantic Data Model 35. A description od data in terms of a data model is called a - Schema 36. Schema that is the actual PHYSICAL storage structure and access paths - Physical/Internal Schema 37. It is a very low-level representation of the entire database - Internal Schema 38. True or False. There is an only a single conceptual view of a single Database - True 39. This level comes between the user level and the physical storage view - Conceptual/Logical Schema 40. The DBMS function wherein DBMS creates and manages the complex structures required for data storage - Data Storage Management 41.refers to the maximum number of times an instance in one entity can be associated with an instances in the related entity - Cardinality 42. refers to the minimum number of times an instance in one entity can be associated with an instance in the related entity - Modality 43. used in the resolution of a many to many relationship - Intersection Entities 44. entities are those which can exist without another entity - Independent Entities 45. rely upon the existence of other entities - Dependent Entities 46. when was the ER diagram first introduced - 1976 47. what generation is NoSQL under - 4th Generation 48. is a brief, precise, and unambigous description of a policy, procedure, or principle within an organization. - Business Rules QUIZ 3: 49. refers to an organization of components that define and regulate the collection, storage, management, and use data of within a database environment - Database System 50. Software manages all hardware components and makes it possible for all other software to run on the computers - Operating System Software 51. are most commonly used to access data found within the database to generate reports, tabulations, and other information to facilitate decision making - Application Programs 52. are the software tools used to help manage the database system's computer components - Utilities 53. This component includes all users of the database system - People 54.The DBMS function wherein DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary - Data Dictionary Management 55. The DBMS function where in DBMS creates and manages the complex structures required for data storage - Data Storage Management 56.The DBMS function wherein DBMS creates a security system the enforces user security and data privacy - Security Management 57. ____________ are the rules that can be applied to table columns to enforce different types of data integrity - Data Integrity Rules 58. ____________ is a collection of high level data description constructs that hide many low level storage details - Data Model or Schema 59. Most database management systems today are based on _________ model - Relational 60. A ____________ data model is a more abstract, high-level data model that makes it easier for a user to come up with a good initial description - Semantic data model 61. A schema that describes the database structure of the whole database community of users - Conceptual Schema 62. Schema that describes the part of the database that a specific user is interested in - External Schema 63. True or False. Any given database has exactly 1 conceptual schema and 1 physical schema because it has just 1 set of stored relations, but it may have several external schemas - True 64. ___________ schema describes the part of the database which a specific user is interested in - External Schema 65. are the instructions and rules that govern the design and use of the database system. - - Procedures 66. covers the collection of facts stored in the database - Data 67. DBMS function wherein the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently - Multi-User Access Control 68. A language and message format used by an application program to communicate with the operating system or some other control program such as database management system (DBMS) - API 69. schema is the lowest level of data abstraction - Physical 70. Summarizes how the relations described in the conceptual schema are stored on secondary storage device such as disks and tapes. -Physical Schema 71. just the content of the database as it is seen by some specific particular users - External View 72. What generation of database model does Object Oriented/Object Relational database doing? - 5th Generation 73. The crow's foot notation was invented by - Gordon Everest QUIZ 3: 74. _________ is any one execution of a user program in a DBMS - Transaction 75. True or False. In DBMS, partial transaction are allowed. - False 76. ___________ is a relatively simplre representation, usually graphical, of moe complex real world data structures - Data Model 77. hiearchical is ________ Generation of Data Model - 1st Generation 78. relational is __________ Generation of Data Model - 3rd Generation 79. xml and hybrid is ________ Generation of Data Model - 5th Generation 80. key-value store, column store is _________ Generation of Data Model - 4th Generation 81. The ___________ model was developed in 1960s to manage large amounts of data for complex manufacturing projects such as the apollo rocket that landed on the moon 1969 - Hierarchical Model 82. The ________ model was created to represent complex data relationships more effectively, to improve database performance, and to impose a database standard.- Network Model 83. The conceptual organization of the entire database as viewed by the database administrator - Schema 84. Defines the environment in which data can be managed and to work with the data in the database - DML 85. The relational model foundation is a mathematical concept known as a ______ - Relation 86. Each row in a relation is called a - Tuple 87. Allows the end-user to interact with the data (by auto-generating SQL code) - End-user interface 88. ___________ is anything about which data are to be collected and stored - Entity 89. ___________ refers to the maximum number of times an instance in one entity can be associated with instances in the related entity. - Cardinality 90. ___________ entities are those which can exist without another entity - Independent 91. Object-oriented data models are typically depicted using? - UML 92. ____________ is a language based on OO concepts that describes a set of diagrams and symbols that can be used to graphically model a system. UML 93. ____________ are the only diagrams that can be directly mapped with object-oriented languages and thus widely used at the time of construction - Class DIagrams 94.___________ symbol in a class that denotes public attributes or operations - “+” 95. A diagram perspective that describes how classes will implement their interfaces - Implementation 96. A class relationship that is a taxonomic relationship between a more general classifier and a more specific classifier - Generalization 97. A class relationship that contains relationship/s between classes in a UML Class Diagram - Association 98. The______ is also considered as the foundation for component and deployment diagrams - Class Diagram 99._________ are emerging that retain the advantages of the relational model and at the same time provide programmers with an object-oriented view of the underlying data. - Object/Relational DBMSs 100. _________, such as microsoft SQL Data Services (SDS) on its Axure Services Platform, are becoming a critical component of relational database vendors' internet service strategies - SQL Data Services 101. is the end-users view of data environment - External 102. is the representation of the database as "seen" by the DBMS - Internal 103. produces a lower normal form; that is, a 3NF will be converted to a 2NF - Denormalization 104. Any attribute that is at least part of a key - Prime Attribute 105. Any attribute that is described by the primary key or the prime attribute - Nonprime Attribute 106. Exists when there is a functional dependence in which the determinant is only part of the primary key (remember we are assuming there is only one candidate key) - Partial Dependency 107. What should be eliminated in the 3NF? - Transitive Dependency 108 When something is _______, then a meaning or relationship is the same in the middle as it is across the whole. - Transitive 109. Sometimes ________ is also referred as 3.5 Normal Form - BCNF Here are the answers to your questions based on the PDF: 1. **Charles William Bachman III** 2. **IBM’s IMS DBMS** 3. **Data Independence** 4. **Data Administration** 5. **Reduced Application Development Time** 6. **Data** 7. **True** 8. **Data Management** 9. **End-user Data** 10. **Metadata** 11. **Workgroup Database** 12. **Enterprise Database** 13. **Centralized Database** 14. **Decentralized Database** 15. **Field** 16. **Record** 17. **File** 18. **Atomicity** 19. **Structural Dependence** 20. **Structural Independence** 21. **Data Independence** 22. **Data Redundancy** 23. **Data Anomaly** 24. **Isolation** 25. **Durability**