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:

Date of Record

A specific date set by a corporation on which the shareholders of record are identified as entitled to receive dividends or other distributions.

Stockholders' Equity

The ownership interest of shareholders in the assets of a corporation, calculated as total assets minus liabilities.

Paid-In Capital

Paid-in capital is the amount of money that shareholders have directly invested in a company by purchasing shares during the initial offering or through secondary market transactions.

Par Value

The nominal or face value of a bond, share, or other financial instrument, as stated on the certificate or instrument.