20 - SQL Query - Salary greater than or equal to and less than or equal to 04:44 21 - SQL Query to find count of cities in each district in descending order 06:24 22 - Difference between round() and truncate() functions of MySQL 04:06 23 - Is SQL Case Sensitive 01:47 Penet...
SQL Interview Questions and answers on Stored Procedures and Triggers What is a stored procedure? Stored Procedure is a function which contain collection of SQL Queries. Procedure can take inputs , process them and send back output. SQL INTERVIEW QUESTIONS AND ANSWERS 14 | P a g e 51.What ...
These three questions are good examples of what you can expect from the job interview. As you’ve seen, the SQL aggregate functions don’t come alone. They are usually assessed simultaneously with other SQL concepts, such as grouping and filtering data, joining tables, and writing subqueries. ...
4:: What is a Character Functions? Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM...
Generally, SQL is used for DDL and DML statements, whereas PL/SQL is used to write program blocks, functions, procedures, triggers and packages. 5. Difference between Relational and Non-relational Databases A relational database is organized in tables. Usually, the data within these tables have...
Functions must have a name but the function name can never start with a special character such as @, $, #, and so on.Types of function• Pre-Defined Function• User-Defined FunctionUser-defined Function:In a user-defined function we write our logic according to our needs. The main ...
4.Explain 1 feature which you are using in project? (Mostly asked in Interview Questions For SQL) Answer: We have used listagg function and nth val function in our project which has following explaination: Analytical Functions-NTH,LISTAGG: ...
USER_ID().Also check out other system functions like USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), HOST_NAME(). 22. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand? Triggers are special kind of stored ...
Functions and stored procedures are both reusable code objects in SQL Server. Functions are designed to return a single value or a table and can be used in SQL statements likeSELECTorJOIN. Stored procedures can perform a wider range of operations, including modifying database objects, executing ...
In solving this data analyst interview question, you’ll need to be fluent in using the following concepts: merge() lambda functions isna() unique() groupby() data aggregation Working with DataFrames Solution & Output Here’s how to solve this problem in Python. ...