Publicis Sapient Senior Associate Platform L1 Interview Questions and Answers

A standard online test conducted through one of the testing platforms.

Q1. Java 8 features
Add your answer
Q2. Rest API
Add your answer
Q3. Java 8 coding problem
Add your answer
Q4. Collections
Add your answer

Q1. It was based on my previous project
Add your answer

Q1. What are primitive and non primitive data types
Ans. 
Primitive data types are basic data types provided by the programming language, while non-primitive data types are created by the programmer.
• Primitive data types include int, float, double, char, boolean, etc.

• Non-primitive data types include arrays, classes, interfaces, etc.

• Primitive data types store actual values, while non-primitive data types store references to objects.
Answered by AI
Add your answer
Q2. What are access modifiers and non access modifiers
Ans. 
Access modifiers control the visibility of classes, methods, and variables. Non-access modifiers provide additional functionality.
• Access modifiers: public, private, protected, default

• Non-access modifiers: static, final, abstract, synchronized

• Example: public class MyClass { private int myVar; }
Answered by AI
Add your answer
Q3. What are all Java 8 features and explain the one which we have used in our project
Ans. 
Java 8 features include lambda expressions, functional interfaces, streams, and more.
• Lambda expressions allow concise syntax for defining anonymous functions.

• Functional interfaces can have only one abstract method and are used for lambda expressions.

• Streams provide a way to process collections of objects in a functional style.

• Optional class helps to avoid NullPointerException by wrapping a value that may be null.
Answered by AI
Add your answer
Q4. CICD tools which we have used explain in high level
Ans. 
CICD tools automate the process of building, testing, and deploying code changes.
• Popular CICD tools include Jenkins, GitLab CI/CD, CircleCI, and Travis CI

• These tools help in automating the software development lifecycle

• They enable continuous integration, continuous delivery, and continuous deployment

• CICD tools help in improving code quality, reducing manual errors, and increasing development speed
Answered by AI
Add your answer
Q5. What is containerization
Ans. 
Containerization is a lightweight, portable, and self-sufficient way to package and run applications.
• Containerization involves encapsulating an application and its dependencies into a container image.

• Containers are isolated from each other and share the host OS kernel.

• Popular containerization platforms include Docker and Kubernetes.

• Containerization allows for easy deployment and scaling of applications.
Answered by AI
Add your answer
Q6. What is indexing in sql
Ans. 
Indexing in SQL is a technique used to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition in a query.

• They work similar to the index in a book, allowing the database to quickly locate the rows that satisfy the query.

• Indexes can be created using a single...read more
Answered by AI
Add your answer
Q7. Programming question on stream like finding the longest string in a given list of string
Add your answer

3 coding problems
1 aptitude
1 puzzle
3 hrs duration

Q1. Sorting algorithms
Add your answer
Q2. 1 puzzle - burning candles
Add your answer

Q1. General discussion on resume
Add your answer
Q2. Few reasoning questions
Add your answer

Q1. About company work culture
Add your answer

SQL , CODING QUESTION PYTHON

Q1. BASIC SQL QUESTIOS
Add your answer
Q2. OOPS 4 PILLARS INHERITANCE ETC
Add your answer

Q1. TELL ME ABOUT YOURSELF
Ans. 
I am a software developer with 5 years of experience in Java, Python, and SQL.
• 5 years of experience in Java, Python, and SQL

• Strong problem-solving skills

• Experience working in Agile development environment

• Familiarity with version control systems like Git

• Passionate about learning new technologies
Answered by AI
Add your answer
Q2. WHAT DO YOU KNOW ABOUT YOUR COMPANY
Ans. 
Company is a leading software development firm specializing in creating innovative solutions for various industries.
• Company has a strong reputation for delivering high-quality software products

• Specializes in creating custom solutions for clients in different industries

• Known for innovative and cutting-edge technology solutions

• Has a diverse portfolio of successful projects

• Company values teamwork and collaboration in thei
Answered by AI
Add your answer

Q1. Difference between linked list and array list
Ans. 
Linked list is a data structure where elements are stored in nodes with pointers to the next node. Array list is a dynamic array that can grow or shrink in size.
• Linked list allows for efficient insertion and deletion of elements anywhere in the list.

• Array list provides fast access to elements using index, but slower insertion and deletion compared to linked list.

• Example: Linked list - 1 -> 2 -> 3 -> 4 -> 5, Array list
Answered by AI
Add your answer
Q2. Difference between @controller and @ Rest controller
Ans. 
The @Controller annotation is used for traditional MVC controllers, while @RestController is used for RESTful web services.
• The @Controller annotation is used to define a class as a Spring MVC controller, which can handle HTTP requests and return a view.

• The @RestController annotation is used to define a class as a controller for RESTful web services, which can handle HTTP requests and return data in JSON or XML format.

• T...read more
Answered by AI
Add your answer

Q1. Can we call future method from batch class
Ans. 
Yes, future methods can be called from a batch class in Salesforce.
• Future methods can be called from batch classes to perform asynchronous processing.

• This can be useful for offloading long-running tasks to future methods to avoid hitting governor limits.

• Example: Calling a future method from a batch class to update records in Salesforce asynchronously.
Answered by AI
Add your answer
Q2. What's the use of @track decorator. Is it mandatory to explicitly use it? If yes, for which use case?
Ans. 
The @track decorator in Salesforce is used to track changes to a property in a Lightning web component.
• Used to make a property reactive and trigger re-renders when its value changes

• Not mandatory but recommended for properties that need to be reactive

• Use @track when you want changes to a property to be reflected in the UI
Answered by AI
Add your answer
Q3. When does APEX CPU Limit Exceeded error happens. What's the best practice to avoid getting this error?
Ans. 
APEX CPU Limit Exceeded error happens when code consumes too much CPU time. Best practices include optimizing code, reducing loops, and using asynchronous processing.
• Avoid using nested loops and optimize code for better performance

• Use asynchronous processing like @future or Queueable to offload CPU intensive tasks

• Limit the use of SOQL queries inside loops to reduce CPU consumption
Answered by AI
Add your answer
Q4. When does Mixed DML Exception occurs?
Ans. 
Mixed DML Exception occurs when DML operations are performed on setup and non-setup objects in a single transaction.
• Occurs when DML operations are performed on both setup and non-setup objects in a single transaction

• Setup objects include User, Profile, PermissionSet, etc.

• Non-setup objects include custom objects, standard objects like Account, Contact, etc.
Answered by AI
Add your answer
Q5. Debug the following code: var a=10; function abc() { console.log(a); var a=2; } abc();
Ans. 
The code will output 'undefined' because variable 'a' is hoisted within the function.
• Variable 'a' is hoisted to the top of the function scope, so when 'console.log(a)' is called, 'a' is undefined.

• To fix this, move the declaration of 'var a=2;' above the 'console.log(a);' statement.
Answered by AI
Add your answer
Q6. Write a SOQL query to fetch the values of description field from the Account. Why does "the description field cannot be filtered in the query call"?
Ans. 
SOQL query to fetch description field from Account and reason for inability to filter
• SOQL query: SELECT Description FROM Account

• Description field is not filterable because it is a long text field

• Long text fields cannot be filtered in SOQL queries
Answered by AI
Add your answer