SQL Server Interview Questions - 33

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

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 3

2. Which is not the preferred way of copying a database?

A. Using the Copy Database Wizard

B. Restoring a database backup

C. Using the Generate Scripts Wizard to publish databases

D. None of the mentioned

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:

A. Pick a source and destination server

B. System stored procedures

C. Schedule when to move or copy the databases

D. None of the mentioned

Correct Answer is : System stored procedures

4. Which of the following returns a list of the database and log files?

A. RESTORE FILELISTON

B. RESTORE FILELIST

C. RESTORE FILELISTONLY

D. All of the mentioned

Correct Answer is : RESTORE FILELISTONLY

5. Which of the following transfer method makes the database unavailable to users during the transfer?

A. Detach and attach method

B. SQL Management Object method

C. Restore method

D. None of the mentioned

Correct Answer is : Detach and attach method

6. Which of the following stored procedure is used for detachment of database?

A. sp_replicationdboption

B. sp_replicationdb

C. sp_replicationoption

D. All of the mentioned

Correct Answer is : sp_replicationdboption

7. User defined function in SQL Server can return :

A. Scalar value

B. Set of values

C. Result set

D. All of the mentioned

Correct Answer is : All of the mentioned

8. Point out the wrong statement :

A. You can create the function once, store it in the database

B. CLR functions offer significant performance advantage over Transact-SQL functions for computational task

C. Function is a database object in Sql Server

D. None of the mentioned

Correct Answer is : None of the mentioned

9. Function cannot be used for __________ statement.

A. Create

B. Drop

C. Select

D. Insert

Correct Answer is : Insert

10. The benefit of using user-defined functions in SQL Server are:

A. They allow modular programming

B. They can increase network traffic

C. They allow slower execution

D. All of the mentioned

Correct Answer is : They allow modular programming

11. Point out the wrong statement :

A. Transact-SQL user-defined functions in queries can only be executed on a multiple thread

B. User-defined scalar functions return a single data value of the type defined in the RETURNS clause

C. User-defined table-valued functions return a table data type

D. All of the mentioned

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 :

A. CREATE FUNCTIONS

B. CREATE FUNCTION

C. CREATE FUNC

D. All of the mentioned

Correct Answer is : CREATE FUNCTION

13. How many types of user defined function is provided by SQL Server?

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 3

14. Which of the following is not a User defined function ?

A. Max()

B. Scalar Function

C. Inline Table-Valued Function

D. Multi-Statement Table-Valued Function

Correct Answer is : Max()

15. Which of the following does not return a table variable?

A. System-defined function

B. Scalar Function

C. Inline Table-Valued Function

D. Multi-Statement Table-Valued Function

Correct Answer is : Scalar Function

16. Which of the following is not a limitation of user defined function ?

A. User-defined functions cannot call a stored procedure, but can call an extended stored procedure

B. User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed

C. SET statements are allowed in a user-defined function

D. The FOR XML clause is not allowed

Correct Answer is : SET statements are allowed in a user-defined function

17. Point out the correct statement :

A. User-defined functions cannot be used to perform actions that modify the database state

B. User-defined functions cannot contain an OUTPUT INTO clause that has a table as its target

C. User-defined functions can not return multiple result sets. Use a stored procedure if you need to return multiple result sets

D. All of the mentioned

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 ?

A. GET CONVERSATION GROUP

B. MOVE CONVERSATION

C. RECEIVE

D. All of the mentioned

Correct Answer is : All of the mentioned

19. Point out the wrong statement :

A. If the function specifies a user-defined type, requires EXECUTE permission on the type

B. If the function specifies a user-defined type, requires READ permission on the type

C. If the function specifies a user-defined type, requires ALTER permission on the type

D. None of the mentioned

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 ?

A. Slow performance

B. Bad optimized queries

C. Faster performance

D. All of the mentioned

Correct Answer is : Faster performance

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?

2. Which is not the preferred way of copying a database?

3. Point out the wrong statement related to the use of Copy database wizard:

4. Which of the following returns a list of the database and log files?

5. Which of the following transfer method makes the database unavailable to users during the transfer?

6. Which of the following stored procedure is used for detachment of database?

7. User defined function in SQL Server can return :

8. Point out the wrong statement :

9. Function cannot be used for __________ statement.

10. The benefit of using user-defined functions in SQL Server are:

11. Point out the wrong statement :

12. Syntax for creation of user defined function is :

13. How many types of user defined function is provided by SQL Server?

14. Which of the following is not a User defined function ?

15. Which of the following does not return a table variable?

16. Which of the following is not a limitation of user defined function ?

17. Point out the correct statement :

18. Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?

19. Point out the wrong statement :

20. Which of the following is most visible benefit of user-defined function ?

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !