Multiple Choice
Contents of the PUBLISHER table
-Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?
A) INSERT INTO publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222') ;
B) INSERT INTO publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP') ;
C) UPDATE publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222') ;
D) UPDATE publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP') ;
Correct Answer:

Verified
Correct Answer:
Verified
Q104: When Oracle 12c encounters a substitution variable,the
Q105: The <u>UPDATE </u>command can be used to
Q106: Which of the following commands is used
Q107: A(n)_ lock will allow other users to
Q108: A(n)_ in a SQL command instructs Oracle
Q110: The data being inserted into a table
Q111: If a table already exists,what command would
Q112: When a subquery is used in the
Q113: When data is being entered into a
Q114: If the WHERE clause of the DELETE