Answered step by step
Verified Expert Solution
Question
1 Approved Answer
33.) Please show and explain how you came to the solution Progress Sample Queries CREATE TABLE emp_proj (empno INT, projno INT, days INT, location CHAR
33.) Please show and explain how you came to the solution
Progress Sample Queries CREATE TABLE emp_proj (empno INT, projno INT, days INT, location CHAR (20)) CREATE VIEW vl AS SELECT DISTINCT proj no, location FROM emp-proj CREATE VIEW v2 AS SELECT empno, projno, days FROM emp_proj CREATE VIEW v3 AS SELECT projno, SUM(days) AS mandays FROM v2 GROUP BY projno CREATE VIEW v4 AS SELECT vl.location, SUM (v2.days) AS mandays FROM vl, v2 WHERE v1.proj no v2.proj no GROUP BY v1.location Question Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 What is the result of running the query DROP VIEW v2 in the sample queries above? v1, v2, v3, v4 do not exist v2, v3, v4 do not exist v2, v3, v4 are inoperable v2 does not exist; v3, v4 are inoperable v2, v3 do not exist; v4 is not inoperable Record AnswerSQL (ANSI), Question 33 of 40 Copyright 2010 Brainbench All Rights ReservedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started