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

question 95

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/03 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/03');
• B)SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
• C)INSERT INTO T3 VALUES (101,'Smith','02/10/2003');
• D)INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
• E)Any of the above will work correctly.

---

Definitions:

LivingSocial

An online marketplace that allows users to buy and share things to do in their city, offering discounted gift certificates usable at local or national companies.

Website

A set of related web pages located under a single domain name, typically produced by a single individual or organization.

Customer Ratings

Evaluative feedback given by customers regarding their satisfaction or dissatisfaction with a product or service.

Reviews Website

An online platform where users can post reviews and opinions about products, services, or companies, often used by consumers for research before making purchasing decisions.