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