Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Reserved

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245

Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel

1st Edition

3030548317, 978-3030548315

More Books

Students also viewed these Databases questions