Which statement is true?

You issue the following command to alter the country column in the departments table:

Which statement is true?

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.



Leave a Reply 9

Your email address will not be published. Required fields are marked *


Deepak

Deepak

C.

Option C is correct answer. Only new records inserted after the execution of alter will work fine.

venus

venus

C is correct answer. Verified on oracle database version 11.x.

Christian Schrewe

Christian Schrewe

p.s.

Free PassLeader 1Z0-061 dumps from Google Drive:

https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA

Good Luck!

Rosetta

Rosetta

thanks for the dumps link. doing my certification this month.:-)

SUKUMARAN

SUKUMARAN

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?

9jansen

9jansen

C

Too late already to effect the change on the existing country column with null value.

Suyog

Suyog

C is Correct.

josep_ora

josep_ora

C is correct