Microsoft SQL Server DBA Online Test - 2012

Topics covered

• Create Cluster: iMocha’s SQL server online test helps recruiters and hiring managers to evaluate candidate’s ability to create clusters

• which is group of servers that are highly available and capable super-servers 
• Permissions: Our test assesses applicant’s knowledge about SQL secure permissions which can provide and revoke access to securable 
• Transact-SQL statement: This test evaluates candidate’s understanding about T-SQL which is mainly used for writing entire program of block function procedure 
• Configuration: This test assesses a candidate’s ability to configure Microsoft SQL server 
• Transact Log Management: Our test evaluates candidate’s understanding about Transact Log which is used to maintain a sequential record of all changes made to the database 
• Concepts – Auditing: iMocha’s SQL DBA online test reduces candidate’s ability to audit the SQL server which monitors a group of actions 
• Concepts – Replication: Our assessment checks candidate’s knowledge about data replication which provides data availability when fault occurs to the server 
• Stored procedure: This test gauges candidate’s understanding about stored procedure where a block of code can be reused repeatedly 

• Test Duration: 20 minutes
• No. of Questions: 10