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;

All (i), (ii), (iii) and (iv)

Only (i), (iii), (iv)

Only (i), (ii), (iii)

Only (i) and (iv)

Verified Answer
Correct Option - d

To get all Infosys Certified Cassandra Administrator Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in