Skill Quiz

Document Content and Description Below

Question 1 4 out of 4 points Find the name, status and year of service in the table name “Employees” whose status is either full time or part time but years of service must be at least 25 Sel... ected 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 Correct Answer: c) The query will return 600 rows  Question 5 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: a) The query will return a maximum of 50 rows Correct Answer: a) The query will return a maximum of 50 rows  Question 6 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: b) The query will return all rows from Employee, matching rows from EmpSkills, and nulls for EmpSkills columns where there is no match Correct Answer: b) The query will return all rows from Employee, matching rows from EmpSkills, and nulls for EmpSkills columns where there is no match  Question 7 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 all rows from EmpSkills, matching rows from Employee, and nulls for Employee columns where there is no match Correct Answer:  Question 8 4 out of 4 points We have two tables (T1 and T2) that are joining on columns city and region. How do we ensure that we will get back rows where the city column has values in both tables but the corresponding region column in both tables contain NULL Selected Answer: d) Use ISNULL in the Where clause on both T1.region and T2.region Correct Answer: d) Use ISNULL in the Where clause on both T1.region and T2.region  Question 9 4 out of 4 points The following query Selected Answer: c) Customers with a primary contact and without alternate contacts Correct Answer: c) Customers with a primary contact and without alternate contacts  Question 10 4 out of 4 points What is the result of the following query Selected Answer: d) Anything that starts with an X and does not contain an S Correct Answer: d) Anything that starts with an X and does not contain an S [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages