SQL Server interview questions part 6
SQL Server interview questions part 6
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Built in Functions in SQL Server is categorized in to how many category ?
Correct Answer is : 4
2. Which of the following operation cannot be performed in bulk ?
Correct Answer is : All of the mentioned
3. Point out the correct statement :
Correct Answer is : Bulk Insert is mainly used to transfer the data from outside world to SQL Server
4. Under the _______ recovery model, all bulk operations are fully logged
Correct Answer is : Full
5. Which of the following is a bulk import operation ?
Correct Answer is : All of the mentioned
6. Point out the wrong statement :
Correct Answer is : In Bulk-logged recovery model, few transactions are completely logged
7. Which of the following utility supports bulk exports and bulk imports data and generates format files ?
Correct Answer is : bcp utility
8. ___________ does not allow bulk export operation in SQL Server.
Correct Answer is : INSERT … SELECT
9. Which of the following performance considerations are regarding bulk operations ?
Correct Answer is : Batch switches
10. ________ parameter specifies the number of rows in a batch in bulk insert script.
Correct Answer is : None of the mentioned
11. Which is default field terminator for bulk insert in SQL Server ?
Correct Answer is : Comma
12. Point out the correct statement :
Correct Answer is : Change data capture requires exclusive use of the cdc schema and cdc user
13. Which of the following disable database for Change Data Capture ?
Correct Answer is : EXEC sys.sp_cdc_disable_db
14. If you do not want to use a gating role, explicitly set the @role_name parameter to :
Correct Answer is :
15. Point out the wrong statement :
Correct Answer is : By default, all of the columns in the source table are not identified as captured columns
16. Which of the following query determine sessions that had an empty scan ?
Correct Answer is : SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count 0
17. Upper bound on expected throughput of the capture job is calculated using the following computation:
Correct Answer is : (maxtrans * maxscans) / number of seconds between scans
18. The cleanup job is initiated by running the parameterless stored procedure :
Correct Answer is : sp_MScdc_cleanup_job
19. Which of the following is a change tracking function ?
Correct Answer is : CHANGE_TRACKING_CURRENT_VERSION
20. Point out the correct statement :
Correct Answer is : Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications
