IS 410 EXAM I MOCK TEST QUESTIONS WELL ANSWERED LATEST UPDATE 2026

IS 410 EXAM I MOCK TEST QUESTIONS WELL ANSWERED LATEST UPDATE 2026 2) Database management involves all of the following EXCEPT: A) collecting data. B) organizing data. C) design web pages. D) managing data. - Answers C) design web pages. 3) A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly - Answers A) logically 7) Relational databases establish the relationships between entities by means of common fields included in a file called a(n): A) entity. B) relationship. C) relation. D) association. - Answers C) relation 8) A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) enterprise view B) reporting document C) user view D) user snapshot - Answers C) user view 9) A graphical system used to capture the nature and relationships among data is called a(n): A) XML data model. B) hypertext graphic. C) relational database. D) data model. - Answers D) data model. 16) A user view is: A) what a user sees when he or she looks out the window. B) a table or set of tables. C) a logical description of some portion of the database. D) a procedure stored on the server. - Answers C) a logical description of some portion of the database. 17) A major difference between data warehouses and transactional systems as compared to big data is: A) the data is unstructured in big data systems. B) the size of the CPU used. C) the programming required to access data. D) all of the above. - Answers A) the data is unstructured in big data systems. 18) Which organizational function should set database standards? A) Management B) Application development C) Technical services D) Database Administration - Answers D) Database Administration 19) ________ is a tool even non-programmers can use to access information from a database. A) ODBC B) Structured query language C) ASP D) Data manipulation query language - Answers B) Structured query language 26) The period that can be considered a "proof of concept" time was the: A) 1950s. B) 1960s. C) 1970s. D) 1990s. - Answers B) 1960s. 27) A departmental multi-tiered client/server database is stored on a central device called a: A) client. B) server. C) remote PC. D) network. - Answers B) server. 28) Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) 40 percent B) 25 percent C) 60 percent D) 80 percent - Answers D) 80 percent 29) Which of the following is NOT a cost and/or risk of the database approach? A) Specialized personnel B) Cost of conversion C) Improved responsiveness D) Organizational conflict - Answers C) Improved responsiveness 36) The traditional methodology used to develop, maintain, and replace information systems is called the: A) Enterprise Resource Model. B) Systems Development Life Cycle. C) Unified Model. D) Systems Deployment Life Cycle. - Answers B) Systems Development Life Cycle. 37) The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase. A) planning B) design C) analysis D) implementation - Answers C) analysis 38) The SDLC phase in which database processing programs are created is the ________ phase. A) planning B) design C) analysis D) implementation - Answers D) implementation 39) The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) planning B) design C) analysis D) implementation - Answers C) analysis 46) A data warehouse derives its data from: A) on-line transactions. B) various operational data sources. C) reports. D) a data mart. - Answers B) various operational data sources. 47) Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: A) tables on write. B) schema on write. C) on demand paging. D) caching. - Answers B) schema on write. 48) Information is processed data. True/False - Answers True 49) Metadata are data that describe the properties of other data. True/False - Answers True 50) Databases were developed as the first application of computers to data processing. True/False - Answers False 61) A relational database establishes the relationships between entities by means of a common field. True/False - Answers True 62) Separation of metadata from application programs that use the data is called data independence. True/False - Answers True 63) Data redundancy is used to establish relationships between data but is never used to improve database performance. True/False - Answers False 64) Redundancy increases the risk of inconsistent data. True/False - Answers True 65) A user view is how the user sees the data when it is produced. True/False - Answers False 103) The relational data model is no longer popular in the 21st century. True/False - Answers False 104) Although personal databases improve productivity, one risk is that data cannot be shared with other users. True/False - Answers True 105) The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database. True/False - Answers True 106) In multi-tier database architectures, little functionality needs to be programmed into the client application. True/False - Answers False 1) The logical representation of an organization's data is called a(n): A) database model. B) entity-relationship model. C) relationship systems design. D) database entity diagram. (Chap 2 - page 56) - Answers B) entity-relationship model. 2) A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties. B) examples. C) who determines the value of the data. D) who can delete the data. - Answers D) who can delete the data. 3) A fact is an association between two or more: A) words. B) terms. C) facts. D) nuggets. - Answers B) terms. 4) Data modeling may be the most important part of the systems development process because: A) data characteristics are important in the design of programs and other systems components. B) the data in a system are generally less complex than processes and play a central role in development. C) data are less stable than processes. D) it is the easiest. - Answers A) data characteristics are important in the design of programs and other systems components. 16) An entity type name should be all of the following EXCEPT: A) concise. B) specific to the organization. C) as short as possible. D) a singular noun. - Answers C) as short as possible. 17) A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function. - Answers A) attribute. 18) An attribute that must be present for every entity (or relationship) instance is a(n): A) composite attribute. B) required attribute. C) optional attribute. D) multivalued attribute. - Answers B) required attribute. 19) A person's name, birthday, and social security number are all examples of: A) attributes. B) entities. C) relationships. D) descriptors. - Answers A) attributes. 20) An attribute of an entity that is computed is a(n): A) optional attribute. B) composite attribute. C) derived attribute. D) fuzzy attribute. - Answers C) derived attribute. 28) The following figure shows an example of: STUDENT: SID Name Address (Street, City, State, ZipCode) A) a composite attribute. B) a relational attribute. C) a derived attribute. D) a multivalued attribute. - Answers A) a composite attribute. 29) In the figure below, which attribute is multivalued? Employee_ID Emplyee_Name Address Date_Employed (Skill) [Years_Employed] A) Years_Employed B) Employee_ID C) Skill D) Address - Answers C) Skill 36) A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) degree B) cardinality constraint C) counter constraint D) limit - Answers B) cardinality constraint (Chap 2 - page 84) 37) A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. A) optional B) unidirectional C) mandatory link D) mandatory one - Answers D) mandatory one 44) A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong - Answers B) many-to-many 45) A value that indicates the date or time of a data value is called a: A) value stamp. B) time stamp. C) checkpoint. D) check counter. - Answers B) time stamp. 46) The E-R model is used to construct a conceptual model. True/False - Answers True 47) A business rule is a statement that defines or constrains some aspect of the business. True/False - Answers True 55) Data names should always relate to business characteristics. True/False - Answers True 56) An example of a term would be the following sentence: "A student registers for a course." True/False - Answers False 57) A fact is an association between two or more terms. True/False - Answers True 58) A good data definition is always accompanied by diagrams, such as the entity-relationship diagram. True/False - Answers True 59) An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. True/False - Answers True 84) It is desirable that no two attributes across all entity types have the same name. True/False - Answers True 85) It is not permissible to associate attributes with relationships. True/False - Answers False 86) A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type. True/False - Answers False 87) One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier. True/False - Answers True