1. How many ways are provided by SQL Server to copy a database?
2. Which is not the preferred way of copying a database?
Correct Answer is : Using the Generate Scripts Wizard to publish databases
3. Point out the wrong statement related to the use of Copy database wizard:
Correct Answer is : System stored procedures
4. Which of the following returns a list of the database and log files?
Correct Answer is : RESTORE FILELISTONLY
5. Which of the following transfer method makes the database unavailable to users during the transfer?
Correct Answer is : Detach and attach method
6. Which of the following stored procedure is used for detachment of database?
Correct Answer is : sp_replicationdboption
7. User defined function in SQL Server can return :
Correct Answer is : All of the mentioned
8. Point out the wrong statement :
Correct Answer is : None of the mentioned
9. Function cannot be used for __________ statement.
Correct Answer is : Insert
10. The benefit of using user-defined functions in SQL Server are:
Correct Answer is : They allow modular programming
11. Point out the wrong statement :
Correct Answer is : Transact-SQL user-defined functions in queries can only be executed on a multiple thread
12. Syntax for creation of user defined function is :
Correct Answer is : CREATE FUNCTION
13. How many types of user defined function is provided by SQL Server?
14. Which of the following is not a User defined function ?
Correct Answer is : Max()
15. Which of the following does not return a table variable?
Correct Answer is : Scalar Function
16. Which of the following is not a limitation of user defined function ?
Correct Answer is : SET statements are allowed in a user-defined function
17. Point out the correct statement :
Correct Answer is : All of the mentioned
18. Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?
Correct Answer is : All of the mentioned
19. Point out the wrong statement :
Correct Answer is : If the function specifies a user-defined type, requires READ permission on the type
20. Which of the following is most visible benefit of user-defined function ?
Correct Answer is : Faster performance