Copy and Edit

MNSU CIS 440 Fall 2020 Quiz 1

Description

Quiz 1 given during Fall 2020 at Minnesota State University, Mankato.
Kyle Peterson
Quiz by Kyle Peterson, updated more than 1 year ago
Kyle Peterson
Created by Kyle Peterson over 3 years ago
18
0
0

Resource summary

Question 1

Question
If a foreign key contains either matching values or nulls, the tables that make use of such a foreign key are said to exhibit ________ integrity.
Answer
  • referential
  • entity
  • secondary
  • restrictive

Question 2

Question
Nulls, if used improperly, can create problems because they can represent __________.
Answer
  • a missing attribute value
  • a default value
  • an unsortable attribute value
  • a zero

Question 3

Question
How is a strong relationship depicted in a Crow's Foot ERD?
Answer
  • no line
  • solid line
  • dotted line
  • double line

Question 4

Question
Relational Database model was proposed by?
Answer
  • Larry Ellison
  • Bill Gates
  • P. Chan
  • E. F. Codd

Question 5

Question
BCNF is an extension of 3NF.
Answer
  • True
  • False

Question 6

Question
Repeating groups are eliminated in
Answer
  • 1NF
  • 2NF
  • 3NF
  • BCNF

Question 7

Question
Relational 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 ________
Answer
  • Atomicity
  • Consistency
  • Isolation
  • Durability

Question 8

Question
In 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.
Answer
  • foreign key
  • composite key
  • super key
  • primary key

Question 9

Question
Supertype can have many subtypes.
Answer
  • True
  • False

Question 10

Question
Which one of the following is NOT part of ensuring 1NF?
Answer
  • Remove repeating groups
  • Remove partial dependencies
  • Remove multi-valued attributes
  • Establish a primary key

Question 11

Question
Which of the following type(s) of attributes need not be physically stored within the database?
Answer
  • Multivalued
  • Composite
  • Derived
  • None of the above

Question 12

Question
What is an advantage of a DBMS?
Answer
  • Data security
  • Data sharing
  • Data access
  • Data backup
  • All of the above
  • None of the above

Question 13

Question
Entity supertypes and subtypes are organized in a(n) ______.
Answer
  • overlapping hierarchy
  • specialization hierarchy
  • linear hierarchy
  • generalization hierarchy

Question 14

Question
Big 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.
Answer
  • True
  • False

Question 15

Question
All databases must meet
Answer
  • 1NF
  • 2NF
  • 3NF
  • 4NF

Question 16

Question
Which one of the following is NOT true about a null value?
Answer
  • An unknown attribute value
  • A known, but missing, attribute value
  • An inapplicable condition
  • A value equal to zero

Question 17

Question
An Insert Anomaly occurs when certain attributes are inserted into the database without the presence of other attributes.
Answer
  • True
  • False

Question 18

Question
Which one of the following is NOT mentioned in the Gartner's definition of big data?
Answer
  • Volume
  • Variety
  • Veracity
  • Velocity

Question 19

Question
The ______ adds support for entity supertypes, subtypes, and entity clustering.
Answer
  • object-oriented model
  • extended entity-relationship model
  • relational model
  • hierarchical entity model

Question 20

Question
Which of the following is NOT an example of a multivalued attribute?
Answer
  • A person's social security number
  • Degree(s) held by a person
  • A car's color(s)
  • Phone number(s) in a household

Question 21

Question
___________________ means that every supertype occurence must be a member of at least one subtype.
Answer
  • Total subtypes
  • Partial completeness
  • Specialization subtypes
  • Total completeness

Question 22

Question
An entity in the logical design becomes a ________ in the corresponding physical design.
Answer
  • database
  • table
  • attribute
  • relationship

Question 23

Question
Which one of the following is NOT a relational database?
Answer
  • SQL Server
  • Oracle
  • MySQL
  • MongoDB

Question 24

Question
____________________ is a field that can have many values for a single entity occurence.
Answer
  • multivalued attribute
  • multivalued entity
  • null
  • repeating group

Question 25

Question
Each table must have a ___________ key.
Answer
  • primary
  • foreign
  • domain
  • composite

Question 26

Question
An attribute or a combination of attributes that uniquely identifies any given row is called ____________.
Answer
  • primary key
  • foreign key
  • composite key
  • All of the above

Question 27

Question
Referential integrity means that, if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
Answer
  • True
  • False

Question 28

Question
A 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.
Answer
  • True
  • False

Question 29

Question
How would you graphically identify an entity in a Crow's Foot model ERD?
Answer
  • a line
  • a square
  • a rectange
  • a diamond

Question 30

Question
About 80% of all data are believed to be in unstructured form.
Answer
  • True
  • False

Question 31

Question
CAP Theorem allows multiple user views in relational databases.
Answer
  • True
  • False

Question 32

Question
As 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.
Answer
  • verb, entity, noun, relationship
  • noun, entity, verb, relationship
  • noun, relationship, verb, entity
  • verb, relationship, noun, entity

Question 33

Question
Which of the following is true of business rules?
Answer
  • They allow the designer to set company policies with regard to data.
  • They allow the designer to develop business processes.
  • They can serve as a communication tool between the users and designers.
  • They provide a framework for the company's self-actualization.

Question 34

Question
A(n) is a restriction placed on the data.
Answer
  • attribute
  • entity
  • relationship
  • constraint
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

CCNA Security 210-260 IINS - Exam 3
Mike M
Application of technology in learning
Jeff Wall
Innovative Uses of Technology
John Marttila
Ch1 - The nature of IT Projects
mauricio5509
The Internet
Gee_0599
SQL Quiz
R M
CCNA Answers – CCNA Exam
Abdul Demir
Translations and transformations of functions
Christine Laurich
Professional, Legal, and Ethical Issues in Information Security
mfundo.falteni
System Analysis
R A
Flash Cards Networks
JJ Pro Wrestler
Browse Library