Question 1

A relation is a(n) ____.​

Accepted Answer

A)   ​attribute
B)   ​column
C)   ​field
D)   ​tableE) B) and C)
F) None of the above

Question 2

The compound criteria (conditions) are created by using ____.​

Accepted Answer

A)   ​AND, OR
B)   ​AND, NOR
C)   ​OR, NOT
D)   ​NOT, ONLYE) All of the above
F) None of the above

Question 3

In a relation,the order of rows is important.​

Accepted Answer

A) True 
 B)False

Question 4

​Conditions that data must satisfy are called ____________________.

Accepted Answer

The answer of ​Conditions that data must satisfy are called...

Question 5

A(n)____________________ database is a collection of tables.​

Accepted Answer

The answer of A(n)____________________ database is a collection of tables.​...

Question 6

​The comparison operators are also known as relational operators.

Accepted Answer

A) True 
 B)False

Question 7

Based on the Customer table below,which command lists all information from the table concerning customer 260?​ CustomerNum CustomerName Street City State PostalCode
126 Toys Galore 28 Laketon St. Fulton CA 90085
260 Brookings Direct 452 Columbus Dr. Grove CA 90092

Accepted Answer

A)   ​SELECT Customer 260 GIVING Answer
B)   ​SELECT Customer WHERE CustomerNum=260 GIVING Answer
C)   ​SELECT Customer WHERE Customernum='260' GIVING Answer
D)   ​SELECT Customer WHERE CustomerName='260' GIVING AnswerE) A) and B)
F) A) and C)

Question 8

The relationships between tables are handled through ____________________ columns.​

Accepted Answer

The answer of The relationships between tables are handled through...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n)____________________.​

Accepted Answer

​unnormali...

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

Conditions that data must satisfy are called ____________________.

Correct Answer
verified

A relation is a(n) ____.

Correct Answer
verified

The relationships between tables are handled through ____________________ columns.

Correct Answer
verified

A(n)____________________ database is a collection of tables.

Correct Answer
verified

The comparison operators are also known as relational operators.

Correct Answer
verified

Based on the Customer table below,which command lists all information from the table concerning customer 260? CustomerNum CustomerName Street City State PostalCode 126 Toys Galore 28 Laketon St. Fulton CA 90085 260 Brookings Direct 452 Columbus Dr. Grove CA 90092

Correct Answer
verified

The compound criteria (conditions) are created by using ____.

Correct Answer
verified

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

Correct Answer
verified

In a relation,the order of rows is important.

Correct Answer
verified

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n)____________________.

Correct Answer
verified
unnormali...
View Answer

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

​Conditions that data must satisfy are called ____________________.

Correct AnswerverifiedShow Answer

A relation is a(n) ____.​

Correct AnswerverifiedShow Answer

The relationships between tables are handled through ____________________ columns.​

Correct AnswerverifiedShow Answer

A(n)____________________ database is a collection of tables.​

Correct AnswerverifiedShow Answer

​The comparison operators are also known as relational operators.

Correct AnswerverifiedShow Answer

Based on the Customer table below,which command lists all information from the table concerning customer 260?​ CustomerNum CustomerName Street City State PostalCode 126 Toys Galore 28 Laketon St. Fulton CA 90085 260 Brookings Direct 452 Columbus Dr. Grove CA 90092

Correct AnswerverifiedShow Answer

The compound criteria (conditions) are created by using ____.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a relation,the order of rows is important.​

Correct AnswerverifiedShow Answer

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n)____________________.​

Correct Answerverified​unnormali...View AnswerShow Answer

Conditions that data must satisfy are called ____________________.

Correct Answer
verified

A relation is a(n) ____.

Correct Answer
verified

The relationships between tables are handled through ____________________ columns.

Correct Answer
verified

A(n)____________________ database is a collection of tables.

Correct Answer
verified

The comparison operators are also known as relational operators.

Correct Answer
verified

Based on the Customer table below,which command lists all information from the table concerning customer 260? CustomerNum CustomerName Street City State PostalCode 126 Toys Galore 28 Laketon St. Fulton CA 90085 260 Brookings Direct 452 Columbus Dr. Grove CA 90092

Correct Answer
verified

The compound criteria (conditions) are created by using ____.

Correct Answer
verified

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

Correct Answer
verified

In a relation,the order of rows is important.

Correct Answer
verified

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n)____________________.

Correct Answer
verified
unnormali...
View Answer