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