Kaun Banega Crorepati

Choose the query to find travel location for Indonesia

• SELECT * FROM Destinations

  WHERE Country = 'Indonesia';

• SELECT * FROM Destinations

  WHERE Country = Indonesia;

• SELECT * FROM Destinations

  WHERE Countries = 'Indonesia';

• SELECT * FROM Destinations

  WHERE Country LIKE = 'Indonesia';

what is not the alternative for the like operator?

• =

• ILIKE

• SIMILAR TO

• IN

What does the following SQL query do?

SELECT DISTINCT name FROM Destinations;

• Retrieves all records from the Destinations table

• Returns only unique destination names

• Filters destinations priced above $1000

• Deletes duplicate destinations

What is NOT an alternative for the BETWEEN operator?

• IN

• >= AND <=

• BETWEEN

• CASE WHEN

What does the REGEXP pattern '^A' do in the following SQL query?

• Finds all destinations containing the letter 'A'

• Finds all destinations that start with the letter 'A'

• Finds all destinations that end with 'A'

• Finds destinations where 'A' appears anywhere in the name

What will happen if we run the following query?

UPDATE Destinations SET Price = Price + 500;

• It increases the price of all destinations by $500.

• It updates only one record's price by $500.

• It throws a syntax error.

• It deletes all records.

How do you update multiple columns in SQL?

• UPDATE Destinations SET Price = 2500 AND Country = 'Canada' WHERE Location = 'Paris';

• UPDATE Destinations SET Price = 2500, Country = 'Canada' WHERE Location = 'Paris';

• UPDATE Destinations MODIFY Price = 2500, Country = 'Canada' WHERE Location = 'Paris';

• ALTER Destinations SET Price = 2500, Country = 'Canada' WHERE Location = 'Paris';

What happens if you forget the WHERE clause in an UPDATE statement?

• 1)It updates only one record.

• 2)It updates all records in the table.

• 3)It throws a syntax error.

• 4)It deletes the table.

How do you add a new column ‘Rating’ to the ‘Destinations’ table?

• 1)ADD COLUMN Rating INT TO Destinations;

• 2)MODIFY Destinations ADD COLUMN Rating INT;

• 3)ALTER TABLE Destinations ADD Rating INT;

• 4)CHANGE TABLE Destinations ADD COLUMN Rating INT;

How do you remove duplicate records in a table while keeping one unique row?

• 1)DELETE FROM Destinations WHERE duplicate;

• 2)DELETE FROM Destinations WHERE ID NOT UNIQUE;

• 3)DELETE FROM Destinations WHERE DestinationID NOT IN (SELECT MIN(DestinationID) FROM Destinations GROUP BY Location, Country, Price);

• 4)REMOVE DUPLICATE Destinations;