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

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

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/...

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 y...

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 S...

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-in...

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> <ali...

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 evaluate...

In what order are clauses processed by the SQL Engine?

1- FROM 2- WHERE 3- GROUP BY 4- HAVING 5- SELECT 6- ORDER BY

In what order are clauses written in a SQL Statement?

1- SELECT 2- FROM 3- WHERE 4- GROUP BY 5- HAVING 6- ORDER BY

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.

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 t...

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 defi...

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 q...

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

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

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

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 Micr...

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 D...

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 a...

How you will change the font size/style in SQL Server?

Ans:- By following below steps

Write a query to get all employee detail from "EmployeeDetail" table?

Tables:- 1. Write a query to get all employee detail from "EmployeeDetail" table  ANS: SELECT   *   FROM  [EmployeeDeta...

What are the Goals of CRM Security Model?

Microsoft Dynamics 365 and Microsoft Dynamics 365 (online) provide a security model that protects data integrity and privacy, and supports ...

Difference between Role based Record based and Field Level Security in Dynamics CRM

Role-based security:  Role-based security in Microsoft Dynamics 365 focuses on grouping a set of privileges together that describe the re...

Field Level Security in Microsoft Dynamics CRM

In Microsoft Dynamics 365 and Microsoft Dynamics 365 (online), you use field-level security to restrict access to high business impact fiel...

What is MS CRM? MS Dynamics CRM Interview Question

CRM stands for customer relationship management. CRM is a category of integrated, data-driven solutions that improve how you interact and d...

TRUNCATE is DDL or DML command in SQL Server?

Ans: DDL

Difference between Session and Connection in SQL Server?

Sessions – when the client application connects to SQL Server the two sides establish a “session” on which to exchange information. Stric...

What is a Data Page in SQL Server?

A page is the most basic unit of storage in SQL Server. The disk space allocated to a data file (.mdf or .ndf) in a database is logically d...

What is Fill Factor in SQL Server? SQL Server Interview Question

In SQL Server a page(8KB size) is the basic unit of data storage in SQL server. Data is stored in the leaf-level pages of Index.  The perce...

What is the difference between TRY_CONVERT and Convert? 2016 SQL Server Interview Question

Convert : enables you to convert data stored in one data type to another. The conversion might fail if you attempt to convert between data ...

What is the maximum length of a file-name in S3?

Names are the object keys. The name for a key is a sequence of Unicode characters whose UTF-8 encoding is at most 1024 bytes long.

How to access/ping a server located on AWS?

Using UI: In your security group: Click the inbound tab Create a custom ICMP rule Select echo request Use range 0.0.0.0/0 for e...

How to delete files recursively from an S3 bucket?

aws s3 rm --recursive s3://your_bucket_name/foo/ Or delete everything under the bucket: aws s3 rm --recursive s3://your_bucket_name If...

How many objects you can put in a S3 bucket? is there a limit to the number of objects I can put in an S3 bucket?

Write, read, and delete objects containing from 1 byte to 5 terabytes of data each. The number of objects you can store is unlimited.

What is the difference between Amazon SNS and Amazon SQS?

Amazon SNS  allows applications to send time-critical messages to multiple subscribers through a “push” mechanism, eliminating the need to...

How you will change the root EBS device of my amazon EC2 instance?

Stop the instance. Detach the root EBS volume. Attach the alternate EBS volume (as the root e.g. /dev/sda1) Start the instance. This p...

Write down the command you will use to copy all files from one S3 bucket to another with s3cmd?

s3cmd sync s3://from/this/bucket/ s3://to/this/bucket/

Explain what happens when I reboot an EC2 instance?

Rebooting an instance is like rebooting a PC. The hard disk isn't affected. You don't return to the image's original state, but...

How do you see how much disk space is using by S3 bucket?

s3cmd can show you this by running s3cmd du, optionally passing the bucket name as an argument.

How step you follow to make 10,000 files as public in S3?

I will generate a bucket policy which gives access to all the files in the bucket. The bucket policy can be added to a bucket through AWS c...

Is it possible to use AWS as a web host? What are the way of using AWS as a web host?

Yes it is completely possible to host websites on AWS in 2 ways:  Easy - S3 (Simple Storage Solution) is a bucket storage solution that...

How do you pass custom environment variable on Amazon Elastic Beanstalk (AWS EBS)?

As a heads up to anyone who uses the .ebextensions/*.config way: nowadays you can add, edit and remove environment variables in the Elastic...

How you will find out the instance id from within an ec2 machine?

wget -q -O - http://instance-data/latest/meta-data/instance-id If you need programatic access to the instance ID from within a script di...

What are the benefits of EBS vs. instance-store?

EBS backed instances can be set so that they cannot be (accidentally) terminated through the API. EBS backed instances can be stopped whe...

Which AWS responsible for managed email and calendaring?

WorkMail is a managed email and calendaring service with strong security controls and support for existing desktop and mobile email clients...

What is Amazon AppStream and advantage of using AppStreaming?

Amazon AppStream is an application streaming service that lets you stream your existing resource-intensive applications from the cloud with...

How to find your regions and Availability Zones using the Amazon EC2 CLI?

Use the ec2-describe-regions command as follows to describe your regions. PROMPT> ec2-describe-regions REGION us-east-1  ec2.us-east-1...

Explain what is Regions and Endpoints in AWS?

To reduce data latency in your applications, most Amazon Web Services products allow you to select a regional endpoint to make your request...

What Is Amazon CloudSearch and its features?

Amazon CloudSearch is a fully managed service in the cloud that makes it easy to set up, manage, and scale a search solution for your websi...

What is Amazon Kinesis Firehose?

Amazon Kinesis Firehose is a fully managed service for delivering real-time streaming data to destinations such as Amazon Simple Storage Se...

What is AWS Data Pipeline? and what are the components of AWS Data Pipeline?

AWS Data Pipeline is a web service that you can use to automate the movement and transformation of data. With AWS Data Pipeline, you can de...

What is Amazon EMR?

Amazon Elastic MapReduce (Amazon EMR) is a managed cluster platform that simplifies running big data frameworks, such as Apache Hadoop and ...

What is AWS WAF? What are the potential benefits of using WAF?

AWS WAF is a web application firewall that lets you monitor the HTTP and HTTPS requests that are forwarded to Amazon CloudFront and lets yo...

What is the AWS Key Management Service?

The AWS Key Management Service (AWS KMS) is a managed service that makes it easy for you to create and control the encryption keys used to ...

Explain what is ElastiCache?

ElastiCache is a web service that makes it easy to set up, manage, and scale distributed in-memory cache environments in the cloud.

Explain what is DynamoDB in AWS?

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. You can...

Explain how the buffer is used in Amazon web services?

The buffer is used to make the system more robust to manage traffic or load by synchronizing different component.  Usually, components rece...

Explain what is C4 instances?

C4 instances are ideal for compute-bound applications that benefit from high performance processors.

Explain what is T2 instances?

T2 instances are designed to provide moderate baseline performance and the capability to burst to significantly higher performance as requi...

How many buckets can you create in AWS by default?

By default, you can create upto 100 buckets in each of your AWS accounts.

Mention what are the differences between Amazon S3 and EC2 ?

S3:  Amazon S3 is just a storage service, typically used to store large binary files. Amazon also has other storage and database services, ...

Explain some features of Amazon EC2?

Amazon EC2 provides the following features: Virtual computing environments, known as instances Preconfigured templates for your instance...

Explain what Is Amazon EC2 instance?

An EC2 instance is a virtual server in Amazon's Elastic Compute Cloud (EC2) for running applications on the Amazon Web Services (AWS) i...

What Is Amazon EC2?

Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) cloud. Using Amazon EC2 eli...

Explain what is Redshift?

Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all...

Mention what is the relation between an instance and AMI?

From a single AMI, you can launch multiple types of instances.  An instance type defines the hardware of the host computer used for your in...

Explain what is AMI ( Amazon Machine Image )?

It’s a template that provides the information (an operating system, an application server and applications) required to launch an instance,...

Explain what is S3 in AWS?

S3 stands for Simple Storage Service. You can use S3 interface to store and retrieve any amount of data, at any time and from anywhere on t...

What is AWS Certificate Manager?

AWS Certificate Manager (ACM) handles the complexity of provisioning, deploying, and managing certificates provided by ACM (ACM Certificate...

Explain what is IAM service?

AWS Identity and Access Management (IAM) is a web service that helps you securely control access to AWS resources for your users. You use I...

Explain what are the key components of AWS( Amazon Web Service )?

The key components of AWS are :- (AWS 2016 INTERVIEW QUESTIONS) Route 53:  A DNS web service Simple E-mail Service:  It allows sending e...

Explain what is AWS(Amazon Web Service)?

AWS stands for Amazon Web Service; it is a collection of remote computing services also known as cloud computing platform.  This new realm ...

Top 80 AWS INTERVIEW QUESTIONS ANSWERS SET-2

AWS INTERVIEW QUESTIONS SET-2 set-2 link available at bottom of this post 1.)  What is Amazon RDS? 2.)  In RDS, what is the max...

What is the underlying Hypervisor for EC2? AWS INTERVIEW QUESTION

What is the underlying Hypervisor for EC2? Ans: Xen

What are the 4 level of AWS premium support?

What are the 4 level of AWS premium support? Ans: Basic, Developer, Business, Enterprise

In S3, what does RRS stand for? AWS INTERVIEW QUESTION

In S3, what does RRS stand for? Ans: Reduced Redundancy Storage

TCS AWS Interview Question Answers

If you want to run a database on an EC2 instance, which is the most recommended Amazon storage option, S3, RDS or EBS? Ans: EBS Click her...

In RDS, Automated backups are enabled by default for new DB Instance, true or false?

Ans: True

In RDS, what is the maximum value you can set for my backup retention period? AWS INTERVIEW QUESTION

Ans: 35 Days Note : This questions asked during Aon Hewitt Interview

What is Amazon RDS? AWS INTERVIEW QUESTION

RDS stand for Relational Database Service is a web service that makes it easier to set up, operate, and scale a relational database in the ...

What is the difference between Elastic Beanstalk and CloudFormation? AWS Interview Question

Elastic Beanstalk automatically handles the deployment, from capacity provisioning, load balancing, auto-scaling to application health moni...

What action is required to establish an Amazon Virtual Private Cloud (VPC) VPN?

We need to assign a static internet-routable IP address to an Amazon VPC customer gateway. Note : This questions asked during Prospecta S...

Samsung AWS Interview Question

Suppose that you are working with a customer who has 10 TB of archival data that they want to migrate to Glacier. The customer has a 1-Mbps...

What is MFA in AWS? AWS Interview questions

AWS Multi-Factor Authentication (MFA) is a simple best practice that adds an extra layer of protection on top of your user name and passwor...

What is Amazon VPC?

Amazon Virtual Private Cloud (Amazon VPC) enables you to launch Amazon Web Services (AWS) resources into a virtual network that you've ...

Example, how you will create a VPC and Subnets using the AWS CLI? NASA

Click here for answer Note : This questions asked during NASA Interview

Why we use VPC in AWS? AWS INTERVIEW

Normally, each EC2 instance you launch is randomly assigned a public IP address in the amazon EC2 address space. VPC allows you to create a...

Can you descrive the steps of create default VPC in AWS? AWS Interview Question

When we create a default VPC, we do the following to set it up for you: ( Create a default subnet in each Availability Zone. Create an ...

What are the three features provided by Amazon that you can use to increase and monitor the security? AWS Interview

Amazon VPC provides three features that you can use to increase and monitor the security for your VPC: Security groups — Act as a firewa...

What benefits to VPC security groups give you that EC2 security groups do not?

What benefits to VPC security groups give you that EC2 security groups do not? ( AWS Interview Questions Answers) Ans: 1. Being able to c...

What is the difference between Network ACLs and Security Groups in AWS? AWS Interivew Question

What is the difference between Network ACLs and Security Groups in AWS? Amazon Web Services Interview Question Network ACLs: A network ...

Top 20 Telerik Test Studio Interview Questions Answers PDF

Here are the Top 20 Telerik Test Studio Interview Question with Answers, If you looking for job change and preparing for interview then thi...

What are the Key Steps to Prepare and Execute the Testing of a Project? Testing Interview Question

Below are the Key Steps to Prepare and Execute the Testing of a Project Get to know the domain expert and user community. Fundamentally ...

Telerik Test Studio R3 2016 new features? Interview Question

The third major Test Studio R3 2016 is live now. Here are the new features of R3 2016 include support for Angular, iOS 10, our very own Nat...

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

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. Suppos...

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

Follow Us

Blog Archive

Recent

Comments

Donate

Side Ads

Text Widget

Connect Us

Sql Server 2017 Interview Questions
Sql Server Basic Interview Query Set-1
Sql Server Basic Interview Query Set-2
Sql Server Date-Time Interview Query SET-3
Sql Server Salary Interview Query SET-4
Sql Server Group By Interview Query SET-5
Sql Server Join Interview Query SET-6
Sql Server Tricky Join Interview Query SET-7
Sql Server DDL Interview Query SET-8
Small but very Tricky Sql Server Query SET-9
Very Much Tricky Query (not 4 fresher)SET-10
Sql Server Complex Interview Query SET-11
Sql Server Datatype Interview Questions
Sql Server View Interview Questions
Sql Server Index Interview Questions
TCS Tricky Sql Interview Queries
HCL Sql Interview Queries
Sql Server SP Interview Questions
Sql Server Trigger Interview Questions
Sql Server Temp Table Interview Questions
Sql Server 2016 Interview Questions
Sql Server Performance Tuning Interview Q.
Sql Server Constraints Interview Questions
Sql Server Storage/Size Interview Questions
Sql Server Very Basic Interview Questions
Sql Server Quiz for Fresher
Sql Server Icon Quiz for All
Sql Server 300+ Theoretical Interview Questions
Sql Server Complete Set

ASP.NET AND JQUERY INTERVIEW QUESTION
ASP.NET: Web Config Interview Question
ASP.NET: View State Interview Question
ASP.NET: Session Interview Question
ASP.NET: Session Interview Question 
ASP.NET: Security Interview Question
ASP.NET: Catching Interview Question
C# OOPS Interview Question
MORE Interview Question
JQUERY: Interview Question Set-1
JQUERY: Interview Question Set-2
JAVA-SCRIPT: Interview Question Set-1
JAVA-SCRIPT: Interview Question Set-2
ASP.NET MVC: Interview Question Set-1

POPULAR POSTS
10 MOST DIFFICULT INTERVIEW QUESTIONS
5 BEST INTERVIEW TIPS
YOUR 10 MISTAKE DURING INTERVIEW
2016 TOP 20 GROUP DISCUSSION TOPICS
HOW SQL PERFORMANCE AFFECTED BY DATATYPE

Contact Us

Name

Email *

Message *

archive