Wednesday, 26 October 2016

Telerik Test Studio Advantages and Disadvantages / limitations

Here we come with Advantages/benefits of Telerik Test Studio, This is becoming very popular testing tool among tester world. So If you are preparing for testing interview then must go through this article.

Advantages of Telerik Test Studio:

  • Telerik Test Studio is very user friendly and easy to learn.
  • Good language support, Test Studio doesn’t require you to write code in a lot of scenarios. However, if you do need to it supports C# and VB.NET.
  • Team Collaboration, Testers can design and maintain tests and pass them to developers through source control to assist with more complex, edge-case scenarios.
  • Test Studio comes with rich support for data-driven testing. All recorded test steps have data-related properties that allow you to bind them to a data source. Test Studio supports various data sources: Excel, CSV, XML, and Database. In addition, it has a built-in data grid that allows you to quickly create your own data source right inside your test without having to revert to external sources.
  • Extensive HTML and Silverlight control Suite, Besides native support for Telerik controls, Test Studio software testing solution also includes an extensive suite of HTML and Silverlight control translators which abstract out the control specifics. Thanks to these translators, testers can build automated tests for complex control-based applications quickly and easily.
  • Custom controls support, Developers sometimes extend the components they are using to develop their applications. Test Studio automatically detects the base class that the control inherits and automatically suggests verifications for that base control – quick tasks, action handling, mouse actions, and more. 
  • Native Support for Telerik RadControls, As you know Telerik RadControls are very famous so If your applications are built with Telerik AJAX, Silverlight or WPF controls, Test Studio will automatically detect them and provide tailored verification which make it possible to test even complex controls like hierarchical grid, scheduler, etc.
  • JavaScript and JSON support, Test Studio supports JavaScript function invocation and validation directly from your code. The testing tool also understands JSON objects, can handle strongly typed objects returned from JavaScript, as well as access to JQUERY API’s.
  • You can run automated tests on real devices as well as emulators without writing a single line of code.

Disadvantages of Telerik Test Studio:
  • Test Studio is standalone and if you need to use VS plugin you need an extra VS professional or higher license.
  • You can't use elements of one project to another, so you have to create only 1 project and with due course of time it goes heavy. But this depends upon your application size. You can copy paste the content from one project to other as a work around.
  • You can convert all your steps to code, but can't revert them back.
  • Issue with the usability of the "If-else" statement, as for using the If-else condition, your element in "If" condition must be present if not, whole test case fails.
  • It doesn't support Android app testing and Desktop application testing (in desktop only WPF is supported).
  • For customized reports, if required you need to write code.
  • If the DOM of your application is heavy then Test Studio will create lots of performance issues while recording, like Test Studio and Application gets hang. For this you need to use trial version first.
  • Test cases where you are using a test case as a child of another, there you will find that you are not getting the desired behavior.
  • It's not a free tool and costly too.
  • Need powerful computer to run all capabilities
  • Quite a lot of customization options available but time consuming to set up.

Tuesday, 25 October 2016

What is dirty read in SQL Server? Accenture SQL Interview

In simple word you can define dirty read like, reading any value from any other transaction which is still not committed.
Example. Suppose there are two Transaction T1,T2,
T1 writing any variable value in DB and still not committed.
Same time if T2 try to Read the value before T1 committing,then its call Dirty Read, Because there are chance that T1 may Roll Back,but T2 using the Value which T1 wrote before Rollback.

Note: Questions asked during Accenture SQL Interview

Monday, 24 October 2016

What is collation? and What are different types of Collation Sensitivity in SQL Server?

What is collation?
Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
  • Case sensitivity: If A and a, C and c, etc. are treated in the same way then it is case-insensitive. A computer treats A and a differently because it uses ASCII code to differentiate the input. The ASCII value of A is 65, while a is 97. The ASCII value of C is 67 and c is 99.
  • Accent sensitivity: If e and é, o and ó are treated in the same way, then it is accent-insensitive. A computer treats a and á differently because it uses ASCII code for differentiating the input. The ASCII value of e is 101 and é is 130. The ASCII value of o is 111 and ó is 243.
  • Kana Sensitivity: When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.
  • Width sensitivity: When a single-byte character (half-width) and the same character when represented as a double-byte character (full-width) are treated differently then it is width sensitive.

What is the use of NOLOCK in SQL Server? Accretive Health Interview Questions

NOLOCK ensures your SELECT statements are fast because it doesn't have to wait for existing locks or transactions to complete before returning the results of your query. The down side is that you can end up pulling back "dirty" data - things that might have been rolled back before being committed but after your SELECT statement was run.


Note: This questions asked during Accretive Health Interview 

Pinal Dave SQL Server Interview Questions Answers PDF

Here we have 100+ SQL Server interview questions,in 10+ set. Please go through all set we promises set by set you interest will increase and you will got 90% more confidence after gone through all set.  Q.1 What do you understand by Continue reading.. 
If you want to download Pinal Dave's Pdf then visit

Wednesday, 19 October 2016

Get all records of a table by using TOP in select statement

As usual we use TOP keyword in our SQL statement for retrieving few records, but you can use TOP keyword to retrieve all data of a table by using "TOP 100 PERCENT" in your SQL statement.
SELECT TOP 100 PERCENT * FROM dbo.[EmployeeDetail]

Tuesday, 18 October 2016

What is the difference between Data files and Log Files in Sql Server?

Data files(.mdf and .ndf)
Data files contain data and objects such as tables, indexes, stored procedures, and views.

Type of Data files

  • Primary data file- The primary data file contains the startup information for the database and points to the other files in the database. User data and objects can be stored in this file or in secondary data files. Every database has one primary data file. The recommended file name extension for primary data files is .mdf.
  • Secondary data file- Secondary data files are optional, are user-defined, and store user data. Secondary files can be used to spread data across multiple disks by putting each file on a different disk drive. Additionally, if a database exceeds the maximum size for a single Windows file, you can use secondary data files so the database can continue to grow. The recommended file name extension for secondary data files is .ndf.

Log files(.ldf)
The transaction log files hold the log information that is used to recover the database. There must be at least one log file for each database. The recommended file name extension for transaction logs is .ldf.

What is the difference between Master, MSDB,TempDB and Model Databases?

Master Database: Records all the system-level information for an instance of SQL Server. It store all of the logins, linked servers, endpoints, and other system-wide configuration settings. The master database is also where SQL Server stores information about the other databases on this instance and the location of their files.

MSDB Database: Is used by SQL Server Agent for scheduling alerts and jobs.

TempDB Database: The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following: Temporary user objects that are explicitly created, such as: global or local temporary tables, temporary stored procedures, table variables, or cursors.

Model Database: The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.

Monday, 17 October 2016

Thursday, 13 October 2016

Top 50 APPIAN BPM Tool Interview Questions with Answers

Hey Developers today good news for you is that if you are preparing for BPM tool and make your career in it, then you are lucky, because you can crack interview easily, and the most favorable thing in this is that you have very less competitors these days in market, because very less resource are available in market these days. So if you are preparing for it then company will take you easily if you have some knowledge about it.
Here we come with top BPM(Business Process Management) Interview Questions for freshers as well as experienced, as you know BPM tools now on demand in market there are many tool available in market and continually becoming famous.
Like PEGA BPM, IBM BPM and Appian BPM tool.

Today we will gone through Appian BPM interview questions.

What do you understand by BPM?
Business process management (BPM) is a field in operations management that focuses on improving corporate performance by managing and optimizing a company's business processes. It can therefore be described as a "process optimization process."

What is BPM Software?
Technology that automates, executes, and monitors business processes from beginning to end by connecting people to people, applications to applications, and people to applications.

Name any top compatitor of Appian BPM suit?
Pegasystems BPM Suite

What are the top features of Appian BPM suit?

What are the advantages of using BPM tools?
Decreased Costs
At first glance, BPM seems to deliver the same major benefit as traditional enterprise application technology like ERP: increased workforce productivity (as a result of streamlining business operations and automating repetitive tasks). BPM platforms, however, go far beyond creating efficiency. Knowledge sharing capabilities and embedded collaboration help improve decision-making. Process performance reports (and even continuous process improvement help optimize workflows. Notifications and triggers help reduce errors and eliminate waste. And an intelligent rules engine enforces best practices. Thus, BPM platforms not only help organizations increase workforce productivity, but they also improve product quality and reduce corporate risk. The result? Within months of deployment, these improvements deliver substantial cost savings to companies.

Increased Revenue
In addition to decreasing costs, BPM platforms also help an organization raise its overall revenues by increasing product output, accelerating cycle time, and improving customer service. Straight-through processing helps accelerate delivery times. Dashboards help prioritize business activities by their influence on sales. Process performance reports help identify bottlenecks and reduce hand-offs. Centralized enterprise knowledge helps speed decision-making. And closed-loop customer feedback processes help track performance. Over time, these enhancements result in a faster time-to-market and an improved company image, which ultimately increases sales and revenues.

Improved Agility
While decreased costs and increased revenue are the two most immediate and tangible benefits of business process management, the real value BPM delivers is intangible. In the long run, composite process applications built with BPM platforms help organizations become more agile. Intelligent rules ensure that processes adapt automatically to changes in the business environment. Collaborative tools bridge department boundaries while improving and speeding decision-making. And in-flight process modifications accelerate response to change by dynamically rerouting processes in real time. With these capabilities, a company is better equipped to switch gears and respond to its changing business environment – faster than its competitors!

Is BPM Appian an open source application?
No. It is proprietary.

What do you understand by Activities in BPM terms?
An activity is any work that is being performed in a process. An Activity is represented by a rounded-corner rectangle in a Business Process Model. There are two types of activities tasks and sub-processes.

What do you understand by Annotations?
Annotations can be used to add textual comments within a process diagram.

What do you understand by Artifacts?
Artifacts allow process designers to extend the basic BPMN notation to include additional information about the process in the process diagram. There are three types of artifacts: data object, group, and annotation

What do you understand by Association?
An Association is used to show relationships between data, text and other Artifacts and flow objects in a process. An Association is represented by a dotted line with a lined arrowhead in a Business Process Model.

What do you understand by Business Process Diagram (BPD)?
A Business Process Diagram is a simple diagram made up of a set of graphical elements that depicts a business process. There are four primary elements of BPD: flow objects, connecting objects, swimlanes, and artifacts.

What do you understand by Business Process Model?
BPMN defines a Business Process Model as a network of graphical objects, which are activities, and the flow controls that define their order of performance.

What do you understand by Business Process Modeling Notation?
Business Process Modeling Notation was developed by the Business Process Management Institute to provide a process modeling notation that is understood by all process modelers, users, analysts, etc.

What do you understand by Connecting Objects?
Flow Objects are connected together using Connecting Objects. There are three types of Connecting Objects: Sequence Flow, Message Flow, and Association.

What do you understand by Data Object?
Data Objects are used to show how data is required or produced by activities in a process. Data Objects are represented by a picture of a piece of paper folded at the corner in a Business Process Model.

What do you understand by Events?
Events are anything that “happens” during the course of a business process. Events can have a cause, referred to as a Trigger, and/or an impact, referred to as a Result. Events are based on where they occur in the flow process (start, middle, or end).

Why We need BPM tool, Can you describe any real world business process examples?

What's the difference between CRM and BPM systems?
CRM is an abbreviation for customer relationship management and is a phrase used to describe all aspects of interaction that a company has with its customer, whether it is sales or service-related. It's a business strategy that helps your business to better understand your customer, retain customers, provide excellent customer service, win new clients and increase profitably.

ERP is an abbreviation for enterprise resource planning
ERP software is used to manage the business. It integrates all facets of an operation, including product planning, development, manufacturing processes, human resources, financials and sales and marketing.

What are the top features of Appian BPM suit? Interview Question

This is the most frequently asked BPM tool interview questions even if you are preparing for IBM BPM tool, So here are the features of Appian BPM tools features..

Process is simply sets of activities and transactions conducted regularly to achieve business objectives. It can be:
Simple (e.g., order fulfillment) OR Complex (e.g., new product development)
Short-term (e.g., employee on-boarding) OR Ongoing (e.g., regulatory compliance)
Function-specific (e.g., proposal management) OR industry-specific (e.g., energy procurement)
In a single department (e.g., billing), across an enterprise (i.e. strategic sourcing), or extend across the value chain (i.e. supply chain management)

Knowledge Management:
A BPM platform should have knowledge management capabilities to converge information on from across the organization.

Business Rules:
Business rules are the logic that in large part drives process automation. Rules provide the structure for consistent, automated process.

Social Collaboration:
Social Collaboration is a way to share information across an organization and interact to achieve a common goal. It drives awareness of any circumstance while adding to an organization’s knowledge base. Social collaboration is considered different from traditional collaboration in that it is inclusive by definition—involving anyone/everyone in a group or organization. It embraces a concept that good ideas are everywhere and anywhere.

Mobility represents the ability to use a business technology solution the same way on any mobile device as on a desktop computer. Mobile is a lifestyle. The explosion of smartphones and tablets in our personal lives has crossed into our professional lives as well. But with it is an unintended consequence—the need for control.

Security is about keeping data and operations safe from anything that could possibly threaten it, including disaster, hackers, or anything else you can think of. When BPM technology helps drive the core processes of an organization, security must be a prime consideration.

Flexible Deployment Options:
The ability to house and run your BPM platform on-premise and/or in a cloud environment interchangeably provides ultimate flexibility for organizations with a need to house sensitive data and/or processes behind their own firewall.

BPM can be a complex. Enablement is the combination of programs, tools, and people to make sure your BPM technology initiatives are successful. A Center of Excellence is a proven way to drive success.

Wednesday, 5 October 2016

Compare with NULL in SQL Server : Interview Question

Q 1: What would be the output of the following script.

Q 2: What would be the output of the following script.

Q 3: What would be the output of the following script.

Ans: All will print "False", Because when we compare anything will null it will return false. so condition will never true.