To drop a primary key column from a table the primary key ...

[CBme]

To drop a primary key column from a table the primary key constraint must first be dropped, but this does not require that related foreign keys based on the column be dropped.
 
  Indicate whether the statement is true or false

Question 2

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.

[krakiolit]

Answer to Question 1

FALSE

Answer to Question 2

D

[CBme]

TYSM

[raili21]

Excellent