Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 13 5 pointsSaved Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is not correct? A.
QUESTION 13 5 pointsSaved 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) O B. insert into employee (employee_name, city) values (Joe', Boston) O C. insert into employee values ('Joe'. '101 Beacon SL. 'Boston') O D. insert into employee values (Joe, Boston) QUESTION 14 5 pointsSaved Given the schema of Figure 3.20 on Page 108 of textbook, which of the following query gives 10% raise to employees at SBC company. O A update works set new.salary = old.salary1.1 where company_name "SBc O B.update works set salary salary 1.1 C. update works set salary salary 1.1 where company-name = "SBC" D-update works set salary salary 1.1 where employee,.employee_name works,employee_name and company_name "SBC
Step 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