13202902
Descrição
Quiz por jacob thomas, atualizado more than 1 year ago
|
Criado por jacob thomas
mais de 6 anos atrás
|
|
Questão 1
Questão
The entity integrity rule requires that ____.
Responda
-
all primary key entries are unique
-
a part of the key may be null
-
foreign key values do not reference primary key values
-
duplicate object values are allowed
Questão 2
Questão
The referential integrity rule requires that ____.
Responda
-
every null foreign key value must reference an existing primary key value
-
an attribute have a corresponding value
-
every non-null foreign key value reference an existing primary key value
-
you delete a row in one table whose primary key does not have a matching foreign key value in another table
Questão 3
Questão
The extended entity relationship model (EERM) is sometimes referred to as the ____.
Responda
-
entity relationship model
-
enhanced entity relationship model
-
entity clustering relationship model
-
extended entity relationship diagram
Questão 4
Questão
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
Responda
-
subtype discriminator
-
inheritance
-
specialization hierarchy
-
entity supertype
Questão 5
Questão
Every subtype can have ____ supertype to which it is directly related.
Responda
-
none
-
only one
-
one or many
-
many
Questão 6
Questão
A specialization hierarchy can have ____ levels of supertype/subtype relationships.
Responda
-
none
-
only one
-
one or many
-
many
Questão 7
Questão
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
Responda
-
subtype discriminator
-
inheritance
-
specialization hierarchy
-
entity supertype
Questão 8
Questão
One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
Responda
-
primary key
-
natural key
-
foreign key
-
Surrogate key
Questão 9
Questão
What feature is a DDBMS disadvantage?
Responda
-
Processor independence
-
User-friendly interface
-
Security
-
Faster data access
Questão 10
Questão
What feature is a DDBMS advantage?
Responda
-
Reduced operating cost
-
Complexity of management and control
-
Increased storage requirements
-
Increased training cost
Questão 11
Questão
A database is composed of several parts known as database ____.
Responda
-
sections
-
fragments
-
partitions
-
parts
Questão 12
Questão
Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
Responda
-
single-site processing, single-site data
-
multiple-site processing, single-site data
-
single-site processing, multiple-site data
-
multiple-site processing, multiple-site data
Questão 13
Questão
The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
Responda
-
multiple-site processing, single-site data
-
single-site processing, multiple-site data
-
single-site processing, single-site data
-
multiple-site processing, multiple-site data
Questão 14
Questão
____ distributed database systems integrate only one type of centralized DBMS over a network.
Responda
-
Homogeneous
-
Heterogeneous
-
Fully heterogeneous
-
Fully homogeneous
Questão 15
Questão
____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
Responda
-
Transaction
-
Performance
-
Distribution
-
Heterogeneity
Questão 16
Questão
The ____ contains the description of the entire database as seen by the database administrator.
Responda
-
distributed global dictionary
-
distributed data dictionary
-
distributed global schema
-
distributed data schema
Questão 17
Questão
___ fragmentation allows us to break a single object into two or more segments or fragments.
Responda
-
Horizontal
-
Vertical
-
Data
-
Mixed
Questão 18
Questão
With ____ data allocation, the database is divided into several disjointed parts and stored at several sites.
Responda
-
centralized
-
decentralized
-
partitioned
-
replicated
Questão 19
Questão
The ____ rule requires that all copies of data fragments be identical.
Responda
-
shared fragment
-
mutual consistency
-
horizontal fragmentation
-
replication
Questão 20
Questão
Which of the following is a problem with a centralized database?
Responda
-
High cost
-
Good performance from remote locations
-
Poor performance from the main location
-
Lack of storage
Questão 21
Questão
The components of a data warehouse are ____.
Responda
-
integrated
-
volatile
-
object-oriented
-
decentralized
Questão 22
Questão
Which of the following is a rule that defines the data warehouse?
Responda
-
Environments are integrated
-
Data warehouse contains historical data over a long time horizon
-
Data are object-oriented
-
Data are subject-oriented
Questão 23
Questão
Which of the following is a characteristic of an OLAP?
Responda
-
Uses single dimensional data analysis techniques
-
Provides introductory database support and complex end user interfaces
-
Provides introductory end-user interfaces
-
Supports client/server architecture
Questão 24
Questão
____ data must conform to uniform structures and formats to avoid data conflicts.
Responda
-
Data mart
-
Database
-
Data warehouse
-
Data analysis
Questão 25
Questão
Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.
Responda
-
semidimensional
-
multidimensional
-
one-dimensional
-
two-dimensional
Questão 26
Questão
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Responda
-
online
-
database
-
processing
-
data
Questão 27
Questão
MOLAP's premise is that ___ databases are best suited to manage, store, and analyze multidimensional data.
Responda
-
multidimensional
-
one-dimensional
-
two-dimensional
-
relational.
Questão 28
Questão
The ___ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Responda
-
relational
-
dimensional
-
multidimensional
-
attribute
Questão 29
Questão
During the data ___ phase of data mining, common characteristics or patterns are identified.
Responda
-
analysis
-
preparation
-
extraction
-
acquisition
Questão 30
Questão
During the ___ phase of data mining, the data-mining findings are used to predict future behavior and forecast business outcomes.
Responda
-
analysis and classifications
-
preparation
-
prognosis
-
knowledge acquisition
Questão 31
Questão
The __ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Responda
-
star
-
square
-
OLAP
-
ROLAP
Questão 32
Questão
___ backups take place while the user is working on the database.
Responda
-
Full
-
Incremental
-
Concurrent
-
Sequential
Questão 33
Questão
A ___ is named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
Responda
-
user
-
role
-
profile
-
manager
Questão 34
Questão
At the level of top management the database must be able to ___.
Responda
-
represent and support the company operations as closely as possible
-
deliver the data necessary for tactical decisions and planning
-
produce query results within specified performance levels
-
provide access to external and internal data to identify growth opportunities and to chart the direction of such growth
Questão 35
Questão
As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
Responda
-
control and planning
-
conflict and problem-resolution
-
policies and standards
-
security and privacy
Questão 36
Questão
User-access management is a subset of ____.
Responda
-
password protection
-
authorization management
-
data integrity
-
managerial control
Questão 37
Questão
Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.
Responda
-
user groups
-
sections
-
authorization schemes
-
policy definitions
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.