Thursday, 15 December 2016

// // Leave a Comment

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 comparison of actual outcomes with predicted outcomes. Test automation can automate some repetitive but necessary tasks in a formalized testing process already in place, or perform additional testing that would be difficult to do manually. Test automation is critical for continuous delivery and continuous testing.

What do you understand by data page in Pega?
Data pages (known previous to Pega 7 as "declare pages" and "declarative pages") store data that the system needs to populate work item properties for calculations or for other processes. When the system references a data page, the data page either creates an instance of itself on the clipboard and loads the required data in it for the system to use, or responds to the reference with an existing instance of itself.

How create date page in Pega?
Using the Data Explorer, in the Designer Studio, you can quickly create a data page and specify its structure, properties, data source or sources, when and how it refreshes its data, and any parameters it accepts.
To open the Data Explorer, click Data in the explorers panel in the Designer Studio (see the image at left). The Data Explorer displays a list of all the data object types (classes) in your application, and all the data pages for each data object type.

What is difference between default locking and optimistic locking in Pega7 ?
Pega 7 provides two case locking options and capabilities. You make your basic configurations in the Case Designer at the top-level case type. The settings cascade to all the subcase types.

  • Default locking – When a case is opened in a Perform harness, it and its parent case are locked. Only one user can view and update the case at a time. You can override the default behavior at the each subcase type level.
  • Optimistic locking – Multiple users can open a case in a Perform harness at the same time to review or update it. The first user to submit an update "wins;" users who had updated the form but had not submitted changes must refresh the form, re-enter their updates, then submit them.

What do you understand by Agent in Pega?
An agent is an internal background process operating on the server that runs activities on a periodic basis.  Agents route work according to the rules in your application; they also perform system tasks such as sending email notifications about assignments and outgoing correspondence, generating updated indexes for the full-text search feature, synchronizing caches across nodes in a multiple node system, and so on.

What is difference between Standard Agent and Advanced Agent in pega?

How to export data from pega express into CSV/Excel?
You can export data records to a CSV file.
Turn editing on
Click the data icon on the left side of the screen
Click on the data type you are interested in exporting
Navigate to the records tab (second tab) for that data type
Click the export link located on the top right of the records tab. This will export a CSV file of records that you can open in Excel.

Difference between work list and work basket?
Work List: Work list contains the tasks assigned to the individual Person.
Work Basket: Work Basket will contain the tasks assigned to the group of individuals in the project.

What is an Agent in Pega?
An agent is an internal background process operating on the server that runs activities on a periodic basis.  Agents route work according to the rules in your application; they also perform system tasks such as sending email notifications about assignments and outgoing correspondence, generating updated indexes for the full-text search feature, synchronizing caches across nodes in a multiple node system, and so on.

What is difference between Standard Agent and Advanced Agent in pega?

  • Standard: The default Queue Mode setting for agents created in V5.4 is Standard.  Standard mode assumes that the transnational processing will be handled by the agent queue functionality, and that the agent activity will contain only business logic. When the Mode is set to Standard, then when the agent wakes up, it immediately checks the agent queue to see if there are any entries for that agent.  If there are, it processes the entries until either the Max Records number of entries have been processed, or the queue is empty – whichever comes first.  After this processing, the agent stops and goes “back to sleep” for its specified interval.
  • Advanced: In Advanced mode, the agent activity is again responsible for both transnational and business processing.  However, unlike the Legacy mode, the agent activity in Advanced mode may still use the agent queue functionality; it just must do so explicitly (rather than the Standard mode, where the agent queue is engaged automatically).  So when the agent “wakes up,” it runs the activity directly, and that activity may either call the agent queue, or just do processing without a queue.

Name the three queue Mode values?

Can we write Automated Unit Test in Pega Tool?

What do you understand by Offline mobility feature of Pega 7?
The Pega 7 Platform provides the ability to build offline mobile applications for mobile workers. It offers a seamless experience for a field service employee working in locations that have no network connection or whose device loses a network connection.
Mobile workers can log in, create cases, open items from their worklist, and complete assignments, all while working offline. This harnesses the Pega 7 Platform standards-based UI capabilities along with the custom mobile application. The mobile application with offline capability uses the same building blocks as all Pega applications.

What can be the scope of data page?
The data page scope can be one of the following
Node – any requestor executing on the current node can access the pages.

Thread – the page is created in a single requestor thread, and can be accessed as often as needed by processing in that thread. Access by separate requestors causes the rule to create distinct pages, which might have different contents.

Requestor – all threads for the current requestor.

Read More


What would be the output of following query? 😄
SELECT CASE WHEN 1=1 THEN 'Vikas Ahlawat1'
            WHEN 2=2 THEN 'Vikas Ahlawat2'

            ELSE  'Vikas Ahlawat3' END AS Name

Read More

Thursday, 8 December 2016

// // Leave a Comment

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 database design, query design, and index design.
Read More
// // Leave a Comment

How you will check the Priority assigned to SQL Server management studio?

If SSMS Priority is low then it will degrade SSMS performance so if your server responding slow then you must check base priority of SSMS
Priority is the weight given to a resource that pushes the processor to give it greater preference when executing. To determine the priority of a process, follow these steps:

  1. Launch Windows Task Manager.
  2. Select View ➤ Select Columns.
  3. Select the Base Priority check box.
  4. Click the OK button.

These steps will add the Base Priority column to the list of processes. Subsequently, you will be able to determine that the SQL Server process (ssms.exe) by default runs at Normal priority, whereas the Windows Task Manager process (taskmgr.exe) runs at High priority.

Read More

Wednesday, 7 December 2016

// // Leave a Comment

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 Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client connections. The DAC is available through the sqlcmd utility and SQL Server Management Studio. The connection is only allowed from a client running on the server. No network connections are permitted.
To use SQL Server Management Studio with the DAC, connect to an instance of the SQL Server Database Engine with Query Editor by typing ADMIN: before the server name. Object Explorer cannot connect using the DAC.

Click here for more
Read More
// // Leave a Comment

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 sandboxed with limited permissions and can only make requests to same CRM tenant or to external web services. Here again, this really comes down to how much customization you intend or foresee happening via plug-ins.
  • For all you SQL gurus out there, online does not allow direct access to SQL data; while on premise does. This will limit your development of custom reports to the use of FetchXML for online, while you can use either FetchXML or direct SQL access for on premise. This could be somewhat of an issue, if you have a development staff versed in SQL, there will be a slight learning process for switching over to FetchXML.
  • CRM Online only offers Claims-Based Authentication and Security where CRM On-Premises offers either Claims-Based Authentication or ADFS. 
  • CRM On-Premises allows unlimited workflows and entities, where Online has a limit of 200 workflows and 300 entities.

Read More
// // Leave a Comment

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

  1. <expression> AS <alias>
  2. <expression> <alias>
  3. <alias> = <expression>

Read More
// // Leave a Comment

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 phase earlier to the one that evaluates the SELECT clause.

This is the reason that below statement will not work: 

Read More

Tuesday, 6 December 2016

// // Leave a Comment

In what order are clauses processed by the SQL Engine?

Read More
// // Leave a Comment

In what order are clauses written in a SQL Statement?

Read More
// // Leave a Comment

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.

Read More
// // Leave a Comment

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 row.
Read More
// // Leave a Comment

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 computed and the resulting data stored just like a table. You index a view by creating a unique clustered index on it. Indexed views can dramatically improve the performance of some types of queries. Indexed views work best for queries that aggregate many rows. They are not well-suited for underlying data sets that are frequently updated.
  • Partitioned Views:A partitioned view joins horizontally partitioned data from a set of member tables across one or more servers. This makes the data appear as if from one table. A view that joins member tables on the same instance of SQL Server is a local partitioned view.
  • System Views:System views expose catalog metadata. You can use system views to return information about the instance of SQL Server or the objects defined in the instance. For example, you can query the sys.databases catalog view to return information about the user-defined databases available in the instance. 

Read More
// // Leave a Comment

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 execution plans
  • Non-set-based operations, usually T-SQL cursors
  • Poor database design
  • Excessive blocking and deadlocks
  • Excessive fragmentation
  • Nonreusable execution plans
  • Frequent recompilation of queries
  • Improper use of cursors
  • Improper configuration of the database log
Read More

Thursday, 1 December 2016

// // Leave a Comment

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 of the current indexes
  • Avoiding bookmark lookups
  • Evaluating the effectiveness of the current statistics
  • Analyzing and resolving fragmentation
  • Optimizing execution plan caching
  • Analyzing and avoiding stored procedure recompilation
  • Minimizing blocking and deadlocks
  • Analyzing the effectiveness of cursor use
Read More
// // Leave a Comment

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 the information was unavailable or very difficult to obtain.

Here are some of the more useful DMVs that you should familiarize yourself with:

  • sys.dm_exec_sessions - Sessions in SQL Server
  • sys.dm_exec_cached_plans - Cached query plans available to SQL Server
  • sys.dm_exec_connections - Connections to SQL Server
Read More
// // Leave a Comment

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. You can use the rich and powerful R language and the many packages from the community to create models and generate predictions using your SQL Server data.

Read More
// // Leave a Comment

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 Dynamics CRM.

  • Oracle

  • SAP
  • Sage CRM
  • Sugar CRM
  • NetSuite
Read More
// // Leave a Comment

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
Microsoft Dynamics CRM 2011
Microsoft Dynamics CRM 2013
Microsoft Dynamics CRM 2015
Microsoft Dynamics CRM 2016 (Latest version)
Read More
// // Leave a Comment

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 want to share with you the process that I have usually followed to get work ,
and that has given me very good results, and quite possibly is radically different from the process you are following.
The method is really simple, it is divided into 7 steps and once estructures and repeat it every day, you will be able to multiply your results, and find work more easily.

Here are the step by step guide for you to get a job, and belive me if you follow below step carefully then you must got a job. But must read full article carefully.

The first point is to be aware of your strengths and weaknesses. Normally one of the typical questions in a job interview is usually "tell me your strengths and weaknesses , " and if you have not thought about them previously, you can see committed and jeopardize the interview.

On the other hand when developing your resume , strengths and weaknesses play a fundamental role, since it is the first thing you will find the person who looks at your resume, and decide if you get a chance or not, depending on East.

You'll think about your strengths
What stands out most, or what is missing in your training, facing the job you want to choose?
If you have an MBA, a BA courses abroad, are data put on your resume, and bring forth to light in the interview. Conversely, if you are not training you should focus your resume and interview in other ways.
How much have relevant experience for the position job?

Do not think only in terms of technical requirements (such as programming or management of Microsoft Office), also thinks in terms of skills (project management, leadership, work under pressure), notes the most important aspects, as you will use in the next step.

What kind of work you have a good profile?

This is the technical part of your strengths and weaknesses, here you have to quantify as possible. For example level of English, certifications tools or achievements in your previous works are aspects that make you more attractive to businesses.

What type of work motivates you, and what kind of work does not motivate you?

This is key to addressing the successful job interview. Detect those aspects that you liked most of your training or previous work, and who are those who seek in your new jobs, because surely these works are closely related to your strengths and your weaknesses related bit.

You can read my article on how to find a job you are passionate to know what kind of work it may be appropriate for you.

Once you do this, make a list of possible job positions you think you'd get taking into account all these aspects.

With the information you have collected in the previous step in terms of training and experience you'll develop a curriculum that is able to show the company that you are able to solve their problems and needs, emphasizing your strengths and minimizing your potential weaknesses ( as it could be lack of training, experience, etc).

The job search is to be carried out increasingly through social networks such as Linkedin or Xing.
Social networks offer many more possibilities than traditional job portals when getting work.
While in employment portals adopt a passive attitude, sending your resume and waiting to be contacted in social networks adopt an active attitude make it known as a professional.

Specifically, Linkedin offers the possibility of :
Contact with other professionals in order to increase your chances of getting a job.
Follow companies to find out when they post jobs and submit your resume.

On Twitter you can:
Following companies to be aware of what publish jobs.
Use #hashtags for possible jobs (#SoftwareJobs, #ITJobs, #ManagerJob). These allow you to save hours hashtag search job portals.
Follow other job.

The next step once you've built your resume, and you open your profile on social networks is to find companies that could offer you the job of your dreams . To do this you go to:

Find information about companies that have announced job offers that you might find useful.
Search for potential contacts within those companies on social networks (Linkedin).
Connect with them and send them a letter in order to have any chance of getting a job interview.
If you send one mail a day to a different person, at the end of month you will have 30 new contacts and 30 potential employment opportunities. It all adds up.

This is something that many people overlook.
Did you know that large companies select only 1% of its employees through job portals?

By this I do not mean that you will not get a job, I'm just saying you have to send at least 100 curriculums to have any chance. How many hours will miss doing this?

Instead of sending your resume through job portals, focus on contact with people who can give you a job . Focus on building relationships through social networks like Linkedin or events in your sector.

If you make 1 new contact every day, at the end of the year you can have 365 new employment opportunities.

Personal branding is a booming trend, and gives you value as much higher than can you provide any professional resume.
Among the advantages of having a personal brand we can include:

- Position yourself as an expert in a niche market.

- Send a single message, you apart from other candidates for the post of employment.

- To become the demand rather supply. You're not a candidate's job seeker, you are a leader who look for companies.

You can start building your personal brand on social networks like Linkedin and Twitter, and you can go beyond opening a blog or editing videos on youtube related to the topic in which you work.

The last step is to integrate all the above steps in a systematic job search and contact creation process. You must perfect each step of the process :

Differentiate your resume : build a curriculum that differentiates you from other candidates
Learning to use social networks and job search portals: perfects the art of looking for work on the Internet, use your existing network of contacts, expand it and generate new employment opportunities.
Build personal brand : go beyond a simple resume, show your knowledge and position yourself as a leader increases your chances of getting a job.
Hone your strategy and tactics in job interviews : Learn to prepare, respond and systematize the whole process of selection of any company.
The key to all this is: "practice, practice, practice"

I hope the article has been useful, Thanks for reading.
Best of luck
Read More