Which of the following queries can be executed on a Cassandra database for the given statement? (list)
CREATE TABLE Person (id INT, firstname VARCHAR, lastname VARCHAR,
birthdate DATE, interests LIST<VARCHAR>, primary key (id));
CREATE INDEX person_interests ON Person (interests);

Question

Which of the following queries can be executed on a Cassandra database for the given statement? (list) 
 
 CREATE TABLE Person (id INT, firstname VARCHAR, lastname VARCHAR, 
 birthdate DATE, interests LIST<VARCHAR>, primary key (id)); 
 CREATE INDEX person_interests ON Person (interests);

Answer

SELECT firstname, lastname FROM Person WHERE interests CONTAINS "Soccer";

Answer

SELECT firstname, lastname FROM Person WHERE interests = "Soccer";

Answer

SELECT interests FROM Person WHERE id=10;

Answer

SELECT interests[0] FROM Person WHERE firstname = "Zlatan" ALLOW FILTERING;

Crowdly

Which of the following queries can be executed on a Cassandra database for the g...

Want instant access to all verified answers on learning.devinci.fr?