Publicis Msbi 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

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

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

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

Questions related to trees and bst

Q1. Check the suduko valid or not
Add your answer
Q2. Detect loop in the linked list
Ans. 
Detect loop in a linked list by using Floyd's cycle detection algorithm.
• Use two pointers, slow and fast, to traverse the linked list.

• If there is a loop, the fast pointer will eventually meet the slow pointer.

• Example: 1->2->3->4->5->2 (loop back to 2), slow and fast pointers will meet at node 2.
Answered by AI
Add your answer

Q1. What is HTML Full form

Ans. 

Hypertext Markup Language

• HTML stands for Hypertext Markup Language

• It is the standard markup language for creating web pages

• HTML elements are represented by tags enclosed in angle brackets, like

Add your answer