Gateway for Preparing Interviews
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
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
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
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
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
What is the usage of SQL functions? Functions are the measured values and cannot create permanent environment changes to SQL server. SQL functions are used for the following purpose: To perform calculations on data To modify individual data items To manipulate the output To format dates and numbers To convert data types Which function is … Read more
SQL Interview Questions – Set 06 SQL Interview Questions – Set 05 SQL Interview Questions – Set 04 SQL Interview Questions – Set 03 SQL Interview Questions – Set 02 SQL Interview Questions – Set 01