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

Document Content and Description Below

CIS 111 - Week 5 Midterm Exam (A Grade) – Strayer University Question 1 2.5 out of 2.5 points   ____ provide(s) a description of the data characteristics and the set of relationships th ... at link the data found within the database. Metadata Metadata Question 2 2.5 out of 2.5 points   ____ exists when different versions of the same data appear in different places. Data inconsistency Data inconsistency Question 3 2.5 out of 2.5 points   A workgroup database is a(n)____ database. multiuser multiuser Question 4 2.5 out of 2.5 points   A(n) ____ database is designed to support a company’s day-to-day operations. transactional transactional Question 5 2.5 out of 2.5 points   ____ data exist in a format that does not lend itself to processing that yields information. Unstructured Unstructured 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 ____ structure is quite different from that of an operational or transactional database. data warehouse data warehouse Question 8 2.5 out of 2.5 points   The response of the DBMS to a query is the ____. query result set query result set 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   In the ____ model, each parent can have many children, but each child has only one parent. hierarchical hierarchical Question 11 2.5 out of 2.5 points   Students and classes have a ____ relationship. many-to-many many-to-many Question 12 2.5 out of 2.5 points   The ____ data model uses the concept of inheritance. object-oriented object-oriented - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - 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   Ideally, an entity identifier is composed of ____ attribute(s). one one Question 26 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 27 2.5 out of 2.5 points   A ____ should be a derived attribute. person’s age person’s age Question 28 2.5 out of 2.5 points   A ____ relationship exists when two entities are associated. binary binary Question 29 2.5 out of 2.5 points   Another word for existence-independent is ____. strong strong 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   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 32 2.5 out of 2.5 points   ____ relationships are most common. Binary Binary 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   From a structural point of view, 2NF is better than ____. 1NF 1NF Question 35 2.5 out of 2.5 points   Before converting a table into 3NF, it is imperative the table already be in ____. 2NF 2NF Question 36 2.5 out of 2.5 points   For most business transactional databases, we should normalize relations into ____. 3NF 3NF Question 37 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 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   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 40 2.5 out of 2.5 points   A table that displays data redundancies yields ____. anomalies anomalies [Show More]

Last updated: 3 years ago

Preview 1 out of 17 pages