MIS 2113 Exam 1 Questions and
Answers
A student can attend five classes, each with a different professor. Each professor has 30
students. The relationship of students to professors is a ______ relationship - ANSWERS -Many-
to-many
A property or characteristic of an entity type that is of interest to the organization is called an -
ANSWERS -Attribute
Produce a report showing the Firstname and Lastname of customers who purchased black
shoes. - ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE Color = 'Black'
Produce a report showing the Firstname and Lastname of customers who purchased Nike shoes.
- ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE manufacturername = 'Nike'
Produce a report showing the Firstname, Lastname, and Category of customers who purchased
Nike sneakers. - ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE manufacturername = 'Nike' and category = 'Sneakers'
The maximum number of clauses in an SQL Select statement is: - ANSWERS -6
Answers
A student can attend five classes, each with a different professor. Each professor has 30
students. The relationship of students to professors is a ______ relationship - ANSWERS -Many-
to-many
A property or characteristic of an entity type that is of interest to the organization is called an -
ANSWERS -Attribute
Produce a report showing the Firstname and Lastname of customers who purchased black
shoes. - ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE Color = 'Black'
Produce a report showing the Firstname and Lastname of customers who purchased Nike shoes.
- ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE manufacturername = 'Nike'
Produce a report showing the Firstname, Lastname, and Category of customers who purchased
Nike sneakers. - ANSWERS -SELECT firstname,lastname
FROM SimplifiedSales
WHERE manufacturername = 'Nike' and category = 'Sneakers'
The maximum number of clauses in an SQL Select statement is: - ANSWERS -6
