MIS 2113 Exam 1 Questions and Answers

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