#AUTOMATED TESTING INTERVIEW QUESTIONS, #PEGA Top 100 PEGA-PRPC Interview Questions and Answers for Experienced and Freshers Describe Automated Testing? Automated Testing/(test automation) is the use of special software(Testing tools) to control the execution of tests and the 22:57 Share
SQL SERVER CASE PUZZLE QUERY What would be the output of following query? 😄 SELECT CASE WHEN 1 = 1 THEN 'Vikas Ahlawat1' WHEN 2 = 2 THEN 'Vikas Ahlawat2' ELSE 'Vikas Ahl 22:09 4 Share
What your experience say that looking at what part give you the most performance improvement in SQL Server database? You can obtain the greatest improvement in database application performance by looking first at the area of data access, including logical/physical d 22:06 Share
How you will check the Priority assigned to SQL Server management studio? SQL SERVER PERFORMANCE TUNING TICK If SSMS Priority is low then it will degrade SSMS performance so if your server responding slow then you must chec 21:54 Share
What do you understand by DAC in SQL Server? Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server 22:04 Share
What is the differences in CRM Application Architecture from CRM Online to CRM On-Premises? Sticking with development, on premise allows for custom developed plug-ins. Online allows for this as well, but with limitations. Plug-ins are sandbox 00:42 Share
What are the forms of aliasing an attribute in T-SQL? Below are the syntaxs of aliasing in T-SQL, you can use any one of three <expression> AS <alias> <expression> <alias> <alias& 00:12 Share
Why are you not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause? You not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause, because the WHERE clause is logically evaluated in a pha 00:02 Share
In what order are clauses processed by the SQL Engine? 1- FROM 2- WHERE 3- GROUP BY 4- HAVING 5- SELECT 6- ORDER BY 23:51 Share
In what order are clauses written in a SQL Statement? 1- SELECT 2- FROM 3- WHERE 4- GROUP BY 5- HAVING 6- ORDER BY 23:50 Share
What is the difference between Partitioning and GROUP BY? Unlike grouping, partitioning is specific to one function's window and can be different for different functions in the same query. 23:46 Share
What is Partitioning in SQL Server? The partitioning element allows you to restrict the window to only those rows that have the same values in the partitioning attributes as the current 23:44 Share
Types of Views in SQL Server? Below are the types of View in SQL Server Indexed Views: An indexed view is a view that has been materialized. This means the view definition has been 23:10 Share
What are the major problem areas that can degrade SQL Server performance? Following are the major problem areas that can degrade SQL Server performance: Poor indexing/Bad indexing Inaccurate statistics Poor query design Poor ex 02:01 Share
What you do to performance tune your SQL Server on regular basis in your current organization? Below are my regular jobs to keep my SQL Server fast. Identifying problematic SQL queries Analyzing a query execution plan Evaluating the effectiveness 23:33 Share
What do you understand by DVMs in SQL Server? The DMVs were introduced in SQL 2005, DMVs allow you to get better insight into what is happening in SQL Server. Without these new tools a lot of th 23:18 Share
What is R Services introduced in SQL Server 2016? SQL Server R Services. R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new insights. 22:57 Share
#MS DYNAMICS CRM Top Competitors of Cynamics CRM in market? Microsoft Dynamics CRM is undoubtedly one of the top products in the CRM space. However, following are the other products that compete Microsoft Dyna 22:56 Share
#MS DYNAMICS CRM Microsft CRM versions history Below is the Microsft CRM versions history: Microsoft CRM 1.0 (first version) Microsoft CRM 1.2 Microsoft Dynamics CRM 3.0 Microsoft Dynamics CRM 4.0 22:55 Share
#JOB How To Get a Job In 7 Steps Easily, Goal setup Are you looking for a job for months? Have you sent your resume to hundreds of job applications without obtaining just results? In this article I wan 22:45 Share