Skill_1.2_Quiz.docx.pdf

Document Content and Description Below

Question 1 4 out of 4 points Find the name, status and yearsofservice in a table name “Employees” whose status is either full time or part time but yearsofservice must be at least 25 Selected... Answer: c) SELECT name, status, yearsofservice FROM Employees WHERE status = ‘full time’ OR status = ‘part time’ AND yearsofservice >= 25 Correct Answer: c) SELECT name, status, yearsofservice FROM Employees WHERE status = ‘full time’ OR status = ‘part time’ AND yearsofservice >= 25  Question 2 4 out of 4 points The following query Selected Answer: d) Self Join Correct Answer: d) Self Join  Question 3 4 out of 4 points The following query Selected Answer: b) Customers with a primary contact and with or without alternate contacts Correct Answer: b) Customers with a primary contact and with or without alternate contacts  Question 4 4 out of 4 points Assume the following two tables. Employee table has three fields: EmpID, EmpFname, EmpLname with 120 rows and EmpSkills that has EmpId, SkillID, and SkillDescription with 50 rows. What would be the result of the following SQL statement: [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages