Stack #4039651
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | Structured data
🗑
|
||||
| show | Unstructured
🗑
|
||||
| show | Unstructured
🗑
|
||||
| show | _____ exists when different versions of the same data appear in different places.
🗑
|
||||
| show | Data inconsistency
🗑
|
||||
| show | _____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
🗑
|
||||
| show | Data integrity
🗑
|
||||
| Data integrity | show 🗑
|
||||
| show | Knowledge
🗑
|
||||
| Knowledge | show 🗑
|
||||
| _____ is the result of revealing the meaning of raw facts. | show 🗑
|
||||
| show | _____ provide a description of the data characteristics and the set of relationships that link the data found within the database.
🗑
|
||||
| _____ provide a description of the data characteristics and the set of relationships that link the data found within the database. | show 🗑
|
||||
| show | _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
🗑
|
||||
| show | Performance tuning
🗑
|
||||
| Performance tuning | show 🗑
|
||||
| _____ serve as the intermediary between the user and the database. | show 🗑
|
||||
| show | A _____ is a character or group of characters that has a specific meaning.
🗑
|
||||
| A _____ is a character or group of characters that has a specific meaning. | show 🗑
|
||||
| Field | show 🗑
|
||||
| show | File
🗑
|
||||
| File | show 🗑
|
||||
| A _____ is a logically connected set of one or more fields that describes a person, place, or thing. | show 🗑
|
||||
| Record | show 🗑
|
||||
| show | Operational databases
🗑
|
||||
| Operational databases | show 🗑
|
||||
| show | Single-user
🗑
|
||||
| show | A workgroup database is a(n) _____ database.
🗑
|
||||
| show | Multiuser
🗑
|
||||
| show | A(n) _____ database is used by an organization and supports many users across many departments.
🗑
|
||||
| A(n) _____ database is used by an organization and supports many users across many departments. | show 🗑
|
||||
| show | A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
🗑
|
||||
| show | Workgroup
🗑
|
||||
| Workgroup | show 🗑
|
||||
| show | Application
🗑
|
||||
| Application | show 🗑
|
||||
| show | Good decision making
🗑
|
||||
| show | An XML database supports the storage and management of _____ XML data.
🗑
|
||||
| show | Semistructured
🗑
|
||||
| Semistructured | show 🗑
|
||||
| Data is said to be verifiable if _____. | show 🗑
|
||||
| The data is obtained from trusted sources | show 🗑
|
||||
| show | raw facts of interest to the end user
🗑
|
||||
| show | Most data that can be encountered are best classified as _____.
🗑
|
||||
| Most data that can be encountered are best classified as _____. | show 🗑
|
||||
| show | The database structure in a DBMS is stored as a _____.
🗑
|
||||
| The database structure in a DBMS is stored as a _____. | show 🗑
|
||||
| Collection of files | show 🗑
|
||||
| show | Its expected use
🗑
|
||||
| Its expected use | show 🗑
|
||||
| show | Query result set
🗑
|
||||
| show | The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
🗑
|
||||
| show | Database system
🗑
|
||||
| show | Which of the following is true of spreadsheet applications?
🗑
|
||||
| Which of the following is true of spreadsheet applications? | show 🗑
|
||||
| show | Which of the following refers to the situation where different versions of the same data are stored at different places because they weren’t updated consistently?
🗑
|
||||
| Which of the following refers to the situation where different versions of the same data are stored at different places because they weren’t updated consistently? | show 🗑
|
||||
| Data redundancy | show 🗑
|
||||
| _____ are important because they help to ensure data integrity. | show 🗑
|
||||
| show | _____ are normally expressed in the form of rules.
🗑
|
||||
| _____ are normally expressed in the form of rules. | show 🗑
|
||||
| Constraints | show 🗑
|
||||
| show | Entity
🗑
|
||||
| show | A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
🗑
|
||||
| A verb associating two nouns in a business rule translates to a(n) _____ in the data model. | show 🗑
|
||||
| Relationship | show 🗑
|
||||
| A(n) _____ enables a database administrator to describe schema components. | show 🗑
|
||||
| show | A(n) _____ is a restriction placed on the data.
🗑
|
||||
| A(n) _____ is a restriction placed on the data. | show 🗑
|
||||
| show | A(n) _____ is anything about which data are to be collected and stored.
🗑
|
||||
| A(n) _____ is anything about which data are to be collected and stored. | show 🗑
|
||||
| show | A(n) _____ is bidirectional.
🗑
|
||||
| A(n) _____ is bidirectional. | show 🗑
|
||||
| show | A(n) _____ is the equivalent of a field in a file system.
🗑
|
||||
| show | Attribute
🗑
|
||||
| show | A(n) _____ represents a particular type of object in the real world.
🗑
|
||||
| show | Entity
🗑
|
||||
| show | A(n) _____ enables a database administrator to describe schema components.
🗑
|
||||
| show | Data definition language (DDL)
🗑
|
||||
| show | A(n) _____'s main function is to help one understand the complexities of the real-world environment.
🗑
|
||||
| A(n) _____'s main function is to help one understand the complexities of the real-world environment. | show 🗑
|
||||
| show | In the _____ model, each parent can have many children, but each child has only one parent.
🗑
|
||||
| In the _____ model, each parent can have many children, but each child has only one parent. | show 🗑
|
||||
| Hierarchical | show 🗑
|
||||
| show | Hierarchical
🗑
|
||||
| Hierarchical | show 🗑
|
||||
| In the _____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. | show 🗑
|
||||
| show | MySQL is an example of the _____.
🗑
|
||||
| show | Relational data model
🗑
|
||||
| Relational data model | show 🗑
|
||||
| Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models. | show 🗑
|
||||
| show | Students and classes have a _____ relationship.
🗑
|
||||
| Students and classes have a _____ relationship. | show 🗑
|
||||
| Many-to-many | show 🗑
|
||||
| show | Object-oriented
🗑
|
||||
| Object-oriented | show 🗑
|
||||
| show | Object-oriented
🗑
|
||||
| show | The _____ model uses the term connectivity to label the relationship types.
🗑
|
||||
| The _____ model uses the term connectivity to label the relationship types. | show 🗑
|
||||
| show | The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
🗑
|
||||
| show | Entity relationship
🗑
|
||||
| Entity relationship | show 🗑
|
||||
| The hierarchical data model was developed in the _____. | show 🗑
|
||||
| 1960s | show 🗑
|
||||
| The object-oriented data model was developed in the _____. | show 🗑
|
||||
| 1980s | show 🗑
|
||||
| The relational data model was developed in the _____. | show 🗑
|
||||
| show | VMS/VSAM is an example of the _____.
🗑
|
||||
| show | File system data model
🗑
|
||||
| show | Which of the following is true of business rules?
🗑
|
||||
| Which of the following is true of business rules? | show 🗑
|
||||
| show | Which of the following is true of NoSQL databases?
🗑
|
||||
| Which of the following is true of NoSQL databases? | show 🗑
|
||||
| They are not based on the relational model. | show 🗑
|
||||
| show | Client node
🗑
|
||||
| show | Which of the following types of HDFS nodes stores all the metadata about a file system?
🗑
|
||||
| Which of the following types of HDFS nodes stores all the metadata about a file system? | show 🗑
|
||||
| Name node | show 🗑
|
||||
| _____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems. | show 🗑
|
||||
| Outer joins | show 🗑
|
||||
| show | Predicate
🗑
|
||||
| show | _____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.
🗑
|
||||
| show | M:N
🗑
|
||||
| M:N | show 🗑
|
||||
| show | PROJECT
🗑
|
||||
| show | _____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
🗑
|
||||
| _____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. | show 🗑
|
||||
| show | A _____ contains at least all of the attribute names and characteristics for each table in the system.
🗑
|
||||
| A _____ contains at least all of the attribute names and characteristics for each table in the system. | show 🗑
|
||||
| Data dictionary | show 🗑
|
||||
| show | Superkey
🗑
|
||||
| Superkey | show 🗑
|
||||
| show | Foreign key
🗑
|
||||
| show | A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.
🗑
|
||||
| A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes. | show 🗑
|
||||
| Candidate | show 🗑
|
||||
| show | Secondary
🗑
|
||||
| Secondary | show 🗑
|
||||
| show | Index
🗑
|
||||
| show | A(n) _____ join links tables by selecting only the rows with common values in their common attribute(s).
🗑
|
||||
| A(n) _____ join links tables by selecting only the rows with common values in their common attribute(s). | show 🗑
|
||||
| Natural | show 🗑
|
||||
| A(n) _____ only returns matched records from the tables that are being joined. | show 🗑
|
||||
| show | Logical data independence
🗑
|
||||
| Logical data independence | show 🗑
|
||||
| show | Nonsubversion
🗑
|
||||
| Nonsubversion | show 🗑
|
||||
| show | Bridge
🗑
|
||||
| show | Date attributes contain calendar dates stored in a special format known as the _____ date format.
🗑
|
||||
| Date attributes contain calendar dates stored in a special format known as the _____ date format. | show 🗑
|
||||
| show | Each table _____ represents an attribute.
🗑
|
||||
| show | Column
🗑
|
||||
| show | In a database context, a(n) _____ indicates the use of different names to describe the same attribute.
🗑
|
||||
| In a database context, a(n) _____ indicates the use of different names to describe the same attribute. | show 🗑
|
||||
| show | In a database context, the word _____ indicates the use of the same attribute name to label different attributes.
🗑
|
||||
| show | Homonym
🗑
|
||||
| Homonym | show 🗑
|
||||
| show | Keys
🗑
|
||||
| Keys | show 🗑
|
||||
| show | Integrity
🗑
|
||||
| Integrity | show 🗑
|
||||
| show | NOT NULL
🗑
|
||||
| NOT NULL | show 🗑
|
||||
| The _____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents. | show 🗑
|
||||
| show | The _____ relationship is the “relational model ideal.”
🗑
|
||||
| The _____ relationship is the “relational model ideal.” | show 🗑
|
||||
| show | The _____ relationship should be rare in any relational database design.
🗑
|
||||
| The _____ relationship should be rare in any relational database design. | show 🗑
|
||||
| 0.0423611111111111 | show 🗑
|
||||
| show | Entity
🗑
|
||||
| show | To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, and JOIN.
🗑
|
||||
| To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, and JOIN. | show 🗑
|
||||
| SELECT | show 🗑
|
||||
| When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be _____. | show 🗑
|
||||
| show | When you define a table’s primary key, the DBMS automatically creates a(n) _____ index on the primary key column(s) you declared.
🗑
|
||||
| When you define a table’s primary key, the DBMS automatically creates a(n) _____ index on the primary key column(s) you declared. | show 🗑
|
||||
| Unique | show 🗑
|
||||
| _____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. | show 🗑
|
||||
| show | A _____ attribute can be further subdivided to yield additional attributes.
🗑
|
||||
| A _____ attribute can be further subdivided to yield additional attributes. | show 🗑
|
||||
| show | A _____ attribute is one that cannot be subdivided.
🗑
|
||||
| show | Simple
🗑
|
||||
| show | A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
🗑
|
||||
| show | Weak
🗑
|
||||
| Weak | show 🗑
|
||||
| show | Unary
🗑
|
||||
| Unary | show 🗑
|
||||
| show | Ternary
🗑
|
||||
| show | A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.
🗑
|
||||
| show | Dashed line
🗑
|
||||
| show | A relationship is an association between _____.
🗑
|
||||
| show | Entities
🗑
|
||||
| Entities | show 🗑
|
||||
| show | Domain
🗑
|
||||
| show | An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
🗑
|
||||
| show | Existence
🗑
|
||||
| show | Complex _____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.
🗑
|
||||
| Complex _____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. | show 🗑
|
||||
| Information | show 🗑
|
||||
| Database design is a(n) _____ process based on repetition. | show 🗑
|
||||
| show | Ideally, an entity identifier is composed of _____ attribute(s).
🗑
|
||||
| show | One
🗑
|
||||
| show | If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship.
🗑
|
||||
| show | Recursive
🗑
|
||||
| show | If an entity can exist apart from all of its related entities, then it is existence-independent, and it
🗑
|
||||
| If an entity can exist apart from all of its related entities, then it is existence-independent, and it | show 🗑
|
||||
| is referred to as a(n) _____ entity. | show 🗑
|
||||
| show | If Tiny College has some departments that are classified as “research only” and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.
🗑
|
||||
| If Tiny College has some departments that are classified as “research only” and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity. | show 🗑
|
||||
| Optional to | show 🗑
|
||||
| In organizations that generate a large number of transactions, _____ are often a top priority in database design. | show 🗑
|
||||
| show | In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.
🗑
|
||||
| In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities. | show 🗑
|
||||
| show | Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level.
🗑
|
||||
| show | Entity
🗑
|
||||
| show | The _____ notation of entity-relationship modeling can be used for both conceptual and
🗑
|
||||
| show | implementation modeling.
🗑
|
||||
| implementation modeling. | show 🗑
|
||||
| show | The conceptual model can handle _____ relationships and multivalued attributes.
🗑
|
||||
| show | M:N
🗑
|
||||
| show | The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality.
🗑
|
||||
| The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality. | show 🗑
|
||||
| show | The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.
🗑
|
||||
| The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application. | show 🗑
|
||||
| Derived | show 🗑
|
||||
| show | Conceptual
🗑
|
||||
| show | The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities.
🗑
|
||||
| show | M:N
🗑
|
||||
| show | The existence of a(n) _____ entity indicates that its minimum cardinality is zero.
🗑
|
||||
| The existence of a(n) _____ entity indicates that its minimum cardinality is zero. | show 🗑
|
||||
| show | The first step in building an entity-relationship diagram (ERD) is _____.
🗑
|
||||
| The first step in building an entity-relationship diagram (ERD) is _____. | show 🗑
|
||||
| Creating a detailed narrative of the organization’s description of operations | show 🗑
|
||||
| show | Binary
🗑
|
||||
| show | When the specific cardinalities are not included on the diagram in Crow’s Foot notation, cardinality is implied by the use of _____.
🗑
|
||||
| show | Symbols
🗑
|
||||
| Symbols | show 🗑
|
||||
| show | Solid
🗑
|
||||
| Solid | show 🗑
|
||||
| show | Generalization
🗑
|
||||
| Generalization | show 🗑
|
||||
| show | Surrogate key
🗑
|
||||
| Surrogate key | show 🗑
|
||||
| show | Natural
🗑
|
||||
| Natural | show 🗑
|
||||
| show | a single horizontal line under a circle
🗑
|
||||
| show | A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.
🗑
|
||||
| show | Many
🗑
|
||||
| Many | show 🗑
|
||||
| A total completeness constraint is represented by a _____. | show 🗑
|
||||
| show | A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
🗑
|
||||
| A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related. | show 🗑
|
||||
| show | A(n)_____ is a generic entity type that is related to one or more entity subtypes.
🗑
|
||||
| A(n)_____ is a generic entity type that is related to one or more entity subtypes. | show 🗑
|
||||
| show | According to the “preferably single-attribute” characteristic of a primary key, the primary key:
🗑
|
||||
| show | Should have the minimum number of attributes possible.
🗑
|
||||
| Should have the minimum number of attributes possible. | show 🗑
|
||||
| An entity cluster is formed by combining multiple interrelated entities into _____. | show 🗑
|
||||
| show | At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n) _____ relationship.
🗑
|
||||
| show | 0.0423611111111111
🗑
|
||||
| show | Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the _____ relationship.
🗑
|
||||
| show | M:N
🗑
|
||||
| show | If one exists, a data modeler uses a _____ as the primary key of the entity being modeled.
🗑
|
||||
| If one exists, a data modeler uses a _____ as the primary key of the entity being modeled. | show 🗑
|
||||
| show | In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype.
🗑
|
||||
| show | disjoint constraint
🗑
|
||||
| show | In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.
🗑
|
||||
| In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype. | show 🗑
|
||||
| overlapping constraint | show 🗑
|
||||
| show | unique
🗑
|
||||
| show | One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.
🗑
|
||||
| show | primary
🗑
|
||||
| primary | show 🗑
|
||||
| show | nonunique
🗑
|
||||
| nonunique | show 🗑
|
||||
| The _____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities). | show 🗑
|
||||
| specialization hierarchy | show 🗑
|
||||
| show | nonintelligent
🗑
|
||||
| show | The “_____” characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.
🗑
|
||||
| show | unique values
🗑
|
||||
| unique values | show 🗑
|
||||
| show | security-compliant
🗑
|
||||
| security-compliant | show 🗑
|
||||
| The default comparison condition for the subtype discriminator attribute is the _____ comparison. | show 🗑
|
||||
| show | The extended entity relationship model (EERM) is sometimes referred to as the _____.
🗑
|
||||
| The extended entity relationship model (EERM) is sometimes referred to as the _____. | show 🗑
|
||||
| enhanced entity relationship model | show 🗑
|
||||
| show | primary
🗑
|
||||
| primary | show 🗑
|
||||
| show | inheritance
🗑
|
||||
| inheritance | show 🗑
|
||||
| show | cluster
🗑
|
||||
| show | _____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
🗑
|
||||
| _____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely. | show 🗑
|
||||
| Data warehouse | show 🗑
|
||||
| A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence. | show 🗑
|
||||
| Repeating group | show 🗑
|
||||
| show | Repeating group
🗑
|
||||
| Repeating group | show 🗑
|
||||
| A table is in 4NF if it is in 3NF, and _____. | show 🗑
|
||||
| show | A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.
🗑
|
||||
| A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____. | show 🗑
|
||||
| 1NF | show 🗑
|
||||
| show | 3NF
🗑
|
||||
| show | A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.
🗑
|
||||
| A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____. | show 🗑
|
||||
| 4NF | show 🗑
|
||||
| A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key. | show 🗑
|
||||
| show | An atomic attribute _____.
🗑
|
||||
| An atomic attribute _____. | show 🗑
|
||||
| show | An attribute that is part of a key is known as a(n) _____ attribute.
🗑
|
||||
| show | Prime
🗑
|
||||
| Prime | show 🗑
|
||||
| An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows. | show 🗑
|
||||
| show | Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
🗑
|
||||
| Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. | show 🗑
|
||||
| show | BCNF can be violated only if the table contains more than one _____ key.
🗑
|
||||
| show | Candidate
🗑
|
||||
| show | Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.
🗑
|
||||
| show | 2NF
🗑
|
||||
| show | Dependencies based on only a part of a composite primary key are known as _____ dependencies.
🗑
|
||||
| Dependencies based on only a part of a composite primary key are known as _____ dependencies. | show 🗑
|
||||
| Partial | show 🗑
|
||||
| show | 1NF
🗑
|
||||
| 1NF | show 🗑
|
||||
| show | 2NF
🗑
|
||||
| show | From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.
🗑
|
||||
| show | Derived
🗑
|
||||
| Derived | show 🗑
|
||||
| show | The level of detail represented by the values in a table’s row
🗑
|
||||
| The level of detail represented by the values in a table’s row | show 🗑
|
||||
| If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute. | show 🗑
|
||||
| show | Improving _____ leads to more flexible queries.
🗑
|
||||
| Improving _____ leads to more flexible queries. | show 🗑
|
||||
| show | In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.
🗑
|
||||
| In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other. | show 🗑
|
||||
| show | In a real-world environment, we must strike a balance between design integrity and _____.
🗑
|
||||
| show | Flexibility
🗑
|
||||
| Flexibility | show 🗑
|
||||
| show | Dependency
🗑
|
||||
| show | Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.
🗑
|
||||
| Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process. | show 🗑
|
||||
| Three | show 🗑
|
||||
| show | DKNF
🗑
|
||||
| DKNF | show 🗑
|
||||
| Some very specialized applications may require normalization beyond the _____. | show 🗑
|
||||
| show | The most likely data type for a surrogate key is _____.
🗑
|
||||
| The most likely data type for a surrogate key is _____. | show 🗑
|
||||
| Numeric | show 🗑
|
||||
| show | AutoNumber
🗑
|
||||
| AutoNumber | show 🗑
|
||||
| When a table contains only one candidate key, _____ are considered to be equivalent. | show 🗑
|
||||
| show | _____ is a relational set operator.
🗑
|
||||
| _____ is a relational set operator. | show 🗑
|
||||
| show | _____ is a string function that returns the number of characters in a string value.
🗑
|
||||
| _____ is a string function that returns the number of characters in a string value. | show 🗑
|
||||
| LENGTH | show 🗑
|
||||
| A(n) _____ is a query that is embedded (or nested) inside another query. | show 🗑
|
||||
| subquery | show 🗑
|
||||
| A(n) _____ is an alternate name given to a column or table in any SQL statement. | show 🗑
|
||||
| show | A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.
🗑
|
||||
| A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables. | show 🗑
|
||||
| show | A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.
🗑
|
||||
| show | outer
🗑
|
||||
| outer | show 🗑
|
||||
| show | natural
🗑
|
||||
| show | A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
🗑
|
||||
| A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed. | show 🗑
|
||||
| show | According to the rules of precedence, which of the following computations should be completed first?
🗑
|
||||
| show | Operations within parentheses
🗑
|
||||
| Operations within parentheses | show 🗑
|
||||
| How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? | show 🗑
|
||||
| 144 | show 🗑
|
||||
| If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause. | show 🗑
|
||||
| JOIN ON | show 🗑
|
||||
| In Oracle, the _____ function converts a date to a character string. | show 🗑
|
||||
| TO_CHAR() | show 🗑
|
||||
| In subquery terminology, the first query in the SQL statement is known as the _____ query. | show 🗑
|
||||
| outer | show 🗑
|
||||
| show | DEFAULT
🗑
|
||||
| show | The _____ function returns the current system date in MS Access.
🗑
|
||||
| show | DATE()
🗑
|
||||
| DATE() | show 🗑
|
||||
| show | HAVING
🗑
|
||||
| show | The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.
🗑
|
||||
| The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found. | show 🗑
|
||||
| show | The special operator used to check whether a subquery returns any rows is _____.
🗑
|
||||
| show | EXISTS
🗑
|
||||
| EXISTS | show 🗑
|
||||
| show | BETWEEN
🗑
|
||||
| BETWEEN | show 🗑
|
||||
| show | LIKE
🗑
|
||||
| show | The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.
🗑
|
||||
| The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____. | show 🗑
|
||||
| show | The SQL command that allows a user to permanently save data changes is _____.
🗑
|
||||
| The SQL command that allows a user to permanently save data changes is _____. | show 🗑
|
||||
| COMMIT | show 🗑
|
||||
| The SQL data manipulation command HAVING: | show 🗑
|
||||
| restricts the selection of grouped rows based on a condition. | show 🗑
|
||||
| The syntax for a left outer join is _____. | show 🗑
|
||||
| SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition | show 🗑
|
||||
| What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE | show 🗑
|
||||
| show | When using a(n) _____ join, only rows from the tables that match on a common value are returned.
🗑
|
||||
| When using a(n) _____ join, only rows from the tables that match on a common value are returned. | show 🗑
|
||||
| inner | show 🗑
|
||||
| show | MON
🗑
|
||||
| MON | show 🗑
|
||||
| show | <>
🗑
|
||||
| <> | show 🗑
|
||||
| show | The outer subquery initiates the process of execution in a subquery.
🗑
|
||||
| The outer subquery initiates the process of execution in a subquery. | show 🗑
|
||||
| show | SELECT UNIQUE V_CODE FROM PRODUCT;
🗑
|
||||
| SELECT UNIQUE V_CODE FROM PRODUCT; | show 🗑
|
||||
| _____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not. | show 🗑
|
||||
| %FOUND | show 🗑
|
||||
| show | persistent storage module (PSM)
🗑
|
||||
| show | A table can be deleted from the database by using the _____ TABLE command.
🗑
|
||||
| A table can be deleted from the database by using the _____ TABLE command. | show 🗑
|
||||
| DROP | show 🗑
|
||||
| show | implicit
🗑
|
||||
| implicit | show 🗑
|
||||
| All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make. | show 🗑
|
||||
| show | In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.
🗑
|
||||
| show | Procedural Language SQL
🗑
|
||||
| Procedural Language SQL | show 🗑
|
||||
| In Oracle, _____ retrieves the current value of a sequence. | show 🗑
|
||||
| show | No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.
🗑
|
||||
| No matter what language you use, if it contains embedded SQL statements, it is called the _____ language. | show 🗑
|
||||
| host | show 🗑
|
||||
| Oracle recommends _____ for creating audit logs. | show 🗑
|
||||
| show | SQL requires the use of the _____command to enter data into a table.
🗑
|
||||
| SQL requires the use of the _____command to enter data into a table. | show 🗑
|
||||
| show | The _____ command is used to restore the database to its previous condition.
🗑
|
||||
| The _____ command is used to restore the database to its previous condition. | show 🗑
|
||||
| ROLLBACK | show 🗑
|
||||
| show | COMMIT
🗑
|
||||
| COMMIT | show 🗑
|
||||
| show | CHECK
🗑
|
||||
| show | The _____ pseudo-column is used to select the next value from a sequence.
🗑
|
||||
| The _____ pseudo-column is used to select the next value from a sequence. | show 🗑
|
||||
| NEXTVAL | show 🗑
|
||||
| The _____ specification creates an individual index on a respective attribute; use it to avoid having duplicated values in a column. | show 🗑
|
||||
| show | The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint.
🗑
|
||||
| The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint. | show 🗑
|
||||
| show | The Oracle equivalent to an MS Access AutoNumber is a(n) _____.
🗑
|
||||
| show | sequence
🗑
|
||||
| show | The Oracle string concatenation function is _____.
🗑
|
||||
| show | ||
🗑
|
||||
| show | The PL/SQL block starts with the _____ section.
🗑
|
||||
| The PL/SQL block starts with the _____ section. | show 🗑
|
||||
| DECLARE | show 🗑
|
||||
| The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables. | show 🗑
|
||||
| base | show 🗑
|
||||
| show | DEFAULT
🗑
|
||||
| DEFAULT | show 🗑
|
||||
| Using the _____command, SQL indexes can be created on the basis of any selected attribute. | show 🗑
|
||||
| CREATE INDEX | show 🗑
|
||||
| When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____. | show 🗑
|
||||
| all rows will be deleted | show 🗑
|
||||
| show | parentheses
🗑
|
||||
| show | When you create a new database, the RDBMS automatically creates the data _____ tables in which to store the metadata and creates a default database administrator.
🗑
|
||||
| When you create a new database, the RDBMS automatically creates the data _____ tables in which to store the metadata and creates a default database administrator. | show 🗑
|
||||
| dictionary | show 🗑
|
||||
| Which command would be used to delete the table row where the P_CODE is ‘BRT-345’? | show 🗑
|
||||
| show | Which SQL format would be best used for a small, numeric data type?
🗑
|
||||
| show | SMALLINT
🗑
|
||||
| show | Which statement describes a feature of Oracle sequences?
🗑
|
||||
| show | Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.
🗑
|
||||
| show | Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.
🗑
|
||||
| Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns. | show 🗑
|
||||
| show | You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This is known as _____.
🗑
|
||||
| show | referential integrity
🗑
|
||||
| show | _____ are required to prevent another transaction form reading inconsistent data.
🗑
|
||||
| _____ are required to prevent another transaction form reading inconsistent data. | show 🗑
|
||||
| show | _____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
🗑
|
||||
| show | Isolation
🗑
|
||||
| Isolation | show 🗑
|
||||
| show | Inconsistent retrieval
🗑
|
||||
| show | _____ requires that all operations of a transaction be completed.
🗑
|
||||
| show | Atomicity
🗑
|
||||
| Atomicity | show 🗑
|
||||
| show | row-level
🗑
|
||||
| show | A _____ lock will lock the entire diskpage.
🗑
|
||||
| A _____ lock will lock the entire diskpage. | show 🗑
|
||||
| page-level | show 🗑
|
||||
| show | table-level
🗑
|
||||
| table-level | show 🗑
|
||||
| A consistent database state is one in which all _____. | show 🗑
|
||||
| show | A diskpage, or page, is the equivalent of a _____.
🗑
|
||||
| A diskpage, or page, is the equivalent of a _____. | show 🗑
|
||||
| show | A single-user database system automatically ensures_____ of the database, because only one transaction is executed at a time.
🗑
|
||||
| show | serializability and isolation
🗑
|
||||
| serializability and isolation | show 🗑
|
||||
| A(n) _____ condition occurs when two or more transactions wait for each other to unlock data. | show 🗑
|
||||
| show | A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock.
🗑
|
||||
| A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock. | show 🗑
|
||||
| show | A(n) _____ phase in a two phase lock is when a transaction releases all locks and cannot obtain a new lock.
🗑
|
||||
| A(n) _____ phase in a two phase lock is when a transaction releases all locks and cannot obtain a new lock. | show 🗑
|
||||
| shrinking | show 🗑
|
||||
| A(n) _____ specifically reserves access to the transaction that locked the object. | show 🗑
|
||||
| show | ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements _____ and ROLLBACK.
🗑
|
||||
| show | COMMIT
🗑
|
||||
| COMMIT | show 🗑
|
||||
| As long as two transactions, T1 and T2, access _____ data, there is no conflict, and the order of execution is irrelevant to the final outcome. | show 🗑
|
||||
| unrelated | show 🗑
|
||||
| In the optimistic approach, during the _____ phase, changes are permanently applied to the database. | show 🗑
|
||||
| write | show 🗑
|
||||
| show | read
🗑
|
||||
| read | show 🗑
|
||||
| show | older transaction waits for the younger one to complete and release its locks.
🗑
|
||||
| older transaction waits for the younger one to complete and release its locks. | show 🗑
|
||||
| show | granularity
🗑
|
||||
| granularity | show 🗑
|
||||
| Of the following events, which is defined by ANSI as being equivalent to a COMMIT? | show 🗑
|
||||
| The end of a program is successfully reached. | show 🗑
|
||||
| show | All changes are aborted and returned to a previous consistent state.
🗑
|
||||
| All changes are aborted and returned to a previous consistent state. | show 🗑
|
||||
| One of the three most common data integrity and consistency problems is _____. | show 🗑
|
||||
| show | The _____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.
🗑
|
||||
| show | time stamping
🗑
|
||||
| time stamping | show 🗑
|
||||
| show | repeatable read
🗑
|
||||
| show | The _____ manager is responsible for assigning and policing the locks used by transactions.
🗑
|
||||
| The _____ manager is responsible for assigning and policing the locks used by transactions. | show 🗑
|
||||
| lock | show 🗑
|
||||
| The implicit beginning of a transaction is when _____. | show 🗑
|
||||
| show | The information stored in the _____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash.
🗑
|
||||
| The information stored in the _____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash. | show 🗑
|
||||
| transaction log | show 🗑
|
||||
| show | logical
🗑
|
||||
| logical | show 🗑
|
||||
| What rule applies to the two-phase locking protocol? | show 🗑
|
||||
| show | _____ is the central activity during the parsing phase in query processing.
🗑
|
||||
| _____ is the central activity during the parsing phase in query processing. | show 🗑
|
||||
| show | _____ refers to the number of different values a column could possibly have.
🗑
|
||||
| show | Data sparsity
🗑
|
||||
| show | A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.
🗑
|
||||
| show | extents
🗑
|
||||
| show | A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
🗑
|
||||
| show | file groups
🗑
|
||||
| show | A(n) _____ is a logical grouping of several data files that store data with similar characteristics.
🗑
|
||||
| A(n) _____ is a logical grouping of several data files that store data with similar characteristics. | show 🗑
|
||||
| show | Automatic query optimization means that the:
🗑
|
||||
| show | DBMS finds the most cost-effective access path without user intervention.
🗑
|
||||
| DBMS finds the most cost-effective access path without user intervention. | show 🗑
|
||||
| show | B-tree index
🗑
|
||||
| B-tree index | show 🗑
|
||||
| show | fetch
🗑
|
||||
| show | From the performance point of view, _____ databases eliminate disk access bottlenecks.
🗑
|
||||
| From the performance point of view, _____ databases eliminate disk access bottlenecks. | show 🗑
|
||||
| in-memory | show 🗑
|
||||
| If there is no index, the DBMS will perform a _____ scan. | show 🗑
|
||||
| show | In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.
🗑
|
||||
| show | batch
🗑
|
||||
| show | In standard SQL, the optimizer hint FIRST_ROWS is generally used for _____ mode processes.
🗑
|
||||
| show | interactive
🗑
|
||||
| show | In the context of RAID levels, _____ refers to writing the same data blocks to separate drives.
🗑
|
||||
| show | mirroring
🗑
|
||||
| mirroring | show 🗑
|
||||
| show | an index
🗑
|
||||
| On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ | show 🗑
|
||||
| DBMS performance | show 🗑
|
||||
| The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions. | show 🗑
|
||||
| sort | show 🗑
|
||||
| The _____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions. | show 🗑
|
||||
| procedure cache | show 🗑
|
||||
| show | data cache
🗑
|
||||
| data cache | show 🗑
|
||||
| show | optimizer
🗑
|
||||
| optimizer | show 🗑
|
||||
| show | after; before
🗑
|
||||
| after; before | show 🗑
|
||||
| The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM. | show 🗑
|
||||
| buffer cache | show 🗑
|
||||
| show | parses
🗑
|
||||
| show | The majority of primary memory resources will be allocated to the _____ cache.
🗑
|
||||
| The majority of primary memory resources will be allocated to the _____ cache. | show 🗑
|
||||
| data | show 🗑
|
||||
| show | ANALYZE <TABLE/INDEX>object_name COMPUTE STATISTICS;
🗑
|
||||
| show | To work with data, a DBMS must retrieve the data from _____ and place them in _____.
🗑
|
||||
| show | permanent storage; RAM
🗑
|
||||
| show | When moving data from permanent storage to RAM, an I/O disk operation retrieves a(n):
🗑
|
||||
| show | entire physical disk block.
🗑
|
||||
| entire physical disk block. | show 🗑
|
||||
| show | ALL_ROWS
🗑
|
||||
| ALL_ROWS | show 🗑
|
||||
| show | Parsing
🗑
|
||||
| show | _____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.
🗑
|
||||
| show | Homogeneous
🗑
|
||||
| show | _____ fragmentation allows a user to break a single object into two or more segments, or fragments.
🗑
|
||||
| _____ fragmentation allows a user to break a single object into two or more segments, or fragments. | show 🗑
|
||||
| show | _____ fragmentation refers to the division of a relation into attribute subsets.
🗑
|
||||
| show | Vertical
🗑
|
||||
| Vertical | show 🗑
|
||||
| _____ fragmentation refers to the division of a relation into subsets of tuples. | show 🗑
|
||||
| Horizontal | show 🗑
|
||||
| _____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B. | show 🗑
|
||||
| Network latency | show 🗑
|
||||
| _____ transparency allows a physically dispersed database to be managed as though it were centralized. | show 🗑
|
||||
| show | _____ transparency allows data to be updated simultaneously at several network sites.
🗑
|
||||
| show | Transaction
🗑
|
||||
| Transaction | show 🗑
|
||||
| show | Performance
🗑
|
||||
| show | _____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
🗑
|
||||
| _____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located. | show 🗑
|
||||
| Location | show 🗑
|
||||
| show | Fragmentation
🗑
|
||||
| Fragmentation | show 🗑
|
||||
| show | fully heterogeneous
🗑
|
||||
| show | A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.
🗑
|
||||
| show | remote request
🗑
|
||||
| remote request | show 🗑
|
||||
| A _____ request lets a single SQL statement reference data located at several different local or remote DP sites. | show 🗑
|
||||
| distributed | show 🗑
|
||||
| A centralized database management is subject to a problem such as _____. | show 🗑
|
||||
| growing numbers of remote locations | show 🗑
|
||||
| A database management system needs _____ to prepare the data for presentation to the end user or to an application program. | show 🗑
|
||||
| show | A DDBMS is subject to which restriction?
🗑
|
||||
| A DDBMS is subject to which restriction? | show 🗑
|
||||
| show | A disadvantage of a distributed database management system (DDBMS) is:
🗑
|
||||
| A disadvantage of a distributed database management system (DDBMS) is: | show 🗑
|
||||
| lack of standards. | show 🗑
|
||||
| A distributed _____ can reference several different local or remote data processing sites. | show 🗑
|
||||
| Data location | show 🗑
|
||||
| show | data dictionary
🗑
|
||||
| data dictionary | show 🗑
|
||||
| A distributed database is composed of several parts known as database _____. | show 🗑
|
||||
| show | A(n) _____ database stores each database fragment at a single site.
🗑
|
||||
| A(n) _____ database stores each database fragment at a single site. | show 🗑
|
||||
| unreplicated | show 🗑
|
||||
| Distributed processing does not require: | show 🗑
|
||||
| show | During _____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.
🗑
|
||||
| show | partitioned
🗑
|
||||
| partitioned | show 🗑
|
||||
| show | data processor
🗑
|
||||
| data processor | show 🗑
|
||||
| The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state. | show 🗑
|
||||
| show | The _____ processor is the software component found in each computer that requests data. It receives and processes the application’s data requests.
🗑
|
||||
| show | transaction
🗑
|
||||
| transaction | show 🗑
|
||||
| show | mutual consistency
🗑
|
||||
| show | The objective of _____ optimization is to minimize the total cost associated with the execution of a request.
🗑
|
||||
| show | query
🗑
|
||||
| query | show 🗑
|
||||
| Which property of the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database? | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
beaureqwreqw