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) Any of the above will work correctly.
D
You might also like to view...
Which of the following should be considered when a company decides to declare a cash dividend on common stock?
a. The retained earnings balance only b. The amount of authorized shares of common stock c. The book value of the company's stock d. The cash available and the retained earnings balance
The primary objective of a store design is in implementing the retailer's strategy.
Answer the following statement true (T) or false (F)
Which of the following are among the five actions that Professor Melvin Sharpe indicates can "harmonize" relations between individuals and organizations?
A) measured remarks that foster credibility B) environmental research and evaluation to determine actions or adjustments needed C) continuous one-way communication D) credible actions that favor the organization
Humor should not be used when introducing a presentation because it can be offensive to members of the audience
Indicate whether the statement is true or false