QUESTION 13 5 pointsSaved Given the schema of Figure 3.20 on Page 108 of textboo

Question

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.salary·1.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"

Explanation / Answer

Hi,

Ans 13- D) insert into employee values('Joe','Boston');

Explanation- As per the structure of the table, we have three columns defined for the table. But we are inserting values for two columns alone and which is causing problem with the syntax. We need to use the appropriate syntax for insering specific number of columns in the table.

Ans 14- C) update works
set salary=salary*1.1
where company_name="SBC";

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.