Question 1

The field on which records are sorted is called the composite primary key.

Accepted Answer

A) True 
 B)False

Question 2

In relational algebra, what command causes only certain columns to be included in the new table?

Accepted Answer

A)   SELECT
B)   DELETE
C)   PROGRAM
D)   PROJECTE) B) and D)
F) All of the above

Question 3

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum) ?SalesPerson (SalesPersonNum, LastName, FirstName)

Accepted Answer

A)   PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
B)   UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
C)   SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales
D)   JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSalesE) B) and D)
F) A) and D)

Question 4

The attributes of an entity become the fields or columns in a table.

Accepted Answer

A) True 
 B)False

Question 5

Which operation will allow you to extract data from more than one table?

Accepted Answer

A)   Select
B)   Merge
C)   Project
D)   JoinE) A) and B)
F) B) and D)

Question 6

How do you refer to a column named State in a table named Client?

Accepted Answer

A)   State.Client
B)   State(Client) 
C)   Client.State
D)   Client(State) E) A) and B)
F) All of the above

Question 7

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

Accepted Answer

A)   primary key
B)   secondary key
C)   foreign key
D)   minor keyE) A) and B)
F) A) and C)

Question 8

Which term is another word for a row in a table?

Accepted Answer

A)   tuple
B)   field
C)   group
D)   relationE) A) and B)
F) C) and D)

Question 9

The concept of grouping means that statistics will be calculated for individual records.

Accepted Answer

A) True 
 B)False

Question 10

List the six properties that define a relation in a two-dimensional table.

Accepted Answer

A relation is a two-dimensional table in...

Question 11

A column whose value uniquely identifies a given row in the table is the secondary key.

Accepted Answer

A) True 
 B)False

Question 12

The primary key of a table is the row or rows that uniquely identify a given column in that table.

Accepted Answer

A) True 
 B)False

Question 13

The relational operators are +, *, %, and /.

Accepted Answer

A) True 
 B)False

Question 14

A query is a question represented in a way that the DBMS can recognize and process.

Accepted Answer

A) True 
 B)False

Question 15

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

Accepted Answer

unnormaliz...

Question 16

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

Accepted Answer

A)   They are union compatible.
B)   They are intersection compatible.
C)   They are difference compatible.
D)   They are product compatible.E) None of the above
F) B) and C)

Question 17

In the Access Query window, the upper portion of the window contains the design grid.

Accepted Answer

A) True 
 B)False

Question 18

The compound criteria (conditions)  are created by using which of the following two keywords?

Accepted Answer

A)   AND, OR
B)   AND, NOR
C)   OR, NOT
D)   NOT, ONLYE) A) and D)
F) A) and B)

Question 19

What is the difference between an AND criterion and an OR criterion?

Accepted Answer

In an AND criterion, both crit...

Question 20

What type of query changes data?

Accepted Answer

A)   addition
B)   update
C)   update.
D)   selectE) A) and B)
F) A) and C)

Exam 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

List the six properties that define a relation in a two-dimensional table.

Correct AnswerverifiedA relation is a two-dimensional table in...View AnswerShow Answer

The relational operators are +, *, %, and /.

Correct AnswerverifiedShow Answer

The compound criteria (conditions) are created by using which of the following two keywords?

Correct AnswerverifiedShow Answer

Which operation will allow you to extract data from more than one table?

Correct AnswerverifiedShow Answer

The field on which records are sorted is called the composite primary key.

Correct AnswerverifiedShow Answer

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

Correct Answerverifiedunnormaliz...View AnswerShow Answer

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

Correct AnswerverifiedShow Answer

What is the difference between an AND criterion and an OR criterion?

Correct AnswerverifiedIn an AND criterion, both crit...View AnswerShow Answer

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

Correct AnswerverifiedShow Answer

In the Access Query window, the upper portion of the window contains the design grid.

Correct AnswerverifiedShow Answer

The concept of grouping means that statistics will be calculated for individual records.

Correct AnswerverifiedShow Answer

A column whose value uniquely identifies a given row in the table is the secondary key.

Correct AnswerverifiedShow Answer

What type of query changes data?

Correct AnswerverifiedShow Answer

In relational algebra, what command causes only certain columns to be included in the new table?

Correct AnswerverifiedShow Answer

The primary key of a table is the row or rows that uniquely identify a given column in that table.

Correct AnswerverifiedShow Answer

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum) ?SalesPerson (SalesPersonNum, LastName, FirstName)

Correct AnswerverifiedShow Answer

Which term is another word for a row in a table?

Correct AnswerverifiedShow Answer

A query is a question represented in a way that the DBMS can recognize and process.

Correct AnswerverifiedShow Answer

The attributes of an entity become the fields or columns in a table.

Correct AnswerverifiedShow Answer

How do you refer to a column named State in a table named Client?

Correct AnswerverifiedShow Answer

Correct Answer
verified
A relation is a two-dimensional table in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
unnormaliz...
View Answer

Correct Answer
verified

Correct Answer
verified
In an AND criterion, both crit...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified