Quiz
Database Design
This quiz has question types that open in the usual player.
Questions in this quiz (40)
1What is Program-Data Redundancy?
- Achanging the structure or storage characteristics would require changing the applications that access it
- BUnnecessary storage of the same data in different places
- Cdifferent and conflicting versions of the same data occur at different places
- DAbnormalities when all changes in redundant data are not made correctly
2What is Data Redundancy?
- Achanging the structure or storage characteristics would require changing the applications that access it
- Bdifferent and conflicting versions of the same data occur at different places
- CAbnormalities when all changes in redundant data are not made correctly
- DUnnecessary storage of the same data in different places
3What is Data Inconsistancy?
- AAbnormalities when all changes in redundant data are not made correctly
- BUnnecessary storage of the same data in different places
- Cchanging the structure or storage characteristics would require changing the applications that access it
- Ddifferent and conflicting versions of the same data occur at different places
4What is Data Anomalies?
- Achanging the structure or storage characteristics would require changing the applications that access it
- Bdifferent and conflicting versions of the same data occur at different places
- CUnnecessary storage of the same data in different places
- DAbnormalities when all changes in redundant data are not made correctly
5Data Dictionary Management - Data dictionary: Stores [blank_start]definitions[blank_end] of the [blank_start]data[blank_end] [blank_start]elements[blank_end]
and their [blank_start]relationships[blank_end]- Adefinitions
- Bdata
- Celements
- Drelationships
6[blank_start]Data storage management[blank_end] - Performance tuning: Ensures [blank_start]efficient[blank_end] [blank_start]performance[blank_end] of the
[blank_start]database[blank_end] in terms of [blank_start]storage[blank_end] and access [blank_start]speed[blank_end]- AData storage management
- Befficient
- Cperformance
- Ddatabase
- Estorage
- Fspeed
7[blank_start]Data transformation and presentation[blank_end] - Transforms entered data to conform to required data structures
- AData transformation and presentation
8[blank_start]Security management[blank_end] - Enforces user security and data privacy
- ASecurity management
9[blank_start]Multiuser access control[blank_end] - Sophisticated algorithms ensure that multiple users
can access the database concurrently without
compromising its integrity- AMultiuser access control
10[blank_start]Backup and recovery management[blank_end] - Enables recovery of the database after a failure
- ABackup and recovery management
11[blank_start]Data integrity management[blank_end] - Minimizes redundancy and maximizes consistency
- AData integrity management
12[blank_start]Database[blank_end] [blank_start]access[blank_end] [blank_start]languages[blank_end] [blank_start]and[blank_end] [blank_start]application[blank_end]
[blank_start]programming[blank_end] interfaces - Query language: Lets the user specify what
must be done without having to specify how
• Structured Query Language (SQL): De facto
query language and data access standard
supported by the majority of DBMS vendors- ADatabase
- Baccess
- Clanguages
- Dand
- Eapplication
- Fprogramming
13[blank_start]Database communication interfaces[blank_end] - Accept end-user requests via multiple, different
network environments- ADatabase communication interfaces
14Abstraction of a real-world object or event is an example of Data Models?
- ATrue
- BFalse
15Collection of related concepts used to describe the structure
of a database, i.e. unique objects, data types, relationships,
and constraints
• Useful for supporting a specific problem domain
• Simple representations of complex real-world data structures
This is an example of Data Modelling- ATrue
- BFalse
16A Model refers to the process of creating a specific data model for a
determined problem domain.- ATrue
- BFalse
17An [blank_start]entity[blank_end] is a person, place, thing, or event
about which data will be collected and stored.- Aentity
18An [blank_start]attribute[blank_end] is a characteristic of an entity
- Aattribute
19A [blank_start]relationship[blank_end] describes an association among
entities.- Arelationship
20A [blank_start]constraint[blank_end] is a restriction placed on the data
- Aconstraint
21• Logical Data Independence:
- AChange the schema at one level of a database system without
having to change the schema at the next higher level. - BA change in storage devices or methods and even a change in
operating system will not affect the internal model. - CChange the internal model without affecting the conceptual
model. - DChange the physical model without affecting the internal model
- ERecoding, adding fields (e.g. adding an email address to a
student file) in the database should not affect applications
- AChange the schema at one level of a database system without
22Data Independence:
- AChange the schema at one level of a database system without
having to change the schema at the next higher level. - BA change in storage devices or methods and even a change in
operating system will not affect the internal model. - CChange the internal model without affecting the conceptual
model. - DChange the physical model without affecting the internal model
- ERecoding, adding fields (e.g. adding an email address to a
student file) in the database should not affect applications
- AChange the schema at one level of a database system without
23Physical Data Independence:
- ARecoding, adding fields (e.g. adding an email address to a
student file) in the database should not affect applications - BChange the physical model without affecting the internal model
- CChange the internal model without affecting the conceptual
model. - DA change in storage devices or methods and even a change in
operating system will not affect the internal model. - EChange the schema at one level of a database system without
having to change the schema at the next higher level.
- ARecoding, adding fields (e.g. adding an email address to a
24[blank_start]Primary Key[blank_end] - An attribute that can identify each row in a table uniquely. Cannot be null or duplicate
- APrimary Key
25[blank_start]Composite Primary Key[blank_end] - Composed of more than one attribute
- AComposite Primary Key
26[blank_start]Secondary Key[blank_end] - Unique key other than primary key, Strictly for data retrieval purposes, E.g. Customers do not remember their ID, but
they do remember their phone number!- ASecondary Key
27[blank_start]Entity integrity[blank_end] - Each row (entity instance) in the table has its own unique identity
- AEntity integrity
28[blank_start]Foreign key[blank_end] - An attribute whose values match primary key values in the related table
- AForeign key
29[blank_start]Referential integrity[blank_end] - FK contains a value that refers to an existing valid tuple (row) in another
relation- AReferential integrity
30[blank_start]UNION[blank_end] will show all rows in the tables except duplicates
- AUNION
31[blank_start]UNION ALL[blank_end] will show all rows from the tables including duplicates
- AUNION ALL
32[blank_start]PROJECT[blank_end] - Unary operator that yields a vertical subset of a table. Yield all values for selected attributes
- APROJECT
33[blank_start]INTERSECT[blank_end] - Yields only the rows that appear in both tables
- AINTERSECT
34[blank_start]DIFFERENCE[blank_end] - Yields all rows in one table that are not found in the other table
- ADIFFERENCE
35[blank_start]Identifiers[blank_end]: one or more attributes that uniquely identify
each entity instance.- AIdentifiers
36[blank_start]Composite attribute[blank_end]: Attribute that can be subdivided to
yield additional attributes- AComposite attribute
37[blank_start]Simple attribute[blank_end]: Attribute that cannot be subdivided
- ASimple attribute
38[blank_start]Single valued attribute[blank_end]: Attribute that has only a single value.
- ASingle valued attribute
39[blank_start]Multivalued attribute[blank_end]s: Attributes that have many values.
- AMultivalued attribute
40[blank_start]Derived attribute[blank_end]: Attribute whose value is calculated from other
attributes- ADerived attribute
Information
- Description
- Database Quiz on Database Design, created by Matthew Rook on 04/04/2019.
- Author
- Matthew Rook
- Language
- English
- Views
- 13
- Tags
- Rating
- No ratings yet Rate this quiz