1. UDFs in SQL Server is composed of _______ parts.
2. When to choose scalar function over inline table valued function ?
Correct Answer is : You want a single value as the result
3. Which of the user defined function will be preferred for adding two numbers ?
Correct Answer is : Scalar
4. The ability to create a user-defined function (UDF) is a new feature added to :
Correct Answer is : SQL Server 2000
5. Variables was added newly to SQL Server version :
6. Which of the following keyword is not associated with initialization of variable ?
Correct Answer is : All of the mentioned
7. Which of the following is a global variable ?
Correct Answer is : @@CPU_BUSY
8. Point out the right statement :
Correct Answer is : T-SQL restricts the use of variables in ways that aren’t common in other development environments
9. Which of the following global has return type ‘numeric’ ?
Correct Answer is : @@IDENTITY
10.
DECLARE @techonthenet VARCHAR(50);
Value of the @techonthenet variable can be changed using the SET statement, as follows:
Correct Answer is : SET @techonthenet = ‘Example showing how to declare variable’;
11. _________ gives amount of time, in ticks, that SQL Server has been idle since it was last started.
Correct Answer is : @@IDLE
12. @@LANGUAGE variable whose return type nvarchar is specified in :
Correct Answer is : syslanguages.name
13. What is a view?
Correct Answer is : A view is a virtual table which results of executing a pre-compiled query
14. Which of the following is not a limitation of view?
Correct Answer is : Index Created on View Used Often
15. Which of the following following statement is true?
Correct Answer is : All of the Mentioned
16. SQL Server has mainly how many types of views?
17. Dynamic Management View is a type of
Correct Answer is : System Defined Views
18. Syntax for creating views is
Correct Answer is : CREATE VIEW AS SELECT
19. You can delete a view with ___________ command.
Correct Answer is : DROP VIEW
20. What is SCHEMABINDING a VIEW?
Correct Answer is : These are stored only in the Master database