ORACLE DATABASE INTERVIEW QUESTIONS

What are the basic comparison operators in SQL?

How do you use the equal to (=) operator in Oracle SQL?

How do you use the not equal to (<> or !=) operator in Oracle SQL?

How do you use the greater than (>) and less than (<) operators in Oracle SQL?

How do you use the greater than or equal to (>=) and less than or equal to (<=) operators in Oracle SQL?

Can you use comparison operators with character data in Oracle SQL? Provide an example?

How do you use the BETWEEN operator in Oracle SQL to compare a value within a range?

How do you use the IN operator in Oracle SQL for comparison?

Comparisons with NULL values result in unknown. To check for NULL values, you should use the IS NULL or IS NOT NULL operators. For example: SELECT * FROM employees WHERE commission_pct IS NULL; SELECT * FROM employees WHERE commission_pct IS NOT NULL; • These queries retrieve employees with a NULL and non-NULL commission percentage, respectively.