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

Verified
Correct Answer:
Verified
Q12: Oracle Database uses the SQL ALTER TABLE
Q35: Instead of creating a new database instance
Q51: What is the Database Configuration Assistant (DBCA)?
Q62: Which of the following can Oracle Database
Q68: Which of the following tasks can be
Q69: The Oracle Database PL/SQL statement used to
Q71: In Oracle Database,which of the following prefixes
Q72: The Oracle Enterprise Manager 11g Database Control
Q81: Oracle Database provides only one method for
Q97: The type of failure that occurs when