You issue the following command to alter the country column in the departments table:
Which statement is true?
A.
It produces an error because column definitions cannot be altered to add default values.
B.
It executes successfully and all the rows that have a null value for the country column will
be updated with the value ‘USA’.
C.
It executes successfully. The modification to add the default value takes effect only from
subsequent insertions to the table.
D.
It produces an error because the data type for the column is not specified.
C.
Option C is correct answer. Only new records inserted after the execution of alter will work fine.
C is correct answer. Verified on oracle database version 11.x.
Passed 1Z0-061 exam recently!
Total 75 questions, few new questions, learned them from PassLeader 1Z0-061 dumps (http://www.passleader.com/1z0-061.html), which is 100% pass ensure now!
p.s.
Free PassLeader 1Z0-061 dumps from Google Drive:
https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA
Good Luck!
thanks for the dumps link. doing my certification this month.:-)
Hi Rosetta,
How was your exam?
I am giving exam in this month.
Need some inputs from you.
How much did come from these site dumps?
Is this dumps are valid one?
C
Too late already to effect the change on the existing country column with null value.
C is Correct.
C is correct