Computer Science > EXAM > CIS 111 Database Midterm exam 2020 – Strayer University | CIS 111 Database Midterm exam 2020 (All)
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 [Show More]
Last updated: 1 year ago
Preview 1 out of 12 pages
Instant download
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
Connected school, study & course
About the document
Uploaded On
Sep 05, 2020
Number of pages
12
Written in
This document has been written for:
Uploaded
Sep 05, 2020
Downloads
0
Views
48
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·