I need a great tutor to take data &info mgt exam for me
Chrisshlucmmy
exam_2_review.pptx-_data_info_mgt.pptxExam 2 Review
Contents
Overview of Exam 2
Focus of Exam 2 (What will be in Exam 2)
Sample Questions
Exam 2 Overview
Exam 2 consists of 20 multiple choice questions.
Once you start the exam, the exam will last for 3 hours. You can’t pause or resume the exam once it is started.
The time is sufficient. Please answer the questions very carefully.
Questions are developed from class notes, lectures, and textbook of Chapter 8 to 12.
Chapter 15 to 17 will NOT be in the exam. So, you don’t need to prepare for CREATE DATABASE, CREATE TABEL, INSERT INTO, UPDATE, and DELETE statements.
Good luck everyone!
Focus of Exam 2
The focus of Exam 2 will be the following:
(1) How to retrieve data from two tables by using INNER JOIN, OUTER JOIN, and UNION; (Chapter 8 to 11)
(2) How to use the count(*), sum(), max(), and min() function (Chapter 12)
Sample Questions
The following questions intend to give you a preview of Exam 2. All answers are listed at the end of this Powerpoint.
A good way of using these examples is that you don’t look at the answers right away, and try to answer all questions on you own first.
1. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below:
If we have the following statement:
select Products.ProdName, Orders.Quantity from Products inner join Orders on Products.ProdID=Orders.ProdID;
What types of phones should be listed in the final result after executing the statement above:
Windows only
iPhone and Windows
iPhone and Android
Android and Windows
2. When the corresponding columns in a UNION have different names, what is the name of the column in the final result set?
A. The name of the column in the first SELECT statement.
B. The name of the column in the second SELECT statement.
C. The database system determines the name of the column.
D. The name will be a combination of the first table and the second table.
3. What type of JOIN returns all rows from the second table and any matching rows from the first table?
A. FULL OUTER JOIN
B. LEFT OUTER JOIN
C. RIGHT OUTER JOIN
D. INNER JOIN
4. What type of join returns all rows from the first table and any matching rows from the second table?
A. FULL OUTER JOIN
B. LEFT OUTER JOIN
C. RIGHT OUTER JOIN
D. INNER JOIN
This page is intentionally left blank.
Answers
1. C (INNER JOIN return matching values of two tables. Only iPhone and Android phone id numbers show up in both tables. Thus, iPhone and Android will be in the final result.)
2. C
3. C (The explanation of OUTER JOIN can be found in the developer guide in Week 11 on eCollege.)
4. B
