Question 55: You have following table definition

CREATE TABLE TRINING_COURSE (

  id uuid,

  course_sequence int,

  course_id uuid,

  title text,

  category text,

  trainer text,

  PRIMARY KEY  (id, course_sequence ) );

CREATE INDEX MYINDEXVALUE ON TRINING_COURSE (LOCATION);

Now, you need to select all rows having TRAINING_COURSE ORGANIZED IN Mumbai which of the following are correct syntax?

1. SELECT * FROM TRINING_COURSE WHERE LOCATION CONTAINS 'MUMBAI';
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: 1

Explanation: filter the data using a value in the LOCATION map using the CONTAINS condition in the WHERE clause.

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