Select best definition of generalization .

It identifies a higher-level, more generic entity supertype from lower-level entity subtypes.

It identifies clusters of entities based on a given subtype.

It is the process that finds entity subtypes that are disjoint sets.

Select the best definition of total completeness .

Every supertype occurrence must be a member of at least one subtype.

Every subtype occurrence must be a member of at least two supertypes.

Select what IS NOT a primary key characteristic.

Primary keys are preferably string of characters.

Primary keys are non intelligent.

Primary keys do not change over time.

Primary keys are preferably single-attribute.

What IS NOT correct regarding entity clustering .

It is a “virtual” entity type used to represent multiple entities and relationships in ERD.

It is the grouping of attributes in supertypes for identifying subtypes.

It is the process of collapsing supertypes and subtypes in one single unit.

It is a "virtual" process of separating supertypes from subtypes.

Select the statement that IS NOT correct regarding inheritance .

Lower-level subtypes inherit all attributes but not relationships from its upper-level supertypes.

Entity subtypes inherit all relationships in which supertype entity participates

At the implementation level, supertype and its subtype(s) maintain a 1:1 relationship

All entity subtypes inherit their primary key attribute from their supertype

Select the best definition of subtype discriminator .

It is an attribute in the supertype entity that determines to which entity subtype the supertype occurrence is related.

It is a Boolean attribute (true and false values) in the supertype that determines if there exist subtypes.

It is an attribute in any subtype entity that has the least amount of NULL values.

It is a numerical attribute in the supertype entity that counts the number of subtypes.

What is normalization ?

Normalization is the process of valuating and correcting table structures to minimize data redundancies and data anomalies.

Normalization is the process of transforming data in tables such that they have the same point of reference.

Normalization is the process of reducing the amount of tables in a database.

Normalization is the process of identifying and removing composite tables.

Select what IS NOT correct regarding the normalization process.

Its goal is to guarantee that each row/column intersection contains a group of values.

Its objective is to ensure that each table conforms to the concept of well-formed relations.

No data item will be unnecessarily stored in more than one table.

All nonprime attributes in a table are dependent on the primary key.

Select the characteristic of the Boyce-Codd normal form (BCNF).

In this form every determinant is a candidate key (special case of 3NF).

This form is in table format, no repeating groups, and PK identified.

This form is 3NF and has no independent multivalued dependencies.

This form is 2NF and with no transitive dependencies.

Select the definition of partial dependency .

It is a functional dependence in which the determinant is only part of the primary key.

It happens when an attribute is dependent on another attribute that is not part of the primary key.

It occurs only when a functional dependence exists among nonprime attributes.

It is very difficult to identify among a certain data.

Select the two dependencies that need to be removed during the normalization process.

Partial dependency and Transitive dependency.

Partial dependency and Total dependency.

Recursive dependency and Partial dependency.

Iterative dependency and Partial dependency.

Select what IS NOT correct regarding dependency diagrams.

It reduces the number of redundant connections between attributes.

It depicts all dependencies found within given table structure.

It helps to get an overview of all relationships among table’s attributes.

It makes it less likely that an important dependency will be overlooked.

What IS CORRECT regarding to the conversion to 2NF.

It occurs only when the 1NF has a composite primary key.

It is performed even if the tables are not in 1NF.

It keeps all partial dependencies for the next normalization step.

It does not make new tables to eliminate partial dependencies.

What is the major goal for converting to 3NF?

To eliminate transitive dependencies.

To eliminate partial dependencies.

To eliminate partial and transitive dependencies.

To eliminate recursive dependencies.

After the tables are in 3NF the design should be improved. Select the activity that IS NOT part of improving the design.

Retest existing partial dependencies.

Evaluate PK assignments and naming conventions.

Identify new attributes and new relationships.

What IS NOT an item in the data modeling checklist?

Attribute names shouldn't be unique within the entity.

Entities should be nouns that are familiar to business and should be short and meaningful.

Identify the source of all business rules, and ensure that each business rule is justified, dated, and signed off by an approving authority.

Properly document and verify all business rules with the end users.

Select what IS correct about denormalization .

Creates larger tables and data updates are less efficient.

Select what IS correct about denormalization .

Increases the performance and band width of the Database system

When is a table in fourth normal form (4NF)

When it is in 3NF and has no multivalued dependencies.

When it is in BCNF and has one transitive dependency.

When it is in BCNF an has no multivalued dependencies.

When it is in 2NF and has only one multivalued dependency.

Select what IS NOT a category of the functions of SQL.

Database management language (DBML)

Data manipulation language (DML)

Transaction control language (TCL)

What is correct regarding SQL Queries?

in the SQL environment, the word query covers both questions and actions.

in the SQL environment, the word query covers only questions.

in the SQL environment, the word query covers only actions.

in the SQL environment, the word query covers both questions and answers.

What does the SELECT clause (in a SELECT query) do?.

It specifies the attributes to be returned by the query.

It selects the parameters used in a table.

It selects the rows from a given table.

It specifies the subtypes of the given entities.

What does the WHERE clause do?

It filters the rows of data based on provided criteria.

It identifies the location where the attributes are.

It filters the columns of data based on provided criteria.

It indicates where in the table is the requested row.

What is the FROM clause used for?

It specifies the table(s) from which the data will be retrieved.

It specifies the row(s) from which the data will be retrieved.

It specifies the column(s) from which the data will be retrieved.

It specifies the primary and foreign keys from which the data is connected.

What does the GROUP BY clause do?

It groups the rows of data into collections based on sharing the same values in one or more attributes.

It groups attributes that belongs to the dependent tables.

It groups the primary keys from related entities.

It groups the columns of data into collections based on sharing the same values.

Select the statement that produces a list of only those values that are different from one another in a given attribute (V_CODE).

SELECT DISTINCT V_CODE FROM PRODUCT;

SELECT * FROM PRODUCT DISTINCT V_CODE ;

SELECT * FROM PRODUCT DISTINCT=V_CODE ;

SELECT DISTINCT(V_CODE) FROM PRODUCT

What does a Natural Join do?

It returns all rows with matching values in the matching columns and eliminates duplicate columns.

It returns all columns with matching values in the matching rows and eliminates duplicate columns.

It returns duplicate rows with matching values in the matching columns.

It returns duplicate columns with matching values in the matching rows and eliminates duplicate rows.

Select the best definition of an Outer Join .

Outer joins return the same matched rows as the inner join, plus unmatched rows from one table or the other.

Outer joins return columns from the inner join, plus duplicated rows.

Outer joins return the same matched rows as the inner join, plus unmatched columns from one table or the other.

Outer joins return the matched rows from tables which belong to different databases.

What does the Cross Join do?

It performs a relational product (also known as the Cartesian product ) of two tables.

It performs a multiplication of two attributes and adds it to the table.

It performs the vector cross product resulting in a table orthogonal to the original tables.

It performs a set union of two tables and interchange columns in the final result.

Database Exam 2 Quizzes

Authored by Jake Fiorillo

Computers

University

Used 8+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

45 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Entity supertypes and subtypes are organized in a specialization hierarchy. Select the statement that IS NOT correct regarding supertypes and subtypes.

Every subtype has one supertype to which it is directly related.

A subtype exists within the context of a supertype.

Every subtype has one or more supertypes to which it is directly and indirectly related.

A supertype can have many subtypes.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the statement that IS NOT correct with respect to "specialization hierarchy".

It supports attribute inheritance.

It describes relationships in terms of "has-a" relationships.

It defines a special supertype attribute known as the subtype discriminator.

It defines disjoint or overlapping constraints and complete or partial constraints.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the statement that IS NOT correct.

An entity subtype contains unique characteristics which differentiate its instances from other instances of the supertype.

The selection of supertypes and and subtypes is independent of their attributes.

An entity supertype is a generic entity type related to one or more entity subtypes.

EER diagrams (EERDs) use the EER model.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select what IS NOT correct regarding surrogate primary keys.

It is used to simplify the identification of entity instances.

It is helpful if selected candidate key has embedded semantic contents or is too long.

It is useful when there is no natural key.

It is flexible allowing multiple NULL values.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select what IS NOT correct regarding disjoint subtypes.

They contain a unique subset of the supertype entity set.

Its Implementation is based on the value of the subtype discriminator attribute in the supertype.

They are known as nonoverlapping subtypes.

They share few instances that guarantee the relationship among them.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the best definition of partial completeness.

Not every subtype occurrence is a member of a supertype.

Not every supertype occurrence is a member of a subtype.

Every supertype occurrence is a member of a subtype.

Every subtype occurrence is a member of a supertype.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the best definition of overlapping subtypes.

They contain nonunique subsets of the supertype entity set.

Its implementation is based on the value of the subtype discriminator attribute in the supertype.

Its implementation does not require discriminator attribute.

They contain the same number of instances.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

49 questions

sal vize

Quiz

•

University

40 questions

Nerds quiz

Quiz

•

University

50 questions

MES3093: QUIZ

Quiz

•

University

45 questions

Computer memory

Quiz

•

University

44 questions

ACO.C1.HTTT

Quiz

•

University

46 questions

CompTIA ITFundamentals CRAM

Quiz

•

6th Grade - University

50 questions

ICT 51-100

Quiz

•

University

50 questions

DBMS-CCE 1_B.Sc-4_13-02-25

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

Database Exam 2 Quizzes

Entity supertypes and subtypes are organized in a specialization hierarchy. Select the statement that IS NOT correct regarding supertypes and subtypes.

Select the statement that IS NOT correct with respect to "specialization hierarchy".

Select the statement that IS NOT correct.

Select what IS NOT correct regarding surrogate primary keys.

Select what IS NOT correct regarding disjoint subtypes.

Select the best definition of partial completeness.

Select the best definition of overlapping subtypes.

Select the statement that IS NOT correct.

Select best definition of generalization.

Select the best definition of total completeness.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers