Quiz
Database Design & Implementation Final Exam
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (68)
1A data model is a plan for a database design.
- ATrue
- BFalse
2The method of constructing data models used in the text is the extended entity-relationship (E-R) model.
- ATrue
- BFalse
3An entity instance is an occurrence of a particular entity.
- ATrue
- BFalse
4An identifier of an entity instance is one or more attributes that name or identify entity instances.
- ATrue
- BFalse
5In E-R modeling, an attribute describes the characteristics of an entity.
- ATrue
- BFalse
6In E-R modeling, entities within an entity class may have different attributes.
- ATrue
- BFalse
7Entities can be associated with one another in relationships.
- ATrue
- BFalse
8The Information Engineering (IE) model created by James Martin is often referred to as the IE Crowe’s Foot model.
- ATrue
- BFalse
9A principal difference between an entity and a table is that you can express a relationship between entities without using foreign keys.
- ATrue
- BFalse
10The notation 1:N shows a relationship's maximum cardinalities.
- ATrue
- BFalse
11Relationships are classified by their cardinality.
- ATrue
- BFalse
12In an E-R model, the three types of maximum cardinality are 1:1, 1:N, and N:M.
- ATrue
- BFalse
13In a 1:N relationship, the term parent refers to the N side of the relationship.
- ATrue
- BFalse
14An entity's minimum cardinality in a relationship indicates whether or not an entity must participate in the relationship.
- ATrue
- BFalse
15ID-dependent entities are associated by a nonidentifying relationship.
- ATrue
- BFalse
16ID-dependent entities are a common type of weak entity.
- ATrue
- BFalse
17An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.
- ATrue
- BFalse
18Entities with an IS-A relationship should have the same identifier.
- ATrue
- BFalse
19Relationships between supertypes and subtypes are called IS-A relationships.
- ATrue
- BFalse
20Which of the following is not a key element of an E-R model?
- ARelationships
- BEntities
- CObjects
- DAttributes
21An occurrence of a particular entity is called an ________.
- Aentity class
- Bentity relationship
- Centity instance
- Dentity attribute
22The characteristics of a thing are described by its ________.
- Aidentifiers
- Bentities
- Cobjects
- Dattributes
23Which of the following is not a common variant of the E-R model?
- AIE Crow's Foot
- BIDEF1X
- CUML
- DObject-oriented
24Minimum cardinality refers to ________.
- Athe most instances of one entity class that can be involved in a relationship with one instance of another entity class
- Bthe number of entity classes involved in a relationship
- Cthe number of entity instances that must participate in a relationship
- Dwhether or not an entity is a weak entity
25In a minimum cardinality, minimums are generally stated as ________.
- A0 or 1
- B1 or N
- CM or N
- Done or many
26A circle across the relationship line near an entity indicates ________.
- Aa maximum cardinality of "zero"
- Ba maximum cardinality of "one"
- Ca minimum cardinality of "optional"
- Da minimum cardinality of "required"
27Supertype/subtype entities are said to have a(n) ________ relationship.
- AHAS-A
- BIS-A
- Crecursive
- Dredundant
28When creating a relational database design from E-R diagrams, first create a relation for each relationship.
- ATrue
- BFalse
29When creating a table in the relational database design from an entity in the extended E-R model, the attributes of the entity become the rows of the table.
- ATrue
- BFalse
30The ideal primary key is short, numeric, and fixed.
- ATrue
- BFalse
31The values of a surrogate key have no meaning to the users.
- ATrue
- BFalse
32A null value is an attribute value that has been set to zero.
- ATrue
- BFalse
33A data constraint is a limitation on data values.
- ATrue
- BFalse
34A foreign key is a key that does not belong in any table.
- ATrue
- BFalse
35To represent an N:M relationship in a relational database design, an intersection table is created.
- ATrue
- BFalse
36To represent an N:M relationship in a relational database design, in essence it is reduced to two 1:N relationships.
- ATrue
- BFalse
37An intersection table is always ID-dependent on both of its parent tables.
- ATrue
- BFalse
38Association tables sometimes connect more than two entities.
- ATrue
- BFalse
39Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.
- ATrue
- BFalse
40A referential integrity constraint policy that insures that all rows containing a foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.
- ATrue
- BFalse
41The first step in transforming an extended E-R model into a relational database design is to ________.
- Acreate a table for each relationship
- Bevaluate the entities against the normalization criteria
- Ccreate a table for each entity
- Dremove any recursive relationships
42Each attribute of an entity becomes a(n) ________ of a table.
- Acolumn
- Bprimary key
- Cforeign key
- Dalternate key
43In a relational database design, all relationships are expressed by ________.
- Acreating a primary key
- Bcreating a foreign key
- Ccreating a supertype
- Dcreating a subtype
44To represent a one-to-many relationship in a relational database design, ________.
- Athe key of the child is placed as a foreign key into the parent
- Bthe key of the parent is placed as a foreign key into the child
- Can intersection table must be created
- Dthe key of the table on the "many" side is placed in the table on the "one" side
45Many-to-many relationships are represented by ________.
- Atwo tables with an M:N relationship
- Btwo tables with a 1:N relationship
- Can intersection table which has M:N relationships with the two tables
- Dan intersection table which has 1:N relationships with the two tables
46A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.
- Ais known as a minimum cardinality enforcement action
- Bneeds to be documented by the database development team
- Cis enforced in most DBMS products
- DBoth A and B are correct
47A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
- Aincremental updates
- Bincremental deletes
- Ccascading updates
- Dcascading deletes
48The CONSTRAINT keyword is used to define one of several types of constraints.
- ATrue
- BFalse
49The CONSTRAINT keyword can be used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.
- ATrue
- BFalse
50The UNIQUE keyword is used to define alternate keys.
- ATrue
- BFalse
51The MODIFY keyword is used to change the structure, properties or constraints of a table.
- ATrue
- BFalse
52The ALTER keyword is used to change the structure, properties or constraints of a table.
- ATrue
- BFalse
53Data values to be added to a table are specified by using the VALUES clause.
- ATrue
- BFalse
54One or more rows can be added to a table by using the INSERT statement.
- ATrue
- BFalse
55Rows in a table can be changed by using the UPDATE statement.
- ATrue
- BFalse
56An SQL virtual table is called a view.
- ATrue
- BFalse
57SQL views can be used to hide columns.
- ATrue
- BFalse
58SQL views are updatable when the view is based on a single table with no computed columns, and all non-null columns are present in the view.
- ATrue
- BFalse
59Which SQL keyword is used to name a new table and describe the table's columns?
- ASET
- BCREATE
- CSELECT
- DALTER
60Which SQL keyword is used to impose restrictions on a table, data or relationship?
- ASET
- BCREATE
- CSELECT
- DCONSTRAINT
61Given the SQL statement:
CREATE TABLE SALESREP (
SalesRepNo int NOT NULL,
RepName char(35) NOT NULL,
HireDate date NOT NULL,
CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo),
CONSTRAINT SalesRepAK1 UNIQUE (RepName)
);
We know that ________.- ARepName is the primary key
- BRepName is a foreign key
- CRepName is a candidate key
- DRepName is a surrogate key
62Which SQL keyword is used to change the structure, properties or constraints of a table?
- ASET
- BCREATE
- CSELECT
- DALTER
63Which SQL keyword is used to delete a table's structure?
- ADELETE
- BDROP
- CDISPOSE
- DALTER
64Which SQL keyword is used to change the values of an entire column?
- ACHANGE
- BINSERT
- CSELECT
- DSET
65SQL views are not used ________.
- Ato hide columns
- Bto show results of computed columns
- Cto hide complicated SQL statements
- Dto enforce primary key constraints
66A stored program that is attached to a table or view is called ________.
- Aa CHECK constraint
- Ba view
- Cembedded SQL
- Da trigger
67A stored program that is attached to the database is called ________.
- Aa view
- Bembedded SQL
- Ca trigger
- Da stored procedure
68Referential integrity constraints are implemented in SQL using the ________ syntax.
- APRIMARY KEY
- BFOREIGN KEY
- CDEFAULT
- DUNIQUE
Information
- Description
- Quiz on Database Design & Implementation Final Exam, created by TouChee Moua on 29/11/2021.
- Author
- TouChee Moua
- Language
- English
- Views
- 3
- Rating
- No ratings yet Rate this quiz