CIS111 - Week 5 Midterm Exam 2020 (A Grade) – Strayer University | CIS111 - Week 5 Midterm Exam 2020 (A Grade)

Document Content and Description Below

CIS111 - Week 5 Midterm Exam 2020 (A Grade) – Strayer University • Question 1 2.5 out of 2.5 points The ____ structure is quite different from that of an operational or transactional da... tabase.   data warehouse   data warehouse • Question 2 2.5 out of 2.5 points A workgroup database is a(n)____ database.   multiuser   multiuser • Question 3 2.5 out of 2.5 points A ____ database supports data distributed across several different sites.   distributed   distributed • Question 4 2.5 out of 2.5 points ____ is the body of information and facts about a specific subject.   Knowledge   Knowledge • Question 5 2.5 out of 2.5 points A ____ is a logically connected set of one or more fields that describes a person, place, or thing.   record   record • Question 6 2.5 out of 2.5 points ____ is used to reveal the meaning of data.   Information   Information • Question 7 2.5 out of 2.5 points The response of the DBMS to a query is the ____.   query result set   query result set • Question 8 2.5 out of 2.5 points A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.   workgroup   workgroup - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - -   data definition language (DDL) • Question 14 2.5 out of 2.5 points Students and classes have a ____ relationship.   many-to-many   many-to-many • Question 15 2.5 out of 2.5 points A(n) ____’s main function is to help you understand the complexities of the real-world environment.   model   model • Question 16 2.5 out of 2.5 points The ____ data model uses the concept of inheritance.   object-oriented   object-oriented • Question 17 2.5 out of 2.5 points The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.   NOT NULL   NOT NULL • Question 18 2.5 out of 2.5 points In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.   keys   keys • Question 19 2.5 out of 2.5 points A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.   table   table • Question 20 2.5 out of 2.5 points Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes—as foreign keys—at least the ____ keys of the tables that are to be linked.   primary   primary • Question 21 2.5 out of 2.5 points Referential ____ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.   integrity   integrity • Question 22 2.5 out of 2.5 points The ____ relationship should be rare in any relational database design.   1:1   1:1 • Question 23 2.5 out of 2.5 points Any attribute that is part of a key is known as a ____.   key attribute   key attribute • Question 24 2.5 out of 2.5 points In the context of a database table, the statement “A ____ B” indicates that if you know the value of attribute A, you can look up the value of attribute B.   determines   determines • Question 25 2.5 out of 2.5 points Knowing the ____ number of entity occurrences is very helpful at the application software level.   maximum and minimum   maximum and minimum • Question 26 2.5 out of 2.5 points A ____ relationship exists when an association is maintained within a single entity.   unary   unary • Question 27 2.5 out of 2.5 points A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.   weak   weak • Question 28 2.5 out of 2.5 points ____ relationships are most common.   Binary   Binary • Question 29 2.5 out of 2.5 points A derived attribute ____.   need not be physically stored within the database   need not be physically stored within the database • Question 30 2.5 out of 2.5 points The Crow’s foot symbol with two parallel lines indicates ____ cardinality.   (1,1)   (1,1) • Question 31 2.5 out of 2.5 points A ____ identifier is composed of more than one attribute. - - - - - - - - - - - - - - - - - - - - - - Before converting a table into 3NF, it is imperative the table already be in ____.   2NF   2NF • Question 35 2.5 out of 2.5 points From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.   derived   derived • Question 36 2.5 out of 2.5 points ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.   Data warehouse   Data warehouse • Question 37 2.5 out of 2.5 points Normalization represents a micro view of the ____ within the ERD.   entities   entities • Question 38 2.5 out of 2.5 points From a structural point of view, 2NF is better than ____.   1NF   1NF • Question 39 2.5 out of 2.5 points A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.   transitive dependency   transitive dependency • Question 40 2.5 out of 2.5 points A table that displays data redundancies yields ____.   anomalies   anomalies [Show More]

Last updated: 2 years ago

Preview 1 out of 12 pages