Question 1

QBE is a visual approach to writing queries.​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Multiple entries in tables are often called ____________________.​

Accepted Answer

The answer of Multiple entries in tables are often called...

Question 4

Explain what relational algebra is and how it is used.​

Accepted Answer

The answer of Explain what relational algebra is and how...

Question 5

When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.​

Accepted Answer

A)  ​do not use these two tables together 
B)  ​do not use the column names in the same statement 
C)  ​write both the table name and the column name, separated by a period 
D)  ​write the table name only

Question 6

A relational database handles entities,attributes,and relationships by storing each entity in its own table.​

Accepted Answer

A) True 
 B)False

Question 7

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.​

Accepted Answer

A)  ​union 
B)  ​intersection 
C)  ​difference 
D)  ​product

Question 8

Rows are also called ____.​

Accepted Answer

A)  ​fields 
B)  ​columns 
C)  ​tuples 
D)  ​attributes

Question 9

A ____ query creates a new table using the query results.​

Accepted Answer

A)  ​new-table 
B)  ​make-table 
C)  ​create-table 
D)  ​merge-table

Question 10

​Based on the statement below,which of the following is the primary key? Rep (RepNum,LastName,FirstName,Street,City,State,PostalCode Commission,Rate)

Accepted Answer

A)  ​RepNum 
B)  ​LastName 
C)  ​FirstName 
D)  ​State

Question 11

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

Accepted Answer

A)  ​Select 
B)  ​Merge 
C)  ​Project 
D)  ​Join

Question 12

Discuss the difference between the major sort key and the minor sort key.​

Accepted Answer

The answer of Discuss the difference between the major sort...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The ____ command within relational algebra takes a vertical subset of a table.​

Accepted Answer

A)  ​SELECT 
B)  ​DELETE 
C)  ​PROGRAM 
D)  ​PROJECT

Question 15

In an AND criterion,the overall criterion is true if either of the individual criteria is true.​

Accepted Answer

A) True 
 B)False

Question 16

In a relation,the order of the columns is important.

Accepted Answer

A) True 
 B)False

Question 17

You can restrict the output from a join to include only certain columns by using the ____ command.​

Accepted Answer

A)  ​DELETE 
B)  ​UNION 
C)  ​PROJECT 
D)  ​INTERSECT

Question 18

Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.​

Accepted Answer

A)  ​4 
B)  ​8 
C)  ​16 
D)  ​256

Question 19

A relational database is a collection of relations.

Accepted Answer

A) True 
 B)False

Question 20

Each column in a table should have a unique name,and entries in each column should all "match" this column name.​

Accepted Answer

A) True 
 B)False

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

QBE is a visual approach to writing queries.​

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

Multiple entries in tables are often called ____________________.​

Explain what relational algebra is and how it is used.​

When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.​

A relational database handles entities,attributes,and relationships by storing each entity in its own table.​

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.​

Rows are also called ____.​

A ____ query creates a new table using the query results.​

​Based on the statement below,which of the following is the primary key? Rep (RepNum,LastName,FirstName,Street,City,State,PostalCode Commission,Rate)

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

Discuss the difference between the major sort key and the minor sort key.​

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

The ____ command within relational algebra takes a vertical subset of a table.​

In an AND criterion,the overall criterion is true if either of the individual criteria is true.​

In a relation,the order of the columns is important.

You can restrict the output from a join to include only certain columns by using the ____ command.​

Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.​

A relational database is a collection of relations.

Each column in a table should have a unique name,and entries in each column should all "match" this column name.​

QBE is a visual approach to writing queries.

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

Multiple entries in tables are often called ____________________.

Explain what relational algebra is and how it is used.

When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.

A relational database handles entities,attributes,and relationships by storing each entity in its own table.

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.

Rows are also called ____.

A ____ query creates a new table using the query results.

Based on the statement below,which of the following is the primary key? Rep (RepNum,LastName,FirstName,Street,City,State,PostalCode Commission,Rate)

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

Discuss the difference between the major sort key and the minor sort key.

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

The ____ command within relational algebra takes a vertical subset of a table.

In an AND criterion,the overall criterion is true if either of the individual criteria is true.

You can restrict the output from a join to include only certain columns by using the ____ command.

Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.

Each column in a table should have a unique name,and entries in each column should all "match" this column name.