To answer this question, you need to understand the purpose of the SELECT statement in SQL*Plus. Let's go through each option to understand why it is correct or incorrect:
Option A) Updating - The SELECT statement is not used for updating data in a table. It is used to retrieve data from a table, so this option is incorrect.
Option B) Viewing - The SELECT statement is used to retrieve and view data from a table. When you issue the SELECT statement "SELECT * FROM orders;", you are retrieving and viewing the data from the "orders" table. Therefore, this option is correct.
Option C) Deleting - The SELECT statement is not used for deleting data from a table. It is used to retrieve data, not delete it. So this option is incorrect.
Option D) Inserting - The SELECT statement is not used for inserting data into a table. It is used to retrieve data, not insert it. So this option is incorrect.
Option E) Truncating - The SELECT statement is not used for truncating a table. Truncating is a separate command in SQL that is used to remove all data from a table. So this option is incorrect.
The correct answers are B) Viewing and D) Inserting. The SELECT statement is used to retrieve and view data from a table, and it can also be used to insert data into another table using the INSERT INTO statement.