Content of the PUBLISHER tableContents of the PUBLISHER table+Oracle SQL*PlusFile Edit Search Options HelpPUBID NAME1 PRINTING IS US2 PUBLISH OUR WAY3 AMERICAN PUBLISHING4 READING MATERIALS INC.5 REED-N-RITECONTACTTOMMIE SEYMOURJANE TOMLINDAUID DAVIDSONRENEE SMITHWhich of the following commands will delete all row from the PUBLISHER table?PHONE000-714-8321"010-410-0010800-555-1211800-555-9743SEBASTIAN JONES 800-555-8284a) DELETE FROM publisher WHERE pubid = 1, 2, 3, 4, 5;b) REMOVE ALL FROM publisher;c) DELETE FROM publisher;e) None of the aboved) DROP FROM publisher WHERE pubid = 4;

The correct command to delete all rows from the PUBLISHER table is:

Content of the PUBLISHER table Contents of the PUBLISHER table Oracle SQL*Plus File Edit Search Options Help PUBID NAME 1 PRINTING IS US 2 PUBLISH OUR WAY 3 AMERICAN PUBLISHING 4 READING MATERIALS INC. 5 REED-N-RITE CONTACT TOMMIE SEYMOUR JANE TOMLIN DAUID DAVIDSON RENEE SMITH PHONE 000-714-8321 010-410-0010 800-555-1211 800-555-9743 SEBASTIAN JONES 800-555-8284 Which of the following commands will delete all row from the PUBLISHER table?

Content of the PUBLISHER table Contents of the PUBLISHER table Oracle SQL*Plus File Edit Search Options Help PUBID NAME 1 PRINTING IS US 2 PUBLISH OUR WAY 3 AMERICAN PUBLISHING 4 READING MATERIALS INC. 5 REED-N-RITE CONTACT TOMMIE SEYMOUR JANE TOMLIN DAUID DAVIDSON RENEE SMITH PHONE 000-714-8321 010-410-0010 800-555-1211 800-555-9743 SEBASTIAN JONES 800-555-8284 Which of the following commands will delete all row from the PUBLISHER table?

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 5MC

See similar textbooks