Copy and Edit

C192 - Alt Pre-assessment

Description

datastorage DML data architectures db admin
jacob thomas
Quiz by jacob thomas, updated more than 1 year ago
jacob thomas
Created by jacob thomas over 6 years ago
32
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 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

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 supertype.
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 several 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 multidimensional 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 behavior and forecast business outcomes.
Answer
  • analysis and classifications
  • 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 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

Reducing the Impact of Earthquakes
siobhan.quirk
Key Definitions for organic chemistry
katburr23
CHEMISTRY C1 5
x_clairey_x
Attachment - Psychology - Flash Cards
Megan Price
Physics P3 Fashcards
Holly Bamford
Digestive System Pre/Post Quiz
mkelemete
med chem 2 final exam
lola_smily
AQA GCSE Physics Unit 2 Mindmap
Gabi Germain
Les Aliments
dAnn dAnn
Macbeth Quotes To Learn
Sophie Brokenshire
AAHI_Card set 2 (Escalation criteria)
Tafe Teachers SB
Browse Library