CIS 111 Midterm Exam Updated
Check this A+ tutorial guideline at
http://www.homeworkrank.com/cis-111-strayer/cis-111-midterm-exam-updated
For more classes visit
CIS 111 Midterm Exam Updated
Set 1
• Question 1____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
• Question 2 A desktop database is a ____ database.
• Question 3 End-user data is ____.
• Question 4 A ____ database supports data distributed across several different sites.
• Question 5 ____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
• Question 6 A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
• Question 7 A ____ is a character or group of characters that has a specific meaning.
• Question 8 ____ exists when different versions of the same data appear in different places.
• Question 9 The ____ model is the end users’ view of the data environment.
• Question 10 A(n) ____ represents a particular type of object in the real world.
• Question 11 A(n) ____ is anything about which data are to be collected and stored.
• Question 12 A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
• Question 13 A(n) ____ is a restriction placed on the data.
• Question 14 In the ____ model, the basic logical structure is represented as an upside-down tree.
• Question 15 In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
• Question 16 A noun in a business rule translates to a(n) ____ in the data model.
• Question 17 A(n) ____ join only returns matched records from the tables that are being joined.
• Question 18 A ____ is any key that uniquely identifies each row.
• Question 19 The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
• Question 20 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
• Question 21 ____ combines all rows from two tables, excluding duplicate rows.
• Question 22 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.
• Question 23 ____ yields only the rows that appear in both tables.
• Question 24 A(n) ____ is an ordered arrangement of keys and pointers.
• Question 25 A ____ relationship exists when an association is maintained within a single entity.
• Question 26 A ____ relationship exists when three entities are associated.
• Question 27 A ____ identifier is composed of more than one attribute.
• Question 28 A ____ should be a derived attribute.
• Question 29 If an entity can exist apart from one or more related entities, it is said to be ____-independent.
• Question 30 An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
• Question 31 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
• Question 32 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 ____.
• Question 33 From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
• Question 34 A table that displays data redundancies yields ____.
• Question 35 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 ____.
• Question 36 The most likely data type for a surrogate key is ____.
• Question 37 ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
• Question 38 A table that is in 1NF and includes no partial dependencies is said to be in ____.
• Question 39 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.
• Question 40 1NF, 2NF, and 3NF are ____.
Set 2
Question 1 Correct ____ is used to reveal the meaning of data.
. Question 2 Correct A(n) ____ database is designed to support a company’s day-to-day operations.
. Question 3 Correct ____ exists when different versions of the same data appear in different places.
. Question 4 Correct A desktop database is a ____ database.
. Question 5 Correct A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
. Question 6 Correct A ____ database supports data distributed across several different sites.
. Question 7 Correct End-user data is ____.
. Question 8 Correct A ____ is a character or group of characters that has a specific meaning.
. Question 9 Correct The ____ data model uses the concept of inheritance.
. Question 10 Correct In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
. Question 11 Correct A(n) ____ represents a particular type of object in the real world.
. Question 12 Correct A(n) ____ is a restriction placed on the data.
. Question 13 Correct A(n) ____’s main function is to help you understand the complexities of the real-world environment.
. Question 14 Correct A noun in a business rule translates to a(n) ____ in the data model.
. Question 15 Incorrect In the ____ model, each parent can have many children, but each child has only one parent.
. Question 16 Correct A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
. Question 17 Correct A ____ is any key that uniquely identifies each row.
. Question 18 Correct Referential ____ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
. Question 19 Correct A(n) ____ is an ordered arrangement of keys and pointers.
. Question 20 Correct Any attribute that is part of a key is known as a ____.
. Question 21 Correct All primary key entries are unique, and no part of a primary key may be ____.
. Question 22 Correct 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.
. Question 23 Correct A ____ contains at least all of the attribute names and characteristics for each table in the system.
. Question 24 Correct The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
. Question 25 Correct Ideally, an entity identifier is composed of ____ attribute(s).
. Question 26 Correct A relationship is an association between ____.
. Question 27 Correct Another word for existence-independent is ____.
. Question 28 Correct If an entity can exist apart from one or more related entities, it is said to be ____-independent.
. Question 29 Correct Knowing the ____ number of entity occurrences is very helpful at the application software level.
. Question 30 Correct A ____ relationship exists when an association is maintained within a single entity.
. Question 31 Correct A ____ identifier is composed of more than one attribute.
. Question 32 Correct A ____ should be a derived attribute.
. Question 33 Correct An atomic attribute ____.
. Question 34 Correct 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 ____.
. Question 35 Correct A relational table must not contain a(n) ____.
. Question 36 Correct 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.
. Question 37 Correct Normalization represents a micro view of the ____ within the ERD.
. Question 38 Incorrect A table that is in 2NF and contains no transitive dependencies is said to be in ____.
. Question 39 Correct The most likely data type for a surrogate key is ____.
. Question 40 Correct ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Set 3
• Question 1 A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
• Question 2 A ____ database supports data distributed across several different sites.
• Question 3 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
• Question 4 ____ is the body of information and facts about a specific subject.
• Question 5 A ____ is a logically connected set of one or more fields that describes a person, place, or thing.
• Question 6 End-user data is ____.
• Question 7 ____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
• Question 8 The ____ structure is quite different from that of an operational or transactional database.
• Question 9 A(n) ____ is bidirectional.
• Question 10 In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
• Question 11 A(n) ____’s main function is to help you understand the complexities of the real-world environment.
• Question 12 In the ____ model, the basic logical structure is represented as an upside-down tree.
• Question 13 ____ are important because they help to ensure data integrity.
• Question 14 The ____ model is the end users’ view of the data environment.
• Question 15 A noun in a business rule translates to a(n) ____ in the data model.
• Question 16 A(n) ____ represents a particular type of object in the real world.
• Question 17 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.
• Question 18 Referential ____ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
• Question 19 All primary key entries are unique, and no part of a primary key may be ____.
• Question 20 A ____ contains at least all of the attribute names and characteristics for each table in the system.
• Question 21 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.
• Question 22 A(n) ____ is an ordered arrangement of keys and pointers.
• Question 23 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
• Question 24 ____ combines all rows from two tables, excluding duplicate rows.
• Question 25 Another word for existence-independent is ____.
• Question 26 An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
• Question 27 A derived attribute ____.
• Question 28 Knowing the ____ number of entity occurrences is very helpful at the application software level.
• Question 29 A ____ relationship exists when three entities are associated.
• Question 30 If an entity can exist apart from one or more related entities, it is said to be ____-independent.
• Question 31 A ____ should be a derived attribute.
• Question 32 A relationship is an association between ____.
• Question 33 Before converting a table into 3NF, it is imperative the table already be in ____.
• Question 34 From a structural point of view, 2NF is better than ____.
• Question 35 For most business transactional databases, we should normalize relations into ____.
• Question 36 ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
• Question 37 A table that displays data redundancies yields ____.
• Question 38 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.
• Question 39 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 ____.
• Question 40 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.
Set 4
• Question 1 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
• Question 2 ____ data exist in a format that does not lend itself to processing that yields information.
• Question 3 A ____ is a logically connected set of one or more fields that describes a person, place, or thing.
• Question 4 End-user data is ____.
• Question 5 ____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
• Question 6 A ____ is a character or group of characters that has a specific meaning.
• Question 7 A desktop database is a ____ database.
• Question 8 A ____ database supports data distributed across several different sites.
• Question 9 A(n) ____ enables a database administrator to define schema components.
• Question 10 A(n) ____ is anything about which data are to be collected and stored.
• Question 11 A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
• Question 12 A(n) ____’s main function is to help you understand the complexities of the real-world environment.
• Question 13 A(n) ____ model represents a global view of the database as viewed by the entire organization.
• Question 14 The ____ model is the end users’ view of the data environment.
• Question 15 A(n) ____ is a restriction placed on the data.
• Question 16 ____ are important because they help to ensure data integrity.
• Question 17 A ____ contains at least all of the attribute names and characteristics for each table in the system.
• Question 18 Any attribute that is part of a key is known as a ____.
• Question 19 ____ combines all rows from two tables, excluding duplicate rows.
• Question 20 A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.
• Question 21 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.
• Question 22 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.
• Question 23 A(n) ____ join only returns matched records from the tables that are being joined.
• Question 24 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
• Question 25 A ____ identifier is composed of more than one attribute.
• Question 26 An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
• Question 27 Another word for existence-independent is ____.
• Question 28 A ____ relationship exists when an association is maintained within a single entity.
• Question 29 Knowing the ____ number of entity occurrences is very helpful at the application software level.
• Question 30 A ____ relationship exists when three entities are associated.
• Question 31 A ____ should be a derived attribute.
• Question 32 Ideally, an entity identifier is composed of ____ attribute(s).
• Question 33 An atomic attribute ____.
• Question 34 A table that is in 2NF and contains no transitive dependencies is said to be in ____.
• Question 35 ____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
• Question 36 A table that displays data redundancies yields ____.
• Question 37 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 ____.
• Question 38 Normalization represents a micro view of the ____ within the ERD.
• Question 39 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.
• Question 40 A relational table must not contain a(n) ____.
Set 5
• Question 1 A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
• Question 2 A(n) ____ database is designed to support a company’s day-to-day operations.
• Question 3 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
• Question 4 The response of the DBMS to a query is the ____.
• Question 5 A workgroup database is a(n)____ database.
• Question 6 The ____ structure is quite different from that of an operational or transactional database.
• Question 7 ____ is used to reveal the meaning of data.
• Question 8 A desktop database is a ____ database.
• Question 9 A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
• Question 10 A(n) ____ is anything about which data are to be collected and stored.
• Question 11 In the ____ model, the basic logical structure is represented as an upside-down tree.
• Question 12 A(n) ____ enables a database administrator to define schema components.
• Question 13 A(n) ____ represents a particular type of object in the real world.
• Question 14 The ____ model is the end users’ view of the data environment.
• Question 15 A(n) ____’s main function is to help you understand the complexities of the real-world environment.
• Question 16 Students and classes have a ____ relationship.
• Question 17 A(n) ____ join only returns matched records from the tables that are being joined.
• Question 18 A(n) ____ is an ordered arrangement of keys and pointers.
• Question 19 ____ combines all rows from two tables, excluding duplicate rows.
• Question 20 In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.
• Question 21 A ____ is any key that uniquely identifies each row.
• Question 22 The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
• Question 23 A ____ contains at least all of the attribute names and characteristics for each table in the system.
• Question 24 ____ yields only the rows that appear in both tables.
• Question 25 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 ____.
• Question 26 A relationship is an association between ____.
• Question 27 A ____ relationship exists when an association is maintained within a single entity.
• Question 28 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
• Question 29 ____ relationships are most common.
• Question 30 A ____ identifier is composed of more than one attribute.
• Question 31 An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
• Question 32 If an entity can exist apart from one or more related entities, it is said to be ____-independent.
• Question 33 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.
• Question 34 An atomic attribute ____.
• Question 35 1NF, 2NF, and 3NF are ____.
• Question 36 A table that displays data redundancies yields ____.
• Question 37 From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
• Question 38 From a structural point of view, 2NF is better than ____.
• Question 39 Normalization represents a micro view of the ____ within the ERD.
• Question 40 For most business transactional databases, we should normalize relations into ____.
Set 6
• Question 1 A desktop database is a ____ database.
• Question 2 A(n) ____ database is designed to support a company’s day-to-day operations.
• Question 3 The response of the DBMS to a query is the ____.
• Question 4 A workgroup database is a(n)____ database.
• Question 5 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
• Question 6 ____ is the body of information and facts about a specific subject.
• Question 7 A ____ database supports data distributed across several different sites.
• Question 8 ____ is used to reveal the meaning of data.
Selected Answer:
• Question 9 A(n) ____’s main function is to help you understand the complexities of the real-world environment.
• Question 10 A noun in a business rule translates to a(n) ____ in the data model.
• Question 11 ____ are important because they help to ensure data integrity.
• Question 12 A(n) ____ is a restriction placed on the data.
• Question 13 A(n) ____ model represents a global view of the database as viewed by the entire organization.
• Question 14 The ____ model is the end users’ view of the data environment.
• Question 15 The ____ data model uses the concept of inheritance.
• Question 16 In the ____ model, each parent can have many children, but each child has only one parent.
• Question 17 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.
• Question 18 All primary key entries are unique, and no part of a primary key may be ____.
• Question 19 ____ yields only the rows that appear in both tables.
• Question 20____ combines all rows from two tables, excluding duplicate rows.
• Question 21 The ____ relationship should be rare in any relational database design.
• Question 22 A(n) ____ join only returns matched records from the tables that are being joined.
• Question 23 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
• Question 24 A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.
• Question 25 A ____ should be a derived attribute.
• Question 26 A relationship is an association between ____.
• Question 27 Ideally, an entity identifier is composed of ____ attribute(s).
• Question 28 An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
• Question 29 A derived attribute ____.
• Question 30 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 ____.
• Question 31 Knowing the ____ number of entity occurrences is very helpful at the application software level.
• Question 32 A ____ relationship exists when three entities are associated.
• Question 33 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.
• Question 34 For most business transactional databases, we should normalize relations into ____.
• Question 35 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 ____.
Selected Answer:
• Question 36 A table that displays data redundancies yields ____.
• Question 37___ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
• Question 38 Before converting a table into 3NF, it is imperative the table already be in ____.
• Question 39 The most likely data type for a surrogate key is ____.
• Question 40 An atomic attribute ____.