Question 44: You have been given below table definition

CREATE TABLE HADOOEXAM(

COURSE_TITLE text,

COURSE_ADDED_YEAR int,

COURSE_ADDED_DATE timestamp,

COURSE_DETAIL text,

USER_ID UUID,

COURSE_ID TIMEUUID,

PRIMARY KEY ((COURSE_TITLE,COURSE_ADDED_YEAR)));

What would be the result, when you run the below query?

SELECT * FROM HADOOEXAM WHERE COURSE_TITLE='CASSANDRA' ;

1. It will return all the courses which matches with the COURSE_TITLE='CASSANDRA'
2. Get all Questions and Answer from here
3. You need to have paid subscription to access all questions
4. Thanks for considering Python Certification Material

Correct Answer: 4

Explanation: Yes, it will be invalid query. Because we have composite key.

You can access to full explanation to question and answer from this page.