SQL Server Interview Questions - 33 | Snaprecruit.com
SQL Server Interview Questions - 33 | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
SQL Server interview questions part 33
SQL Server interview questions part 33
Back
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?
A. 2
B. 3
C. 4
D. 5
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
None of the mentioned
9. Function cannot be used for __________ statement.
A. Create
B. Drop
C. Select
D. Insert
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
Faster performance
Similar Interview Questions
Search for latest jobs
Find Jobs