⟩ What are scalar functions?
Scalar functions : these functions perform calculation on an input value and return a single value. Example: ROUND(), MID(), LCASE(), UCASE()
Scalar functions : these functions perform calculation on an input value and return a single value. Example: ROUND(), MID(), LCASE(), UCASE()
What are constraints? Explain different types of constraints?
What is a self join? Explain it with an example.?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What type of Index will get created after executing the above statement?
What is a transaction and what are ACID properties?
What is normalization? Explain different levels of normalization?
What is the system function to get the current user's user id?
Can we have a nested transaction?
What is the difference in Login Security Modes between v6.5 and 7.0?