Pragmasys Consulting LLP Associate Consultant Interview Questions and Answers

Q1. JavaScript concepts
Add your answer
Q2. JavaScript coding
Add your answer
Q3. Angular questions
Add your answer

Q1. Angular questions
Add your answer
Q2. Angular implementation explanation
Ans. 
Angular implementation explanation
• Angular is a popular front-end framework for building web applications

• Uses TypeScript for development

• Components, services, modules, and directives are key concepts in Angular

• Data binding, dependency injection, and routing are important features

• Example: Creating a new component in Angular - ng generate component my-component
Answered by AI
Add your answer

Q1. Casual questions and discussion
Add your answer

Q1. Salary discussion and casual discussion
Add your answer

Q1. Difference between String and StringBuilder?
Ans. 
String is immutable, StringBuilder is mutable.
• String is immutable, meaning its value cannot be changed once it is created.

• StringBuilder is mutable, allowing for the modification of its value without creating a new object.

• String concatenation in a loop is more efficient with StringBuilder to avoid creating multiple String objects.

• StringBuilder has methods like append(), insert(), delete(), etc. for modifying its value.
Answered by AI
Add your answer
Q2. What are AWS services?
Ans. 
AWS services are a collection of cloud computing services provided by Amazon Web Services.
• Compute services (e.g. EC2, Lambda)

• Storage services (e.g. S3, EBS)

• Database services (e.g. RDS, DynamoDB)

• Networking services (e.g. VPC, Route 53)

• Analytics services (e.g. Redshift, Athena)

• Machine Learning services (e.g. SageMaker)

• Security services (e.g. IAM, KMS)
Answered by AI
Add your answer

30 min Aptitude Test

Q1. Some basic Sql questions, basic python, and project which i did on the college time
Add your answer

Setup a cluster and find the bottleneck of performance.

Q1. Ways to deal with latency in Cassandra
Ans. 
Ways to optimize latency in Cassandra
• Use appropriate data modeling to reduce the number of queries needed

• Optimize queries by using appropriate indexes and clustering keys

• Tune the Cassandra configuration settings for better performance

• Use caching mechanisms like Memcached or Redis to reduce latency

• Consider using partitioning strategies to distribute data evenly across nodes
Answered by AI
Add your answer

Q1. Reason for changing job and why should we hire you
Ans. 
Seeking new challenges and opportunities for growth. I bring a unique blend of skills and experience to add value to your team.
• Looking for new challenges and opportunities for professional growth

• Seeking a more dynamic work environment to utilize my skills effectively

• Excited about the possibility of contributing to a new team and organization

• Believe my diverse skill set and experience make me a valuable addition to your
Answered by AI
Add your answer

Q1. Real time DBA issues and scenarios
Add your answer
Q2. Questions on HA and Always on
Add your answer

Improve your Logical Quotient, so that you can easily crack it.

Q1. Explain thread lifecycle.
Ans. 
Thread lifecycle refers to the various stages a thread goes through during its execution.
• A thread is created using the 'new' keyword or by implementing the 'Runnable' interface.

• The thread is started using the 'start()' method.

• During its execution, the thread can be in various states such as 'Runnable', 'Blocked', 'Waiting', etc.

• The thread can be interrupted using the 'interrupt()' method.

• The thread completes its execut...read more
Answered by AI
Add your answer
Q2. Explain profiling in Springboot
Ans. 
Profiling in Springboot is a way to measure and analyze the performance of an application.
• Profiling helps identify performance bottlenecks and optimize code

• Springboot provides built-in support for profiling through the use of various tools such as VisualVM and JProfiler

• Profiling can be done on both the server-side and client-side of the application

• Profiling can help identify memory leaks, CPU usage, and other performan
Answered by AI
Add your answer
Q3. Advantages of SQL over NoSQL
Ans. 
SQL is better for structured data and complex queries, while NoSQL is better for unstructured data and scalability.
• SQL is better for handling complex queries and transactions

• SQL databases have better data consistency and integrity

• NoSQL is better for handling unstructured data and scalability

• NoSQL databases are more flexible and can handle large amounts of data

• SQL databases are better suited for applications with a fixe...read more
Answered by AI
Add your answer

Q1. Explain your last project.
Add your answer