To insert a new record for a book with an item code of KOB, a retail price of $12.95, and an item cost of $7.95 into the Product table of a database, the SQL statement is:
A) INSERT INTO Product Values('KOB', 'Book', 12.95, 7.95)
B) INSERT INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
C) ADD INTO Product Values('KOB', 'Book', 12.95, 7.95)
D) ADD INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
E) None of the above
Correct Answer:
Verified
Q9: To designate a character or text constant
Q10: Which of the following SQL statements is
Q11: Which comparison operators below is not used
Q12: It is also possible to combine conditions
Q13: The _ operator uses the wildcard character
Q15: Which of the following SQL statements will
Q16: Which of the following SQL statements will
Q17: In order to use an aggregate function,
Q18: The SQL operation used to calculate certain
Q19: Which of the following is not an
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents