The figure below shows a record in the books table. Which (if any) of the follow

Question

The figure below shows a record in the bookstable. Which (if any) of the following query or queries successfully insert(s) this record ? /*Query A*/ INSERT INTO books values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query B*/ INSERT INTO books values (672325676, VBA for Excel, KZ, 20.07, 10.17) /*Query C*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query D*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, VBA for Excel, KZ, 20.07, 10.17) /*Query A*/ INSERT INTO books values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query A*/ /*Query B*/ INSERT INTO books values (672325676, VBA for Excel, KZ, 20.07, 10.17) /*Query B*/ /*Query C*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query C*/ /*Query D*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, VBA for Excel, KZ, 20.07, 10.17) /*Query D*/ Only query A Only query B Only query C Only query D Both query A and query B Both query A and query C Both query A and query D Both query B and query D Both query C and query D queries A, B, C and D
Only query A
Only query B
Only query C
Only query D
Both query A and query B
Both query A and query C
Both query A and query D
Both query B and query D
Both query C and query D
queries A, B, C and D

Explanation / Answer

Solution:

Both query A and C

Explaination:

Since they have used direct and indirect addressing of the same query

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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