17584478
Descripción
Test por Matthew Rook, actualizado hace más de 1 año
|
Creado por Matthew Rook
hace más de 5 años
|
|
Pregunta 1
Pregunta
What is Program-Data Redundancy?
Respuesta
-
changing the structure or storage characteristics would require changing the applications that access it
-
Unnecessary storage of the same data in different places
-
different and conflicting versions of the same data occur at different places
-
Abnormalities when all changes in redundant data are not made correctly
Pregunta 2
Pregunta
What is Data Redundancy?
Respuesta
-
changing the structure or storage characteristics would require changing the applications that access it
-
different and conflicting versions of the same data occur at different places
-
Abnormalities when all changes in redundant data are not made correctly
-
Unnecessary storage of the same data in different places
Pregunta 3
Pregunta
What is Data Inconsistancy?
Respuesta
-
Abnormalities when all changes in redundant data are not made correctly
-
Unnecessary storage of the same data in different places
-
changing the structure or storage characteristics would require changing the applications that access it
-
different and conflicting versions of the same data occur at different places
Pregunta 4
Pregunta
What is Data Anomalies?
Respuesta
-
changing the structure or storage characteristics would require changing the applications that access it
-
different and conflicting versions of the same data occur at different places
-
Unnecessary storage of the same data in different places
-
Abnormalities when all changes in redundant data are not made correctly
Pregunta 5
Pregunta
Data 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]
Respuesta
-
definitions
-
data
-
elements
-
relationships
Pregunta 6
Pregunta
[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]
Respuesta
-
Data storage management
-
efficient
-
performance
-
database
-
storage
-
speed
Pregunta 7
Pregunta
[blank_start]Data transformation and presentation[blank_end] - Transforms entered data to conform to required data structures
Respuesta
-
Data transformation and presentation
Pregunta 8
Pregunta
[blank_start]Security management[blank_end] - Enforces user security and data privacy
Respuesta
-
Security management
Pregunta 9
Pregunta
[blank_start]Multiuser access control[blank_end] - Sophisticated algorithms ensure that multiple users
can access the database concurrently without
compromising its integrity
Respuesta
-
Multiuser access control
Pregunta 10
Pregunta
[blank_start]Backup and recovery management[blank_end] - Enables recovery of the database after a failure
Respuesta
-
Backup and recovery management
Pregunta 11
Pregunta
[blank_start]Data integrity management[blank_end] - Minimizes redundancy and maximizes consistency
Respuesta
-
Data integrity management
Pregunta 12
Pregunta
[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
Respuesta
-
Database
-
access
-
languages
-
and
-
application
-
programming
Pregunta 13
Pregunta
[blank_start]Database communication interfaces[blank_end] - Accept end-user requests via multiple, different
network environments
Respuesta
-
Database communication interfaces
Pregunta 14
Pregunta
Abstraction of a real-world object or event is an example of Data Models?
Respuesta
- True
- False
Pregunta 15
Pregunta
Collection 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
Respuesta
- True
- False
Pregunta 16
Pregunta
A Model refers to the process of creating a specific data model for a
determined problem domain.
Respuesta
- True
- False
Pregunta 17
Pregunta
An [blank_start]entity[blank_end] is a person, place, thing, or event
about which data will be collected and stored.
Respuesta
-
entity
Pregunta 18
Pregunta
An [blank_start]attribute[blank_end] is a characteristic of an entity
Respuesta
-
attribute
Pregunta 19
Pregunta
A [blank_start]relationship[blank_end] describes an association among
entities.
Respuesta
-
relationship
Pregunta 20
Pregunta
A [blank_start]constraint[blank_end] is a restriction placed on the data
Respuesta
-
constraint
Pregunta 21
Pregunta
• Logical Data Independence:
Respuesta
-
Change the schema at one level of a database system without having to change the schema at the next higher level.
-
A change in storage devices or methods and even a change in operating system will not affect the internal model.
-
Change the internal model without affecting the conceptual model.
-
Change the physical model without affecting the internal model
-
Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications
Pregunta 22
Pregunta
Data Independence:
Respuesta
-
Change the schema at one level of a database system without having to change the schema at the next higher level.
-
A change in storage devices or methods and even a change in operating system will not affect the internal model.
-
Change the internal model without affecting the conceptual model.
-
Change the physical model without affecting the internal model
-
Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications
Pregunta 23
Pregunta
Physical Data Independence:
Respuesta
-
Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications
-
Change the physical model without affecting the internal model
-
Change the internal model without affecting the conceptual model.
-
A change in storage devices or methods and even a change in operating system will not affect the internal model.
-
Change the schema at one level of a database system without having to change the schema at the next higher level.
Pregunta 24
Pregunta
[blank_start]Primary Key[blank_end] - An attribute that can identify each row in a table uniquely. Cannot be null or duplicate
Respuesta
-
Primary Key
Pregunta 25
Pregunta
[blank_start]Composite Primary Key[blank_end] - Composed of more than one attribute
Respuesta
-
Composite Primary Key
Pregunta 26
Pregunta
[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!
Respuesta
-
Secondary Key
Pregunta 27
Pregunta
[blank_start]Entity integrity[blank_end] - Each row (entity instance) in the table has its own unique identity
Respuesta
-
Entity integrity
Pregunta 28
Pregunta
[blank_start]Foreign key[blank_end] - An attribute whose values match primary key values in the related table
Respuesta
-
Foreign key
Pregunta 29
Pregunta
[blank_start]Referential integrity[blank_end] - FK contains a value that refers to an existing valid tuple (row) in another
relation
Respuesta
-
Referential integrity
Pregunta 30
Pregunta
[blank_start]UNION[blank_end] will show all rows in the tables except duplicates
Respuesta
-
UNION
Pregunta 31
Pregunta
[blank_start]UNION ALL[blank_end] will show all rows from the tables including duplicates
Respuesta
-
UNION ALL
Pregunta 32
Pregunta
[blank_start]PROJECT[blank_end] - Unary operator that yields a vertical subset of a table. Yield all values for selected attributes
Respuesta
-
PROJECT
Pregunta 33
Pregunta
[blank_start]INTERSECT[blank_end] - Yields only the rows that appear in both tables
Respuesta
-
INTERSECT
Pregunta 34
Pregunta
[blank_start]DIFFERENCE[blank_end] - Yields all rows in one table that are not found in the other table
Respuesta
-
DIFFERENCE
Pregunta 35
Pregunta
[blank_start]Identifiers[blank_end]: one or more attributes that uniquely identify
each entity instance.
Respuesta
-
Identifiers
Pregunta 36
Pregunta
[blank_start]Composite attribute[blank_end]: Attribute that can be subdivided to
yield additional attributes
Respuesta
-
Composite attribute
Pregunta 37
Pregunta
[blank_start]Simple attribute[blank_end]: Attribute that cannot be subdivided
Respuesta
-
Simple attribute
Pregunta 38
Pregunta
[blank_start]Single valued attribute[blank_end]: Attribute that has only a single value.
Respuesta
-
Single valued attribute
Pregunta 39
Pregunta
[blank_start]Multivalued attribute[blank_end]s: Attributes that have many values.
Respuesta
-
Multivalued attribute
Pregunta 40
Pregunta
[blank_start]Derived attribute[blank_end]: Attribute whose value is calculated from other
attributes
Respuesta
-
Derived attribute
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.