Publicis Sapient Senior Manager Technology Interview Questions and Answers

Q1. What is rdbms in sql
Ans. 
RDBMS stands for Relational Database Management System in SQL.
• RDBMS is a type of database management system that stores data in a structured format using rows and columns.

• It allows users to establish relationships between different data sets.

• SQL (Structured Query Language) is commonly used to interact with RDBMS.

• Examples of RDBMS in SQL include MySQL, Oracle, and SQL Server.
Answered by AI
Add your answer
Q2. What is polymorphism
Ans. 
Polymorphism is the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to represent multiple data types.

• Examples include method overloading and method overriding in object-oriented programming.
Answered by AI
Add your answer

Q1. 1. Current Project architecture 2. How do you design micro services to scalable 3. How do you ensure ci/cd working as expected 4. What is oauth 5. Which Authorization servers you worked
Ans. 
Answering questions related to current project architecture, designing scalable micro services, ensuring CI/CD, OAuth, and authorization servers.
• Current project architecture involves a detailed analysis of the existing system, identifying key components, and designing a scalable solution.

• Designing micro services to be scalable requires breaking down the application into smaller, independent services that can be easily ...read more
Answered by AI
Add your answer

Q1. What is a trigger
Ans. 
A trigger is an event or condition that initiates a specific action or process.
• Triggers are commonly used in programming and databases.

• They can be used to automate tasks or initiate processes based on certain conditions.

• Examples include a trigger that sends an email when a new user registers on a website, or a trigger that updates a database record when a certain field is changed.

• Triggers can also be used in marketing ...read more
Answered by AI
Add your answer
Q2. What is right outer join
Ans. 
Right outer join returns all records from the right table and matching records from the left table.
• It includes all the records from the right table and only matching records from the left table.

• If there is no match in the left table, the result will contain NULL values.

• It is denoted by RIGHT OUTER JOIN or RIGHT JOIN keyword in SQL.

• Example: SELECT * FROM right_table RIGHT JOIN left_table ON right_table.id = left_table.i
Answered by AI
Add your answer
Q3. What are types in Oracle
Ans. 
Types in Oracle are data types that define the type of data that can be stored in a column or variable.
• Oracle has several built-in data types such as NUMBER, VARCHAR2, DATE, and CLOB.

• NUMBER is used to store numeric values, VARCHAR2 is used to store character strings, DATE is used to store dates and times, and CLOB is used to store large character strings.

• Oracle also supports user-defined data types, which can be create...read more
Answered by AI
Add your answer
Q4. What is an array type
Ans. 
An array type is a data type that stores a collection of elements of the same data type in a contiguous memory location.
• Arrays can be one-dimensional or multi-dimensional

• Elements in an array can be accessed using an index

• Arrays can be initialized with a fixed size or dynamically resized

• Examples of array types include int[], double[], and string[]
Answered by AI
Add your answer

Q1. About yourself and last company
Add your answer

Q1. Technical stack worked upon, explain current project architecture, pillers of software architecture , How do you implement security in your project
Add your answer

Q1. Singleton Pattern
Add your answer
Q2. SOLID Principles
Add your answer

Basic technical questions

Q1. Exepected salary?
Add your answer