Vandana Tour & Travels Senior IT Recruiter Interview Questions and Answers

Procedures are used to perform an action, while functions return a value.

• Procedures do not return a value, while functions do

• Functions can be used in expressions, while procedures cannot

• Procedures can modify input parameters, while functions cannot

• Functions have a return type, while procedures do not

• Examples of functions include Math.max() and String.length(), while examples of procedures include console.log() and aler

Indexes are used to improve database performance. Types of indexes include clustered, non-clustered, unique, and full-text.

• Clustered indexes determine the physical order of data in a table

• Non-clustered indexes create a separate structure to store the index data

• Unique indexes ensure that no two rows have the same values in the indexed columns

• Full-text indexes enable text-based searches on large amounts of text data

Yes, we can write a procedure inside a standalone procedure.

• A standalone procedure is a self-contained unit of code that can be executed independently.

• We can write another procedure inside a standalone procedure to perform a specific task.

• This is known as a nested procedure or a sub-procedure.

• The nested procedure can access the variables and parameters of the outer procedure.

• Example: CREATE PROCEDURE outer_proc AS BEGI...read more