Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Publicis

Compare button icon Compare button icon Compare
3.7

based on 307 Reviews

Filter interviews by

Publicis Database Developer Interview Questions and Answers

Updated 25 Apr 2021

Publicis Database Developer Interview Experiences

1 interview found

Database Developer Interview Questions & Answers

user image Anonymous

posted on 25 Apr 2021

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Joins,bulk collect, procedure, function
    • Add your answer
  • Q2. Write a procedure with bulk collect
  • Ans. 

    Procedure with bulk collect for array of strings

    • Use FORALL statement for efficient processing

    • Declare a collection type

    • Use LIMIT clause to control memory usage

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Read all the basic and advanced plsql

Top trending discussions

View All
Interview Tips & Stories
1w
honestword
·
ex -
Oxane Partners
Disappointing Interview Experience with D.E. Shaw
I recently interviewed with D.E. Shaw, and it turned out to be one of the most draining experiences I’ve had. The interviewer’s approach felt unnecessarily harsh and dismissive, which made the entire process uncomfortable. At multiple points, the interviewer asked me to drop off the call, even when I tried asking basic questions about the designation, job description, and other details. After the interview, I found myself sitting there for a few minutes, trying to process what just happened. It left me questioning the overall tone and professionalism of the interview. Definitely not the experience I was expecting from such a well-known firm.
Got a question about Publicis?
Ask anonymously on communities.

Interview questions from similar companies

Database Developer Interview Questions & Answers

Media.net Software Services (India) user image Anonymous

posted on 27 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Second highest Salary
  • Ans. 

    To find the second highest salary in a database table, you can use a SQL query with the ORDER BY and LIMIT clauses.

    • Use a SQL query with ORDER BY clause to sort the salaries in descending order.

    • Use LIMIT 1,1 to retrieve the second highest salary.

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;

    • Answered by AI
    Add your answer
  • Q2. Left and right join explanation
  • Ans. 

    Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table.

    • Left join: Returns all records from the left table and the matched records from the right table.

    • Right join: Returns all records from the right table and the matched records from the left table.

    • Example: Left join - SELECT * FROM table1...

    • Answered by AI
    Add your answer
Round 2 - Technical 

(2 Questions)

  • Q1. Question on Binary Search tree
    • Add your answer
  • Q2. One easy array question
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql questions and basics of DBMS

Skills evaluated in this interview

Database Developer Interview Questions & Answers

Media.net Software Services (India) user image Anonymous

posted on 24 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Whar are the different forms of normalization?
  • Ans. 

    Normalization is a process used to organize a database into tables and columns to reduce redundancy and improve data integrity.

    • First Normal Form (1NF) - Eliminates duplicate data by ensuring each column contains atomic values.

    • Second Normal Form (2NF) - Requires that each non-key attribute is fully functionally dependent on the primary key.

    • Third Normal Form (3NF) - Ensures that non-key attributes are not transitively de...

    • Answered by AI
    Add your answer
  • Q2. What are indexes and how indexing is useful?
  • Ans. 

    Indexes in databases are data structures that improve the speed of data retrieval operations.

    • Indexes are data structures that store a small portion of the table data in an optimized format for quick retrieval.

    • They help in speeding up data retrieval operations such as SELECT queries by reducing the number of rows that need to be scanned.

    • Indexes can be created on one or more columns of a table to improve the performance ...

    • Answered by AI
    Add your answer
  • Q3. Some logical mathematical questions!
    • Add your answer

Interview Preparation Tips

Topics to prepare for Media.net Software Services (India) Database Developer interview:
  • SQL
  • RDBMS
  • Normalization
  • Indexing
  • Logical reasoning

Database Developer Interview Questions & Answers

Media.net Software Services (India) user image Anonymous

posted on 27 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Second highest Salary
  • Ans. 

    To find the second highest salary in a database table, you can use a SQL query with the ORDER BY and LIMIT clauses.

    • Use a SQL query with ORDER BY clause to sort the salaries in descending order.

    • Use LIMIT 1,1 to retrieve the second highest salary.

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;

    • Answered by AI
    Add your answer
  • Q2. Left and right join explanation
  • Ans. 

    Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table.

    • Left join: Returns all records from the left table and the matched records from the right table.

    • Right join: Returns all records from the right table and the matched records from the left table.

    • Example: Left join - SELECT * FROM table1...

    • Answered by AI
    Add your answer
Round 2 - Technical 

(2 Questions)

  • Q1. Question on Binary Search tree
    • Add your answer
  • Q2. One easy array question
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql questions and basics of DBMS

Skills evaluated in this interview

Database Developer Interview Questions & Answers

Media.net Software Services (India) user image Anonymous

posted on 24 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Whar are the different forms of normalization?
  • Ans. 

    Normalization is a process used to organize a database into tables and columns to reduce redundancy and improve data integrity.

    • First Normal Form (1NF) - Eliminates duplicate data by ensuring each column contains atomic values.

    • Second Normal Form (2NF) - Requires that each non-key attribute is fully functionally dependent on the primary key.

    • Third Normal Form (3NF) - Ensures that non-key attributes are not transitively de...

    • Answered by AI
    Add your answer
  • Q2. What are indexes and how indexing is useful?
  • Ans. 

    Indexes in databases are data structures that improve the speed of data retrieval operations.

    • Indexes are data structures that store a small portion of the table data in an optimized format for quick retrieval.

    • They help in speeding up data retrieval operations such as SELECT queries by reducing the number of rows that need to be scanned.

    • Indexes can be created on one or more columns of a table to improve the performance ...

    • Answered by AI
    Add your answer
  • Q3. Some logical mathematical questions!
    • Add your answer

Interview Preparation Tips

Topics to prepare for Media.net Software Services (India) Database Developer interview:
  • SQL
  • RDBMS
  • Normalization
  • Indexing
  • Logical reasoning
More about working at Publicis

Publicis Interview FAQs

How to prepare for Publicis Database Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Publicis. The most common topics and skills that interviewers at Publicis expect are Agile, SDLC, Shell Scripting, CRM and Application Development.
What are the top questions asked in Publicis Database Developer interview?

Some of the top questions asked at the Publicis Database Developer interview -

  1. Write a procedure with bulk coll...read more
  2. Joins,bulk collect, procedure, funct...read more

Tell us how to improve this page.

Publicis Interviews By Designations

Interview Questions for Popular Designations

People are getting interviews through

based on 1 Publicis interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Accenture Interview Questions
3.9
 • 7.9k Interviews
R.R. Donnelley Interview Questions
4.0
 • 97 Interviews
Media.net Software Services (India) Interview Questions
3.5
 • 68 Interviews
Regalix Interview Questions
2.9
 • 43 Interviews
Xdbs Interview Questions
3.2
 • 37 Interviews
Affinity Express Interview Questions
3.1
 • 34 Interviews
Smollan Group Interview Questions
4.2
 • 33 Interviews
Groupm Media Interview Questions
4.0
 • 33 Interviews
Mediamint Interview Questions
3.5
 • 32 Interviews
Dentsu Aegis Network Interview Questions
3.4
 • 30 Interviews
View all

Fast track your campus placements

Fr Conceicao Rodrigues College of Engineering, Mumbai Placement Questions
1 Interview
View all
Publicis Salaries in India
Associate Manager
232 salaries
unlock blur

₹6 L/yr - ₹14.4 L/yr

Senior Associate
148 salaries
unlock blur

₹6 L/yr - ₹24.6 L/yr

Business Manager
147 salaries
unlock blur

₹7 L/yr - ₹18 L/yr

Analyst
118 salaries
unlock blur

₹3.2 L/yr - ₹9 L/yr

Associate
118 salaries
unlock blur

₹3.2 L/yr - ₹12.8 L/yr

Explore more salaries
Compare Publicis with

WPP

3.2
Compare

Interpublic Group

3.7
Compare

Accenture

3.9
Compare

M&C Saatchi Performance

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview