Multiple Choice
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
Correct Answer:
Verified
Q4: The SQL operation used to calculate certain
Q5: A table is known more formally as
Q6: It is also possible to combine conditions
Q7: DTD stands for:<br>A) Direct Type Definition<br>B) Document
Q8: The use of a DTD in XML
Q10: It is not possible to create a
Q11: The first step in logical modelling is
Q12: _enforces consistency between linked tables.<br>A) Referential locking<br>B)
Q13: The _ keyword designates which fields to
Q14: The _ keyword designates which tables to