Kyle Peterson
Quiz by , created more than 1 year ago

Quiz 1 given during Fall 2020 at Minnesota State University, Mankato.

18
0
0
Kyle Peterson
Created by Kyle Peterson over 3 years ago
Close

MNSU CIS 440 Fall 2020 Quiz 1

Question 1 of 34

1

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.

Select one of the following:

  • referential

  • entity

  • secondary

  • restrictive

Explanation

Question 2 of 34

1

Nulls, if used improperly, can create problems because they can represent __________.

Select one of the following:

  • a missing attribute value

  • a default value

  • an unsortable attribute value

  • a zero

Explanation

Question 3 of 34

1

How is a strong relationship depicted in a Crow's Foot ERD?

Select one of the following:

  • no line

  • solid line

  • dotted line

  • double line

Explanation

Question 4 of 34

1

Relational Database model was proposed by?

Select one of the following:

  • Larry Ellison

  • Bill Gates

  • P. Chan

  • E. F. Codd

Explanation

Question 5 of 34

1

BCNF is an extension of 3NF.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 34

1

Repeating groups are eliminated in

Select one of the following:

  • 1NF

  • 2NF

  • 3NF

  • BCNF

Explanation

Question 7 of 34

1

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 ________

Select one of the following:

  • Atomicity

  • Consistency

  • Isolation

  • Durability

Explanation

Question 8 of 34

1

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.

Select one of the following:

  • foreign key

  • composite key

  • super key

  • primary key

Explanation

Question 9 of 34

1

Supertype can have many subtypes.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 34

1

Which one of the following is NOT part of ensuring 1NF?

Select one of the following:

  • Remove repeating groups

  • Remove partial dependencies

  • Remove multi-valued attributes

  • Establish a primary key

Explanation

Question 11 of 34

1

Which of the following type(s) of attributes need not be physically stored within the database?

Select one of the following:

  • Multivalued

  • Composite

  • Derived

  • None of the above

Explanation

Question 12 of 34

1

What is an advantage of a DBMS?

Select one of the following:

  • Data security

  • Data sharing

  • Data access

  • Data backup

  • All of the above

  • None of the above

Explanation

Question 13 of 34

1

Entity supertypes and subtypes are organized in a(n) ______.

Select one of the following:

  • overlapping hierarchy

  • specialization hierarchy

  • linear hierarchy

  • generalization hierarchy

Explanation

Question 14 of 34

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 15 of 34

1

All databases must meet

Select one of the following:

  • 1NF

  • 2NF

  • 3NF

  • 4NF

Explanation

Question 16 of 34

1

Which one of the following is NOT true about a null value?

Select one of the following:

  • An unknown attribute value

  • A known, but missing, attribute value

  • An inapplicable condition

  • A value equal to zero

Explanation

Question 17 of 34

1

An Insert Anomaly occurs when certain attributes are inserted into the database without the presence of other attributes.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 34

1

Which one of the following is NOT mentioned in the Gartner's definition of big data?

Select one of the following:

  • Volume

  • Variety

  • Veracity

  • Velocity

Explanation

Question 19 of 34

1

The ______ adds support for entity supertypes, subtypes, and entity clustering.

Select one of the following:

  • object-oriented model

  • extended entity-relationship model

  • relational model

  • hierarchical entity model

Explanation

Question 20 of 34

1

Which of the following is NOT an example of a multivalued attribute?

Select one of the following:

  • A person's social security number

  • Degree(s) held by a person

  • A car's color(s)

  • Phone number(s) in a household

Explanation

Question 21 of 34

1

___________________ means that every supertype occurence must be a member of at least one subtype.

Select one of the following:

  • Total subtypes

  • Partial completeness

  • Specialization subtypes

  • Total completeness

Explanation

Question 22 of 34

1

An entity in the logical design becomes a ________ in the corresponding physical design.

Select one of the following:

  • database

  • table

  • attribute

  • relationship

Explanation

Question 23 of 34

1

Which one of the following is NOT a relational database?

Select one of the following:

  • SQL Server

  • Oracle

  • MySQL

  • MongoDB

Explanation

Question 24 of 34

1

____________________ is a field that can have many values for a single entity occurence.

Select one of the following:

  • multivalued attribute

  • multivalued entity

  • null

  • repeating group

Explanation

Question 25 of 34

1

Each table must have a ___________ key.

Select one of the following:

  • primary

  • foreign

  • domain

  • composite

Explanation

Question 26 of 34

1

An attribute or a combination of attributes that uniquely identifies any given row is called ____________.

Select one of the following:

  • primary key

  • foreign key

  • composite key

  • All of the above

Explanation

Question 27 of 34

1

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

Select one of the following:

  • True
  • False

Explanation

Question 28 of 34

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 29 of 34

1

How would you graphically identify an entity in a Crow's Foot model ERD?

Select one of the following:

  • a line

  • a square

  • a rectange

  • a diamond

Explanation

Question 30 of 34

1

About 80% of all data are believed to be in unstructured form.

Select one of the following:

  • True
  • False

Explanation

Question 31 of 34

1

CAP Theorem allows multiple user views in relational databases.

Select one of the following:

  • True
  • False

Explanation

Question 32 of 34

1

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.

Select one of the following:

  • verb, entity, noun, relationship

  • noun, entity, verb, relationship

  • noun, relationship, verb, entity

  • verb, relationship, noun, entity

Explanation

Question 33 of 34

1

Which of the following is true of business rules?

Select one of the following:

  • 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.

Explanation

Question 34 of 34

1

A(n) is a restriction placed on the data.

Select one of the following:

  • attribute

  • entity

  • relationship

  • constraint

Explanation

Previous
Next