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') ) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Oracle Database does not require the use
Q3: The Oracle tool used to copy data
Q4: The prefix :new is used to make
Q5: Explain the Oracle Database PL/SQL control-of-flow statements.
Q6: Briefly describe how Oracle Database implements serializable
Q8: The default isolation level in Oracle Database
Q9: With Oracle Database,data must be entered at
Q10: Based on the table below,a function to
Q11: Which of the following is true of
Q12: Oracle Database uses the SQL ALTER TABLE