Consider the below table with primary key as (EMPNO, CONTACTNO) and its content,
Identify which of the following update queries will execute successfully?
(i) cqlsh > UPDATE GEC1.EMP SET CONTACTNO=7653486123 WHERE EMPNO=102985;
(ii) cqlsh > UPDATE GEC1.EMP SET NAME=’JimAntony’ WHERE EMPNO=102983;
(iii) cqlsh > UPDATE GEC1.EMP SET NAME=’TOM’ WHERE EMPNO=102986 and contactno= 7653486165;

Question

Consider the below table with primary key as (EMPNO, CONTACTNO) and its content,

Identify which of the following update queries will execute successfully?

(i) cqlsh > UPDATE GEC1.EMP SET CONTACTNO=7653486123 WHERE EMPNO=102985;

(ii) cqlsh > UPDATE GEC1.EMP SET NAME=’JimAntony’ WHERE EMPNO=102983;

(iii) cqlsh > UPDATE GEC1.EMP SET NAME=’TOM’ WHERE EMPNO=102986 and contactno= 7653486165;

anonymous · Accepted Answer

Correct Solution - c