SQL Interview Questions

Character-manipulation functions are used to change, extract, alter the character string. One or more than one characters and words should be passed into the function, and then the function will perform its operation on those words. In SQL, character-manipulation functions are functions that allow you to perform operations on character or string data. These functions … Read more

There are three case manipulation functions in SQL: LOWER: converts character into Lowercase. UPPER: converts character into uppercase. INITCAP: converts character values to uppercase for the initials of each word. In SQL, there are several case manipulation functions that you can use to change the case of strings. The specific functions available can vary slightly … Read more

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 used when you need to search for data, … Read more

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 The usage of SQL functions in a database is to … Read more

A NULL value is not the same as zero or a blank space. A NULL value is a value which is ‘unavailable, unassigned, unknown or not applicable.’ On the other hand, zero is a number, and a blank space is treated as a character. The NULL value can be treated as unknown and missing value … Read more