SQL Interview Questions – Set 06

What is the usage of NVL() function? The NVL() function is used to convert NULL value to the other value. NVL() function is used in Oracle it is not in SQL and MySQL server. Instead of NVL() function MySQL have IFNULL() and SQL Server have ISNULL() function. What are the set operators in SQL? SQL … Read more

SQL Interview Questions – Set 05

What is self-join and what is the requirement of self-join? A self-join is often very useful to convert a hierarchical structure to a flat structure. It is used to join a table to itself as like if that is the second table. What is ACID property in a database? ACID property is used to ensure … Read more

SQL Interview Questions – Set 04

What is a “TRIGGER” in SQL? A trigger allows you to execute a batch of SQL code when an insert, update or delete command is run against a specific table as TRIGGER is said to be the set of actions that are performed whenever commands like insert, update or delete are given through queries. The … Read more

SQL Interview Questions – Set 03

What is Full Join in SQL? Full join return rows when there are matching rows in any one of the tables. This means it returns all the rows from the left-hand side table and all the rows from the right-hand side table. What is the usage of the DISTINCT keyword? The DISTINCT keyword is used … Read more

SQL Interview Questions – Set 02

What do you understand by case manipulation functions? Case manipulation functions are the functions which convert the data from the state in which it is already stored in the table to upper, lower or mixed case. Case manipulation function can be used in almost every part of the SQL statement. Case manipulation functions are mostly … Read more