Information Technology > QUESTIONS & ANSWERS > Find the name status and years of service in a table (All)

Find the name status and years of service in a table

Document Content and Description Below

Find the name status and years of service in a table 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: Selected Answer: c) The query will return 600 [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: