Publicis PHP Developer Interview Questions and Answers

In aptitude test,there is multiple questions are there in subject wise and reasoning,and subtopics like ages,clocks, distance like these types questions are there and java problem questions also there

Q1. In technical round mainly asked about your project and so many questions are asked in Java,sql and javascript
Add your answer
Q2. Oops in Java Patterns in Java JDK,JRE,JVM MVC Array questions strings in Java This,super keywords Java problems like palindrome, prime number,and so many problems and logics Why java is platform independen...read more
Ans. 
Questions asked in a Full Stack Software Developer interview
• Questions on OOPs concepts, design patterns, and MVC architecture

• Array and string manipulation in Java

• Understanding of JDK, JRE, and JVM

• Usage of 'this' and 'super' keywords

• Solving Java problems like palindrome, prime number, etc.

• Explanation of Java's platform independence

• SQL queries and commands
Answered by AI
Add your answer
Q3. MVC in Java Design patterns in Java
Ans. 
MVC is a design pattern used in Java for separating concerns. Java has many design patterns like Singleton, Factory, etc.
• MVC separates Model, View, and Controller for better organization and maintenance

• Singleton ensures only one instance of a class is created

• Factory pattern creates objects without exposing the instantiation logic to the client

• Observer pattern allows objects to be notified of changes in other objects

• Dec...read more
Answered by AI
Add your answer
Q4. Explain Jdbc connectivity Spring boot
Ans. 
JDBC is a Java API for connecting to databases. Spring Boot provides auto-configuration for JDBC.
• JDBC stands for Java Database Connectivity.

• It is a Java API for connecting to databases.

• Spring Boot provides auto-configuration for JDBC, making it easy to set up database connections.

• JDBC can be used to execute SQL statements and retrieve results.

• Example: DriverManager.getConnection(url, username, password);
Answered by AI
Add your answer

Q1. Hr asked only for your background and life styles and some basic questions about company
Add your answer

Q1. Sql all basic including performance tuning
Add your answer
Q2. Ssis or ETL individual blocks details
Add your answer
Q3. Also prepare Power BI interview questions, it will be an additional
Add your answer

Q1. DSA easy-medium
Add your answer
Q2. HTTP/HTTPS, web fundamentals
Add your answer

Q1. DSA medium (array, two pointer based)
Add your answer
Q2. Project based questions were asked
Add your answer
Q3. DSA easy - medium on string
Add your answer

Q1. Different between rank and dense_rank
Ans. 
Rank assigns unique rank to each row, while dense_rank assigns consecutive rank to each row.
• Rank function assigns unique rank to each row based on the order specified in the ORDER BY clause.

• Dense_rank function assigns consecutive rank to each row based on the order specified in the ORDER BY clause.

• Rank function leaves gaps in the ranking sequence if there are ties, while dense_rank function does not.

• Rank function retur...read more
Answered by AI
Add your answer

Normal aptitude and coding test of 180 minutes with 25 aptitude question and 2 dsa question

Dsa coding round with most of the question wich are on leetcode

Dsa coding round with moderate dsa questions

Two question of easy level dsa mainly based on array, string manipulation.

Q1. Prepare well for dsa in this round. Three to four question of easy level will be asked but also know how to optimise the code this is must you should now to make a good impression start with brute force th...read more
Add your answer

Q1. Not yet done so i will answer this afterward sorry for that
Add your answer