CIS 111 Database Midterm exam 2020 – Strayer University | CIS 111 Database Midterm exam 2020

CIS 111 Database Midterm exam 2020 – Strayer University • Question 1 2.5 out of 2.5 points The ____ structure is quite different from that of an operational or transactional database.   data ware ...

CIS 111 Database Midterm exam 2020 – Strayer University • Question 1 2.5 out of 2.5 points The ____ structure is quite different from that of an operational or transactional database.   data warehouse   data warehouse • Question 2 2.5 out of 2.5 points A ____ is a character or group of characters that has a specific meaning.   field   field • Question 3 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 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(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.   workgroup   workgroup • Question 6 2.5 out of 2.5 points A ____ database supports data distributed across several different sites.   distributed   distributed • 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 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.   Metadata   Metadata • Question 9 2.5 out of 2.5 points A noun in a business rule translates to a(n) ____ in the data model.   entity   entity • Question 10 2.5 out of 2.5 points A(n) ____ enables a database administrator to define schema components.   data definition language (DDL)   data definition language (DDL) • Question 11 2.5 out of 2.5 points A(n) ____ is anything about which data are to be collected and stored.   entity   entity - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - A(n) ____ join only returns matched records from the tables that are being joined.   inner   inner • Question 23 2.5 out of 2.5 points A ____ is any key that uniquely identifies each row.   superkey   superkey • Question 24 2.5 out of 2.5 points A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.   table   table • Question 25 2.5 out of 2.5 points A ____ relationship exists when two entities are associated.   binary   binary • Question 26 2.5 out of 2.5 points A relationship is an association between ____.   entities   entities • Question 27 2.5 out of 2.5 points The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.   weak   weak • Question 28 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 29 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 30 2.5 out of 2.5 points An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.   existence   existence • Question 31 2.5 out of 2.5 points Ideally, an entity identifier is composed of ____ attribute(s).   one   one • Question 32 2.5 out of 2.5 points A ____ identifier is composed of more than one attribute.   composite   composite • Question 33 2.5 out of 2.5 points A relational table must not contain a(n) ____.   repeating group   repeating group • Question 34 2.5 out of 2.5 points Normalization represents a micro view of the ____ within the ERD.   entities   entities • Question 35 2.5 out of 2.5 points A table that is in 2NF and contains no transitive dependencies is said to be in ____.   3NF   3NF • Question 36 2.5 out of 2.5 points Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to go in the normalization process.   three   three • Question 37 2.5 out of 2.5 points For most business transactional databases, we should normalize relations into ____.   3NF   3NF • Question 38 2.5 out of 2.5 points A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.   1NF   1NF • Question 39 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 40 2.5 out of 2.5 points An atomic attribute ____.   cannot be further subdivided   cannot be further subdivided