Consider the below table with primary key as (EMPNO, CONTACTNO) and its content,
Identify which of the following delete statements are executed successfully?
(i) cqlsh > DELETE FROM GEC1.EMP WHERE EMPNO=102985;
(ii) cqlsh > DELETE NAME, CONTACTNO FROM GEC1.EMP WHERE EMPNO=102986;
(iii) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102984;
(iv) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102983 and CONTACTNO=8467234836;

Question

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

Identify which of the following delete statements are executed successfully?

(i) cqlsh > DELETE FROM GEC1.EMP WHERE EMPNO=102985;

(ii) cqlsh > DELETE NAME, CONTACTNO FROM GEC1.EMP WHERE EMPNO=102986;

(iii) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102984;

(iv) cqlsh > DELETE NAME FROM GEC1.EMP WHERE EMPNO=102983 and CONTACTNO=8467234836;

anonymous · Accepted Answer

Correct Solution - d