POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the LIKE operator in PostgreSQL?

How do you use the LIKE operator to find all entries that start with a specific letter in PostgreSQL?

What wildcards are used with the LIKE operator in PostgreSQL and what do they represent?

Can you use the LIKE operator with numbers in PostgreSQL?

How would you find all entries that contain a specific substring in PostgreSQL using the LIKE operator?

What is the difference between LIKE and ILIKE in PostgreSQL?

How can you optimize LIKE queries in PostgreSQL for performance?

What are some limitations of using the LIKE operator in PostgreSQL?

How would you handle pattern matching with special characters in PostgreSQL using LIKE?

Explain the use of the LIKE operator in a real-world scenario where both PostgreSQL and ORACLE databases are used.