Question 1

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Accepted Answer

The answer of In Microsoft Access,the Relationships window is accessed...

Question 2

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key

Question 3

Given the relations:
STUDENT (SID,StudentName,Major,AdvisorID)
ADVISOR (AdvisorID,AdvisorName,Office,Phone)
Such that each student is assigned to one advisor,which of the following is true?

Accepted Answer

A)  SID is both a primary key and a foreign key. 
B)  AdvisorName is a determinant. 
C)  AdvisorID is a foreign key. 
D)  Phone is a candidate key. 
E)  Major is a candidate key. 
A)  SID is both a primary key and a foreign key. 
B)  AdvisorName is a determinant. 
C)  AdvisorID is a foreign key. 
D)  Phone is a candidate key. 
E)  Major is a candidate key.

Question 4

Which of the following terms is synonymous with "tuple"?

Accepted Answer

A)  Attribute 
B)  Table 
C)  Field 
D)  Row 
E)  Relation 
A)  Attribute 
B)  Table 
C)  Field 
D)  Row 
E)  Relation

Question 5

In Microsoft Access,the relationship between two tables is not actually created until ________.

Accepted Answer

A)  the OK button in the Create Relationships dialog box is clicked 
B)  the Create button in the Create Relationships dialog box is clicked 
C)  the OK button in the Edit Relationships dialog box is clicked 
D)  the Create button in the Edit Relationships dialog box is clicked 
E)  the Join button in the Edit Relationships dialog box is clicked 
A)  the OK button in the Create Relationships dialog box is clicked 
B)  the Create button in the Create Relationships dialog box is clicked 
C)  the OK button in the Edit Relationships dialog box is clicked 
D)  the Create button in the Edit Relationships dialog box is clicked 
E)  the Join button in the Edit Relationships dialog box is clicked

Question 6

Which of the following is not true about null values?

Accepted Answer

A)  A null value can mean that the value is unknown. 
B)  A null value is ambiguous. 
C)  A null value can mean that the value is known to be blank. 
D)  A null value can mean that no value for the field is appropriate. 
E)  Null values cannot be avoided. 
A)  A null value can mean that the value is unknown. 
B)  A null value is ambiguous. 
C)  A null value can mean that the value is known to be blank. 
D)  A null value can mean that no value for the field is appropriate. 
E)  Null values cannot be avoided.

Question 7

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Accepted Answer

A) True 
 B)False

Question 8

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Accepted Answer

A) True 
 B)False

Question 9

A key that contains two or more attributes is called a(n)________ key.

Accepted Answer

The answer of A key that contains two or more...

Question 10

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

Accepted Answer

A) True 
 B)False

Question 11

In the normalization process,if you find a candidate key that is not a determinant then you should not ________.

Accepted Answer

A)  place the columns of the functional dependency in a new relation 
B)  make the determinant of the functional dependency the primary key of the new relation 
C)  leave a copy of the determinant as a foreign key in the original relation 
D)  rename the determinant to another attribute description 
E)  create a referential integrity constraint between the original relation and the new relation 
A)  place the columns of the functional dependency in a new relation 
B)  make the determinant of the functional dependency the primary key of the new relation 
C)  leave a copy of the determinant as a foreign key in the original relation 
D)  rename the determinant to another attribute description 
E)  create a referential integrity constraint between the original relation and the new relation

Question 12

A surrogate key may be appropriate under which of the following circumstances?

Accepted Answer

A)  The primary key is not unique. 
B)  The primary key is numeric. 
C)  The available candidate keys would be prone to typographical errors. 
D)  The available candidate keys have little meaning to the users. 
E)  The relation only has one attribute. 
A)  The primary key is not unique. 
B)  The primary key is numeric. 
C)  The available candidate keys would be prone to typographical errors. 
D)  The available candidate keys have little meaning to the users. 
E)  The relation only has one attribute.

Question 13

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Accepted Answer

A) True 
 B)False

Question 14

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.

Accepted Answer

A)  normalization 
B)  a referential integrity constraint 
C)  a key matching constraint 
D)  a functional dependency 
E)  synchronization 
A)  normalization 
B)  a referential integrity constraint 
C)  a key matching constraint 
D)  a functional dependency 
E)  synchronization

Question 15

A primary key is ________.

Accepted Answer

A)  not required to be unique 
B)  used to represent columns in relationships 
C)  a candidate key 
D)  always automatically generated by the DBMS 
E)  comprised of exactly one attribute 
A)  not required to be unique 
B)  used to represent columns in relationships 
C)  a candidate key 
D)  always automatically generated by the DBMS 
E)  comprised of exactly one attribute

Question 16

In Microsoft Access,relationships between tables are created ________.

Accepted Answer

A)  by the Relationships button on the Create command tab 
B)  by the Relationships button on the Home command tab 
C)  in the Relationships window 
D)  in the Table window of the table containing the primary key 
E)  in the Table window of the table containing the foreign key 
A)  by the Relationships button on the Create command tab 
B)  by the Relationships button on the Home command tab 
C)  in the Relationships window 
D)  in the Table window of the table containing the primary key 
E)  in the Table window of the table containing the foreign key

Question 17

Candidate keys may or may not be unique.

Accepted Answer

A) True 
 B)False

Question 18

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Accepted Answer

A) True 
 B)False

Question 19

A key that contains more than one attribute is called a(n)________.

Accepted Answer

A)  composite key 
B)  complex key 
C)  multi-key 
D)  n-key 
E)  candidate key 
A)  composite key 
B)  complex key 
C)  multi-key 
D)  n-key 
E)  candidate key

Question 20

During the normalization process,the remedy for a relation that is not well formed is to ________.

Accepted Answer

A)  create a surrogate key 
B)  create a functional dependency 
C)  break it into two or more relations that are well formed 
D)  combine it with another relation that is well formed 
E)  convert it into a list 
A)  create a surrogate key 
B)  create a functional dependency 
C)  break it into two or more relations that are well formed 
D)  combine it with another relation that is well formed 
E)  convert it into a list

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Distinguish between the primary key and a candidate key.

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

Which of the following terms is synonymous with "tuple"?

In Microsoft Access,the relationship between two tables is not actually created until ________.

Which of the following is not true about null values?

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

A key that contains two or more attributes is called a(n)________ key.

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

In the normalization process,if you find a candidate key that is not a determinant then you should not ________.

A surrogate key may be appropriate under which of the following circumstances?

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.

A primary key is ________.

In Microsoft Access,relationships between tables are created ________.

Candidate keys may or may not be unique.

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

A key that contains more than one attribute is called a(n)________.

During the normalization process,the remedy for a relation that is not well formed is to ________.

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 2: The Relational Model

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Distinguish between the primary key and a candidate key.

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

Which of the following terms is synonymous with "tuple"?

In Microsoft Access,the relationship between two tables is not actually created until ________.

Which of the following is not true about null values?

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

A key that contains two or more attributes is called a(n)________ key.

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

In the normalization process,if you find a candidate key that is not a determinant then you should not ________.

A surrogate key may be appropriate under which of the following circumstances?

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.

A primary key is ________.

In Microsoft Access,relationships between tables are created ________.

Candidate keys may or may not be unique.

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

A key that contains more than one attribute is called a(n)________.

During the normalization process,the remedy for a relation that is not well formed is to ________.

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters