CIS 111- Week 5 Mid-tern Exam (2020) – Strayer University | Introduction to Relative Data bases Management

Document Content and Description Below

CIS111- Week 5 Mid-tern Exam (2020) INTRO TO Relative Data bases Management – Strayer University • Question 1 2.5 out of 2.5 points ____ relates to the activities that make the databa... se perform more efficiently in terms of storage and access speed.   Performance tuning   Performance tuning • Question 2 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 3 2.5 out of 2.5 points ____ is used to reveal the meaning of data.   Information   Information • 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 ____ exists when different versions of the same data appear in different places.   Data inconsistency   Data inconsistency • Question 6 2.5 out of 2.5 points End-user data is ____.   raw facts of interest to the end-user   raw facts of interest to the end-user • Question 7 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 8 2.5 out of 2.5 points A ____ is a character or group of characters that has a specific meaning.   field   field • Question 9 2.5 out of 2.5 points A verb associating two nouns in a business rule translates to a(n) ____ in the data model.   relationship   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - A ____ is any key that uniquely identifies each row.   superkey   superkey • Question 22 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 23 2.5 out of 2.5 points A(n) ____ is an ordered arrangement of keys and pointers.   index   index • Question 24 2.5 out of 2.5 points ____ yields only the rows that appear in both tables.   INTERSECT   INTERSECT • Question 25 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 26 2.5 out of 2.5 points Another word for existence-independent is ____.   strong   strong • Question 27 2.5 out of 2.5 points A ____ relationship exists when two entities are associated.   binary   binary • Question 28 2.5 out of 2.5 points ____ relationships are most common.   Binary   Binary • Question 29 2.5 out of 2.5 points Ideally, an entity identifier is composed of ____ attribute(s).   one   one • Question 30 2.5 out of 2.5 points A ____ relationship exists when three entities are associated.   ternary   ternary • Question 31 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 32 0 out of 2.5 points A ____ identifier is composed of more than one attribute.   primary   composite • Question 33 2.5 out of 2.5 points The most likely data type for a surrogate key is ____.   Numeric   Numeric • Question 34 2.5 out of 2.5 points A relational table must not contain a(n) ____.   repeating group   repeating group • Question 35 2.5 out of 2.5 points A table that displays data redundancies yields ____.   anomalies   anomalies • Question 36 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 37 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 38 2.5 out of 2.5 points Before converting a table into 3NF, it is imperative the table already be in ____.   2NF   2NF • Question 39 2.5 out of 2.5 points 1NF, 2NF, and 3NF are ____.   normalization stages   normalization stages • Question 40 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 [Show More]

Last updated: 2 years ago

Preview 1 out of 12 pages