Quiz
MNSU CIS 440 Fall 2020 Quiz 1
Questions in this quiz (34)
1If a foreign key contains either matching values or nulls, the tables that make use of such a foreign key are said to exhibit ________ integrity.
- Areferential
- Bentity
- Csecondary
- Drestrictive
2Nulls, if used improperly, can create problems because they can represent __________.
- Aa missing attribute value
- Ba default value
- Can unsortable attribute value
- Da zero
3How is a strong relationship depicted in a Crow's Foot ERD?
- Ano line
- Bsolid line
- Cdotted line
- Ddouble line
4Relational Database model was proposed by?
- ALarry Ellison
- BBill Gates
- CP. Chan
- DE. F. Codd
5BCNF is an extension of 3NF.
- ATrue
- BFalse
6Repeating groups are eliminated in
- A1NF
- B2NF
- C3NF
- DBCNF
7Relational databases follow ACID transactions. They do not allow multiple transactions occuring at the same time to impact each others execution. This particular characteristic of ACID is called ________
- AAtomicity
- BConsistency
- CIsolation
- DDurability
8In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ______ in a second table.
- Aforeign key
- Bcomposite key
- Csuper key
- Dprimary key
9Supertype can have many subtypes.
- ATrue
- BFalse
10Which one of the following is NOT part of ensuring 1NF?
- ARemove repeating groups
- BRemove partial dependencies
- CRemove multi-valued attributes
- DEstablish a primary key
11Which of the following type(s) of attributes need not be physically stored within the database?
- AMultivalued
- BComposite
- CDerived
- DNone of the above
12What is an advantage of a DBMS?
- AData security
- BData sharing
- CData access
- DData backup
- EAll of the above
- FNone of the above
13Entity supertypes and subtypes are organized in a(n) ______.
- Aoverlapping hierarchy
- Bspecialization hierarchy
- Clinear hierarchy
- Dgeneralization hierarchy
14Big data is a collection of datasets so large and complex that it becomes difficult to process using traditional database management tools or data processing applications.
- ATrue
- BFalse
15All databases must meet
- A1NF
- B2NF
- C3NF
- D4NF
16Which one of the following is NOT true about a null value?
- AAn unknown attribute value
- BA known, but missing, attribute value
- CAn inapplicable condition
- DA value equal to zero
17An Insert Anomaly occurs when certain attributes are inserted into the database without the presence of other attributes.
- ATrue
- BFalse
18Which one of the following is NOT mentioned in the Gartner's definition of big data?
- AVolume
- BVariety
- CVeracity
- DVelocity
19The ______ adds support for entity supertypes, subtypes, and entity clustering.
- Aobject-oriented model
- Bextended entity-relationship model
- Crelational model
- Dhierarchical entity model
20Which of the following is NOT an example of a multivalued attribute?
- AA person's social security number
- BDegree(s) held by a person
- CA car's color(s)
- DPhone number(s) in a household
21___________________ means that every supertype occurence must be a member of at least one subtype.
- ATotal subtypes
- BPartial completeness
- CSpecialization subtypes
- DTotal completeness
22An entity in the logical design becomes a ________ in the corresponding physical design.
- Adatabase
- Btable
- Cattribute
- Drelationship
23Which one of the following is NOT a relational database?
- ASQL Server
- BOracle
- CMySQL
- DMongoDB
24____________________ is a field that can have many values for a single entity occurence.
- Amultivalued attribute
- Bmultivalued entity
- Cnull
- Drepeating group
25Each table must have a ___________ key.
- Aprimary
- Bforeign
- Cdomain
- Dcomposite
26An attribute or a combination of attributes that uniquely identifies any given row is called ____________.
- Aprimary key
- Bforeign key
- Ccomposite key
- DAll of the above
27Referential integrity means that, if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
- ATrue
- BFalse
28A surrogate primary key is an "artificial" primary key that is used to uniquely identify each entity occurrence when there is no good natural key available.
- ATrue
- BFalse
29How would you graphically identify an entity in a Crow's Foot model ERD?
- Aa line
- Ba square
- Ca rectange
- Da diamond
30About 80% of all data are believed to be in unstructured form.
- ATrue
- BFalse
31CAP Theorem allows multiple user views in relational databases.
- ATrue
- BFalse
32As a general rule, a ______________ in a business rule will translate into a(n) ___________ in the model, and a(n) ___________ associating nouns will translate into a(n) ___________ among the entities.
- Averb, entity, noun, relationship
- Bnoun, entity, verb, relationship
- Cnoun, relationship, verb, entity
- Dverb, relationship, noun, entity
33Which of the following is true of business rules?
- AThey allow the designer to set company policies with regard to data.
- BThey allow the designer to develop business processes.
- CThey can serve as a communication tool between the users and designers.
- DThey provide a framework for the company's self-actualization.
34A(n) is a restriction placed on the data.
- Aattribute
- Bentity
- Crelationship
- Dconstraint
Information
- Description
- Quiz 1 given during Fall 2020 at Minnesota State University, Mankato.
- Author
- Kyle Peterson
- Language
- English
- Views
- 32
- Tags
- Rating
- No ratings yet Rate this quiz