Copy and Edit

C192 DataStorage / DML / Data Architectures

Description

College C192 Databases Quiz on C192 DataStorage / DML / Data Architectures, created by Craig Willey on 29/06/2020.
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey over 4 years ago
7
0
0

Resource summary

Question 1

Question
The entity integrity rule requires that ____.
Answer
  • 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

Question 2

Question
The referential integrity rule requires that ____.
Answer
  • every null foreign key value must refer-ence 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

Question 3

Question
The extended entity relationship model (EERM) is sometimes referred to as the ____.
Answer
  • entity relationship model
  • enhanced entity relationship model
  • entity clustering relationship model
  • extended entity relationship diagram

Question 4

Question
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
Answer
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Question 5

Question
Every subtype can have ____ supertype to which it is directly related.
Answer
  • none
  • only one
  • one or many
  • many

Question 6

Question
A specialization hierarchy can have ____ levels of supertype/subtype relationships.
Answer
  • none
  • only one
  • one or many
  • many

Question 7

Question
The property of ____ enables an entity subtype to inherit the attributes and relationships of the su-pertype.
Answer
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Question 8

Question
One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
Answer
  • primary key
  • natural key
  • foreign key
  • Surrogate key

Question 9

Question
What feature is a DDBMS disadvantage?
Answer
  • Processor independence
  • User-friendly interface
  • Security
  • Faster data access

Question 10

Question
What feature is a DDBMS advantage?
Answer
  • Reduced operating cost
  • Complexity of management and control
  • Increased storage requirements
  • Increased training cost

Question 11

Question
A database is composed of several parts known as database ____.
Answer
  • sections
  • fragments
  • partitions
  • parts

Question 12

Question
Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
Answer
  • single-site processing, single-site data
  • multiple-site processing, single-site data
  • single-site processing, multiple-site data
  • multiple-site processing, multiple-site data

Question 13

Question
The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
Answer
  • multiple-site processing, single-site data
  • single-site processing, multiple-site data
  • single-site processing, single-site data
  • multiple-site processing, multiple-site data

Question 14

Question
____ distributed database systems integrate only one type of centralized DBMS over a network.
Answer
  • Homogeneous
  • Heterogeneous
  • Fully heterogeneous
  • Fully homogeneous

Question 15

Question
____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
Answer
  • Transaction
  • Performance
  • Distribution
  • Heterogeneity

Question 16

Question
The ____ contains the description of the entire database as seen by the database administrator.
Answer
  • distributed global dictionary
  • distributed data dictionary
  • distributed global schema
  • distributed data schema

Question 17

Question
____ fragmentation allows us to break a single object into two or more segments or fragments.
Answer
  • Horizontal
  • Vertical
  • Data
  • Mixed

Question 18

Question
With ____ data allocation, the database is divided into several disjointed parts and stored at sev-eral sites.
Answer
  • centralized
  • decentralized
  • partitioned
  • replicated

Question 19

Question
The ____ rule requires that all copies of data fragments be identical.
Answer
  • shared fragment
  • mutual consistency
  • horizontal fragmentation
  • replication

Question 20

Question
Which of the following is a problem with a centralized database?
Answer
  • High cost
  • Good performance from remote locations
  • Poor performance from the main location
  • Lack of storage

Question 21

Question
The components of a data warehouse are ____.
Answer
  • integrated
  • volatile
  • object-oriented
  • decentralized

Question 22

Question
Which of the following is a rule that defines the data warehouse?
Answer
  • Environments are integrated
  • Data warehouse contains historical data over a long time horizon
  • Data are object-oriented
  • Data are subject-oriented

Question 23

Question
Which of the following is a characteristic of an OLAP?
Answer
  • Uses single dimensional data analysis techniques
  • Provides introductory database support and complex end user interfaces
  • Provides introductory end-user interfaces
  • Supports client/server architecture

Question 24

Question
____ data must conform to uniform structures and formats to avoid data conflicts.
Answer
  • Data mart
  • Database
  • Data warehouse
  • Data analysis

Question 25

Question
Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.
Answer
  • semidimensional
  • multidimensional
  • one-dimensional
  • two-dimensional

Question 26

Question
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Answer
  • online
  • database
  • processing
  • data

Question 27

Question
MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multi-dimensional data.
Answer
  • multidimensional
  • one-dimensional
  • two-dimensional
  • relational

Question 28

Question
The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Answer
  • relational
  • dimensional
  • multidimensional
  • attribute

Question 29

Question
During the data ____ phase of data mining, common characteristics or patterns are identified.
Answer
  • analysis
  • preparation
  • extraction
  • acquisition

Question 30

Question
During the ____ phase of data mining, the data-mining findings are used to predict future behav-ior and forecast business outcomes.
Answer
  • analysis and classification
  • preparation
  • prognosis
  • knowledge acquisition

Question 31

Question
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Answer
  • star
  • square
  • OLAP
  • ROLAP

Question 32

Question
____ backups take place while the user is working on the database.
Answer
  • Full
  • Incremental
  • Concurrent
  • Sequential

Question 33

Question
A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
Answer
  • user
  • role
  • profile
  • manager

Question 34

Question
At the level of top management, the database must be able to ____.
Answer
  • 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

Question 35

Question
As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
Answer
  • control and planning
  • conflict and problem resolution
  • policies and standards
  • security and privacy

Question 36

Question
User-access management is a subset of ____.
Answer
  • password protection
  • authorization management
  • data integrity
  • managerial control

Question 37

Question
Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.
Answer
  • user groups
  • sections
  • authorization schemes
  • policy definitions
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

KING LEAR
Felicity Baines
Cold War Timeline
jacksearle
Orwell and 1984
Polina Strich
Unit 1: Media production & regulation
c.gale
Chemistry unit 2
36jessieh
AS Sociology - Education Theories
HannahLB
GCSE History – The early years and the Weimar Republic 1918-1923
Ben C
Verbo To be (negativo)
Renee Carolina
Moléculas biológicas-mapa conceptual
Montse Valle
The Changing Natural Environment Part 2
R S
Conclusion Paragraph
Amber Carter
Browse Library