Skill_1.2_Quiz.docx.pdf

Document Content and Description Below

Question 1 4 out of 4 points Find the name, status and year of service in a table name “Employees” whose status is either full-time or part-time but years of service must be at least 25 Selec... ted Answer: c) SELECT name, status, years of service FROM Employees WHERE status = ‘full time’ OR status = ‘part time’ AND years of service >= 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. The employee table has three fields: EmpID, EmpFname, EmpLname with 120 rows, and EmpSkills that has EmpId, skilled, and SkillDescription with 50 rows. What would be the result of the following SQL statement: Selected Answer: c) The query will return 600 This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 at 13:47:42 GMT -05:00 https://www.coursehero.com/file/70833800/Skill-12-Quizdocx/rows Correct Answer: c) The query will return 600 rows  Question 5 4 out of 4 points Assume the following two tables. The employee table has three fields: EmpID, EmpFname, EmpLname with 120 rows, and EmpSkills that has EmpId, skilled, and SkillDescription with 50 rows. What would be the result of the following SQL statement: Selected Answer: a) The query will return a maximum of 50 rows Correct Answer: a) The query will return a maximum of 50 rows [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages