ICS2607_Long Quiz 1.pdf

Question 1 Entity Relationship Diagram (ERD) uses graphic representations to model database components and is mapped to a relational table. True False Question 2 Item on the disadvantages of File Processing that involves having no centralized control of data. Lengthy Development Times...

Question 1 Entity Relationship Diagram (ERD) uses graphic representations to model database components and is mapped to a relational table. True False Question 2 Item on the disadvantages of File Processing that involves having no centralized control of data. Lengthy Development Times None of the above Duplication of Data Limited Data Sharing Program-Data Dependence Question 3 A type of relationship participation where one entity occurrence does not require corresponding entity occurrence in a particular relationship. Optional participation Semi-Mandatory participation Semi-Optional participation Mandatory participation Question 4 It is used best for practical, industry-standard database design, focusing on the structure and cardinality of relationships. Crow's foot notation Unified Modeling language Entity Relationship Diagram Chen notation Question 5 Attributes in ERD/ERM corresponds to Tables in RDBMS. False True Question 6 It is a type of database model that organizes data into a upside down tree-like structure, where each record has a single parent or root. Network model Relational model Hierarchical model Flat model Question 7 Types of Basic Cardinality in ERD except: M-to-M relationship N-to-N relationship 1-to-M relationship 1-to1 relationship Question 8 The following choices are the uses of business rules: (Select all that applies) Allows designer to develop appropriate relationship participation rules and constraints Standardize company’s view of data Communication tool between users and designers Allows designer to understand the nature, role, and scope of data Question 9 The most common model, the relational model sorts data into tables, also known as relations, each of which consists of columns and rows. Flat model Relational model Hierarchical model Dimensional model Question 10 Using database approach there is a central repository of shared data. True False Question 11 Using Chen and Crow's Foot models, entity is represented by an square with it's name. True False Question 12 Using a template to organize data is a form of processing. True False Question 13 Nouns are used to identify names of Entity Relationships. True False Question 14 Operational database are also called transactional or production database. True False Question 15 Composite identifier are primary keys which are composed of a single attribute. True False Question 16 Derived attribute refers to an attribute derived or based on another attribute. True False Question 17 Type of key that uniquely identify each record in the table. Foreign key Secondary key Composite key Primary key Question 18 In ERD, customer contact number is an example of a single-value attribute. True False Question 19 Ordinality describes whether a relationship between two entities is mandatory or optional. True False Question 20 It is an organized collection of logically related data. Information Database Program Big data None of the above Question 21 Abstraction in data modeling means that non-data modeling aspects are not included in the diagram. True False Question 22 Waste of space in promoted when unnecessary duplicate data exists. True False Question 23 This is a type of Data model that is used to represent complex data relationships. Relational model Hierarchical model None among the choices Database model Question 24 In ERD, identifiers are represented by underlying the name of the attributes. True False Question 25 A problem in File Processing associated with having no centralized control of data. Program-Data Dependence Can not perform adhoc queries Lengthy Development Times Limited Data Sharing Question 26 Data modeling requirements are based on policies, meetings, procedures, system specifications. True False Question 27 In ERD, it is the symbol used to represent an attribute. double oval shape square shape rectangle shape oval shape Question 28 The following choices are sources of business rules: (Select all that applies) policy makers company managers written documentation direct interviews with non-users Question 29 Derived attribute refers to an attribute derived or based on another attribute. True False Question 30 The following are the challenges of database system except: decreased cost management complexity maintaining currency dependence to vendors Question 31 Waste of space in promoted when duplicate data exists. True False Question 32 Data management focuses on proper generation, storage and retrieval of data. True False Question 33 It is used to represent database structure and the format of database which is managed by the database management system RDBMS data models data DBMS Question 34 In ERD, it is the symbol used to represent attribute. double rectangle square oval diamond rectangle Question 35 Data redundancy happens when same data are stored unnecessarily in different places or tables. True False Question 36 In ERD, attributes are anything (people, places, objects, events, etc.) about which we store information. True False Question 37 Data conversion cost is inevitable in implementing database scheme. True False Question 38 In ERD, it is the symbol used to represent Entity. rectangle square oval double oval Question 39 Functions of Database Management System except: Security Management Data transformation and presentation Program-Data Dependence Excessive Program Maintenance Question 40 Having new and specialized personnel is one of the cost and risks of Database approach. True False Question 41 These are processed data to increase knowledge in the person using the data Information RDBMS Compiler Symbols None of the above Question 42 This is one of the basic building blocks of the data model that deals with the restriction placed on the data. attribute entity relationship none among the choices Question 43 Using data modeling, important data is identified and which is to be maintained. True False Question 44 These are stored representations of meaningful objects and events. Information Program Database Data Question 45 It is best for detailed conceptual models of databases, focusing on the attributes and relationships. Unified Modeling language Entity Relationship Diagram Chen notation Crow's foot notation Question 46 The type of database to be used will depend on number of users and extent of use. True False Question 47 Data model revolves around discovering and analyzing organizational and user’s data requirements. True False Question 48 In Crow's foot notation, the rhombus shape represents Entity Relationship. True False Question 49 These are data processed to increase knowledge in the person using the data RDBMS Information Compiler Symbols Question 50 Database Management System (DBMS) are collection of programs that manages the structure and control of access to data. True False Question 51 In Entity Relationship Modeling, choose which is not related to the group. instance column row occurrence Question 52 These are the management performed on raw data, select one that does not belong to the group: presented formatted for storage discarded processed Question 53 Entities describe policies, procedures, or principles within a specific organization. True False Question 54 Using data modeling, important data is identified and which is to be maintained. Correct! True False Question 55 Database solve many of the problems encountered in data management Correct! True False Question 56 Good decision required good information derived from raw facts. Correct! True False Question 57 The need for explicit backup and recovery are some of the challenges of DBMS. True False Question 58 In Chen Notation, relationship names are written outside the diamond shape. True False Question 59 A superkey is used to uniquely identifies each row. Correct! True False Question 60 Having new and specialized personnel is one of the cost and risks of Database approach True False Question 61 Entities in ERD are relationships which are associations between attributes. True False Question 62 Types of Entity Relationship Model except: Correct! Flowchart UML Notation Crow’s Foot Notation Chen Notation Question 63 These are data that describes the properties and context of user data Information DBMS Metadata Program Question 64 Entities in ERD are relationships which are associations between attributes. True False Question 65 Multiuser database are appropriately used in workgroups and enterprise setup. Correct! True False Question 66 In Chen Notation, it is the symbol used to represent relationship of entities. square rectangle double rectangle rhombus Question 67 A database developer manages and maintains DBMS and databases. True False Question 68 It is used to represent database structure and the format of database which is managed by the database management system data models DBMS RDBMS None of the above data Question 69 Data model revolves around discovering and analyzing organizational and user’s data requirements. True False Question 70 It represent the look and feel of the database. DBMS model None of the above data model RDBMS Question 71 These are the building blocks of an Entity Relationship Diagram (ERD) except: Relationship None of the above Entity Attribute Question 72 Data warehouse contains and manages huge volume of information used for tactical and strategic decisions. True False Question 73 A database consultant helps companies leverage database technologies to improve business processess and achieve specific goals. True False Question 74 Type of notation that is best for modeling software systems, including databases, with a broader scope beyond just data structure, covering behavior, interactions, and architecture. Chen notation Crow's foot notation Entity Relationship Diagram Unified Modeling language Question 75 Business rules must contain the following characteristics: (select all that applies) shared among authorized users must be in verbal form updated comprehendible Question 76 Primary Key are attributes that uniquely identify each entity instance. True False Question 77 Verbs are used to identify names of Entity. True False Question 78 Cardinality describes whether a relationship is mandatory or optional. True False Question 79 Data modeling describes operations to create and enforce actions within an organization’s environment. True False Question 80 One of the problems of File Processing concerning all programs must maintain metadata for each file it uses. Lengthy Development Limited Data Sharing Program-Data Dependence Duplication of Data Question 81 Vendor dependence is avoided in database approach. True False Question 82 These are stored representations of meaningful objects and events. Database None of the above Data Program Information Question 83 This is one of the database career opportunities that implements security policies for data administration. Database designer Database administrator Database security officer Database analyst Question 84 Operational database supports a company's day-to-day operations. Correct! True False Question 85 The following are the components of ERD except: Relationships Cardinality Attributes Entities Question 86 Type of key that uniquely identify each record in the table. Candidate key Primary key Secondary key Foreign key Composite key Question 87 Another problem of File Processing concerning the different systems/programs having separate copies of the same data. Duplication of Data Limited Data Sharing Program-Data Dependence Lengthy Development Times Question 88 Optional attribute must always be filled-up. True False Question 89 Types of database modelling that describes the way data are save on storage media. Relational Model Physical Model Conceptual Model DBMS Question 90 In ERD, identifiers are represented by an underline under the name of the attribute. True False Question 91 It is an organized collection of logically related data. Big data Information Program Database Question 92 Data modeling is a repetitive process that promotes improvement for every revision made. True False Question 93 Data inconsistency is minimized when DBMS is implemented.. Correct! True False Question 94 It provides a description of data characteristics and relationships in data, it also complements and expands the value of data. metadata data modelling data model business rule Question 95 In ERD, attributes are anything (people, places, objects, events, etc.) about which we store information. True False Question 96 Data modeling requirements are deviated from policies, meetings, procedures, system specifications. True False Question 97 The following are the advantages of DBMS except: Improved data security Maximized data inconsistency Improved data sharing Better data integration Question 98 Using database approach there is a central repository of shared data. True False Question 99 DBMS improves data sharing and access. Correct! True False Question 100 Cardinality is the number of occurrences in one entity which are associated to the number of occurrences in another. True False