From SQLPlus, you issue this SELECT statement: SELECT From orders; You use this statement to retrieve data from a data table for __________. (Choose all that apply)

The correct answer is B. Viewing D. Inserting. You can use SELECT statement to display and to insert data into different table. Incorrect Answers A: You cannot update data with SELECT statement. Update command is used for this purpose. C: You cannot delete data with SELECT statement. Delete command is used for this purpose…

Basic SQL SELECT Statements

Question

From SQL*Plus, you issue this SELECT statement:

SELECT * From orders; You use this statement to retrieve data from a data table for __________. (Choose all that apply)

Options

AUpdating
BViewing
CDeleting
DInserting
ETruncating

How the community answered

(31 responses)

A
6% (2)
B
77% (24)
C
13% (4)
E
3% (1)

Explanation

You can use SELECT statement to display and to insert data into different table. Incorrect Answers A: You cannot update data with SELECT statement. Update command is used for this purpose. C: You cannot delete data with SELECT statement. Delete command is used for this purpose. E: You cannot truncate data with SELECT statement. Truncate command is used for this

Topics

#SELECT statement#DML purpose#data retrieval#SQL*Plus

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice