Question 14 5 Points Save Answer Given Schema Figure 320 Page 108 Textbook Following Sql S Q13602609

Can you help me to understand this question
QUESTION 14 5 points Save Answer Given the schemaQUESTION 14 5 points Save Answer Given the schemaQUESTION 14 5 points Save Answer Given the schemaQUESTION 14 5 points Save Answer Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is not a valid query? delete from works ere employee name “Smith Question Completion Status: O ete from works ere employee name (select employee name from managers where manager name “Smith”; O delete from works where employee name in (select employee name from managers where manager name “Smith”; elete from works here employee name ANY (select employee name from managers where manager name “Smith”) 5 points Save Answer QUESTION 15 Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is not correct? A. insert into employee values (Joe, null. Boston) V insert into employee values (Joe, Boston’, ‘101 Beacon St.) insert into employee (employee name, city, address) values (Joe’, ‘Boston’, ‘101 Beacon St.) O D insert into employee values (Joe, 1101 Beacon St., Boston) Show transcribed image text QUESTION 14 5 points Save Answer Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is not a valid query? delete from works ere employee name “Smith Question Completion Status: O ete from works ere employee name (select employee name from managers where manager name “Smith”; O delete from works where employee name in (select employee name from managers where manager name “Smith”; elete from works here employee name ANY (select employee name from managers where manager name “Smith”) 5 points Save Answer QUESTION 15 Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is not correct? A. insert into employee values (Joe, null. Boston) V insert into employee values (Joe, Boston’, ‘101 Beacon St.) insert into employee (employee name, city, address) values (Joe’, ‘Boston’, ‘101 Beacon St.) O D insert into employee values (Joe, 1101 Beacon St., Boston)

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *