Which task can be performed by using a single Data Mani…

Which task can be performed by using a single Data Manipulation Language (DML) statement?

Which task can be performed by using a single Data Manipulation Language (DML) statement?

A.
adding a column constraint when inserting a row into a table

B.
adding a column with a default value when inserting a row into a table

C.
removing all data only from one single column on which a unique constraint is defined

D.
removing all data only from one single column on which a primary key constraint is defined



Leave a Reply 2

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


evilsoldier

evilsoldier

C. DELETE tablename;

evilsoldier

evilsoldier

Actually the correct query shoud be
UPDATE tablename SET columname = NULL;
UNIQUE Constraint allows NULL to be added.