SQL Server Interview Questions - 33 | Snaprecruit.com

SQL Server Interview Questions - 33 | Snaprecruit.com

SQL Server interview questions part 33

SQL Server interview questions part 33

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. How many ways are provided by SQL Server to copy a database?

Correct Answer is : 3

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?

Correct Answer is : 3

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

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon