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

Question

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

Answer

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

Answer

SELECT interests FROM Person WHERE id=10;

Answer

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

Answer

SELECT firstname, lastname FROM Person WHERE birthdate = "03/10/1981";

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?