Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Point out the wrong statement related to SQL Server 2014 :
Correct Answer is : SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments
2. Which of the following is a feature of SQL Server 2012 R2 Enterprise ?
Correct Answer is : All of the mentioned
3. Which of the following operating system is supported by SQL Server 2014?
Correct Answer is : All of the mentioned
4. Which of the following component is not installed by SQL Server setup 2012 required by the product ?
Correct Answer is : Named Pipes
5. Which is minimum processor speed for SQL Server 2012 ?
Correct Answer is : 1.4 GHz
6. The supported storage types for data files are :
Correct Answer is : SMB File Share
7. Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid ?
Correct Answer is : An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_
8. Point out the correct statement :
Correct Answer is : The function cdc.fn_cdc_get_all_changes_ returns all changes that occurred for the specified interval
9. The commit time of each transaction with an associated entry in a database change table is available in the table __________
Correct Answer is : cdc.lsn_time_mapping
10. Point out the wrong statement :
Correct Answer is : cdc.lsn_time_mapping applies to SQL Server 2014
11. Which of the following query returns the average latency for the most recent sessions ?
Correct Answer is : SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
12. __________ gives DBAs an option to shut down the server in case of an audit log failure.
Correct Answer is : Shut down server on audit log failure
13. Which of the following field in cdc.lsn_time_mapping has varbinary data type ?
Correct Answer is : tran_id
14. Which of the following query returns the average throughput for the most recent sessions ?
Correct Answer is : SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
15. sys.fn_cdc_map_time_to_lsn returns ________ value from the start_lsn column in the cdc.lsn_time_mapping system table for the specified time.
Correct Answer is : LSN
16. SQL injection is an attack in which _________ code is inserted into strings that are later passed to an instance of SQL Server.
Correct Answer is : malicious
17. Point out the correct statement :
Correct Answer is : Procedure that constructs SQL statements should be reviewed for injection vulnerabilities
18. Any user-controlled parameter that gets processed by the application includes vulnerabilities like :
Correct Answer is : All of the mentioned
19. Point out the wrong statement :
Correct Answer is : The use of PL-SQL opens the door to these vulnerabilities
20. Which of the stored procedure is used to test SQL injection attack ?
Correct Answer is : xp_regwrite
