# Data Manipulation, Queries, Collections, & Indexing

### Question 1: Which CQL statement would you use that will return the number of rows that matches your query?

>COUNT(1)
>COUNT(*)

### Question 2: Which Cassandra collection type can be used to relate one item to another in a key value pair?

>A Map Collection

### Question 3: Which CQL statement is used to retrieve data from Cassandra Table?

>SELECT

### Question 4: Which clause is preferred for clustering columns?

>IN

### Question 5: Which command would you use to ensure that an index currently doesn't exist?

>DROP INDEX

### Question 6: Which command would you use to remove a value or a row from your Cassandra Table?

>DELETE

### Question 7: Which command would you use to add additional information to a record in your Cassandra Table?

>UPDATE

### Question 8: Which Cassandra collection is used to store a grouping of elements that do not have to be unique and can store the elements in a specific order?

>A List Collection

### Question 9: Which clause would you use to have your result set sorted by start date in descending order?

>ORDER BY

### Question 10: Which Cassandra collection type is used to store a grouping of elements?

>A Set Collection

### Question 11: Which Cassandra function does not work with text or date fields?

>avg
>sum

### Question 12: Which CQL statement groups modification statements such as inserts, updates, or deletes into a single statement?

>BATCH

### Question 13: What are the SASI index modes in Cassandra?

>SPARSE
>CONTAINS
>PREFIX

### Question 14: Which command is used to insert records in your Cassandra Table?

>INSERT INTO