27877883
Beschreibung
Quiz von Kyle Peterson, aktualisiert more than 1 year ago
|
Erstellt von Kyle Peterson
vor fast 4 Jahre
|
|
Frage 1
Frage
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.
Antworten
-
referential
-
entity
-
secondary
-
restrictive
Frage 2
Frage
Nulls, if used improperly, can create problems because they can represent __________.
Antworten
-
a missing attribute value
-
a default value
-
an unsortable attribute value
-
a zero
Frage 3
Frage
How is a strong relationship depicted in a Crow's Foot ERD?
Antworten
-
no line
-
solid line
-
dotted line
-
double line
Frage 4
Frage
Relational Database model was proposed by?
Antworten
-
Larry Ellison
-
Bill Gates
-
P. Chan
-
E. F. Codd
Frage 5
Frage
BCNF is an extension of 3NF.
Antworten
- True
- False
Frage 6
Frage
Repeating groups are eliminated in
Antworten
-
1NF
-
2NF
-
3NF
-
BCNF
Frage 7
Frage
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 ________
Antworten
-
Atomicity
-
Consistency
-
Isolation
-
Durability
Frage 8
Frage
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.
Antworten
-
foreign key
-
composite key
-
super key
-
primary key
Frage 9
Frage
Supertype can have many subtypes.
Antworten
- True
- False
Frage 10
Frage
Which one of the following is NOT part of ensuring 1NF?
Antworten
-
Remove repeating groups
-
Remove partial dependencies
-
Remove multi-valued attributes
-
Establish a primary key
Frage 11
Frage
Which of the following type(s) of attributes need not be physically stored within the database?
Antworten
-
Multivalued
-
Composite
-
Derived
-
None of the above
Frage 12
Frage
What is an advantage of a DBMS?
Antworten
-
Data security
-
Data sharing
-
Data access
-
Data backup
-
All of the above
-
None of the above
Frage 13
Frage
Entity supertypes and subtypes are organized in a(n) ______.
Antworten
-
overlapping hierarchy
-
specialization hierarchy
-
linear hierarchy
-
generalization hierarchy
Frage 14
Frage
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.
Antworten
- True
- False
Frage 15
Frage
All databases must meet
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 16
Frage
Which one of the following is NOT true about a null value?
Antworten
-
An unknown attribute value
-
A known, but missing, attribute value
-
An inapplicable condition
-
A value equal to zero
Frage 17
Frage
An Insert Anomaly occurs when certain attributes are inserted into the database without the presence of other attributes.
Antworten
- True
- False
Frage 18
Frage
Which one of the following is NOT mentioned in the Gartner's definition of big data?
Antworten
-
Volume
-
Variety
-
Veracity
-
Velocity
Frage 19
Frage
The ______ adds support for entity supertypes, subtypes, and entity clustering.
Antworten
-
object-oriented model
-
extended entity-relationship model
-
relational model
-
hierarchical entity model
Frage 20
Frage
Which of the following is NOT an example of a multivalued attribute?
Antworten
-
A person's social security number
-
Degree(s) held by a person
-
A car's color(s)
-
Phone number(s) in a household
Frage 21
Frage
___________________ means that every supertype occurence must be a member of at least one subtype.
Antworten
-
Total subtypes
-
Partial completeness
-
Specialization subtypes
-
Total completeness
Frage 22
Frage
An entity in the logical design becomes a ________ in the corresponding physical design.
Antworten
-
database
-
table
-
attribute
-
relationship
Frage 23
Frage
Which one of the following is NOT a relational database?
Antworten
-
SQL Server
-
Oracle
-
MySQL
-
MongoDB
Frage 24
Frage
____________________ is a field that can have many values for a single entity occurence.
Antworten
-
multivalued attribute
-
multivalued entity
-
null
-
repeating group
Frage 25
Frage
Each table must have a ___________ key.
Antworten
-
primary
-
foreign
-
domain
-
composite
Frage 26
Frage
An attribute or a combination of attributes that uniquely identifies any given row is called ____________.
Antworten
-
primary key
-
foreign key
-
composite key
-
All of the above
Frage 27
Frage
Referential integrity means that, if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
Antworten
- True
- False
Frage 28
Frage
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.
Antworten
- True
- False
Frage 29
Frage
How would you graphically identify an entity in a Crow's Foot model ERD?
Antworten
-
a line
-
a square
-
a rectange
-
a diamond
Frage 30
Frage
About 80% of all data are believed to be in unstructured form.
Antworten
- True
- False
Frage 31
Frage
CAP Theorem allows multiple user views in relational databases.
Antworten
- True
- False
Frage 32
Frage
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.
Antworten
-
verb, entity, noun, relationship
-
noun, entity, verb, relationship
-
noun, relationship, verb, entity
-
verb, relationship, noun, entity
Frage 33
Frage
Which of the following is true of business rules?
Antworten
-
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.
Frage 34
Frage
A(n) is a restriction placed on the data.
Antworten
-
attribute
-
entity
-
relationship
-
constraint
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.