If T3 Is a Table with Three Columns C1,C2 and C3,where

question 23

Multiple Choice

If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?

• A) SET INTO T3 VALUES (101, 'Smith', '02/10/14');
• B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
• C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014');
• D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
• E) INSERT INTO T3 VALUES ('Smith', TO_DATE ('02/10/14', 'DD/MM/YY'), 101);

---

Definitions:

Operating Costs

The day-to-day expenses involved with running a business, excluding costs associated with production.

Assets

Resources owned or controlled by an entity with expected future economic benefits.

Sales

The total revenue earned from the sale of goods or services related to a company's primary operations.

Common Stock

Common stock is a type of security that represents ownership in a corporation, granting holders voting rights and a share in the company's profits through dividends.