Publicis Sapient Associate Qa 1 Interview Questions and Answers

Q1. Tell me about urslef
Ans. 
I am a dedicated and hardworking individual with a passion for learning and helping others.
• I have a background in marketing and have worked in the industry for 5 years.

• I am currently pursuing a degree in business administration to further my career.

• I enjoy volunteering at local charities and giving back to the community.
Answered by AI
Add your answer
Q2. What do u want to become in next 5 years
Ans. 
In the next 5 years, I aim to progress to a managerial role within the company, utilizing my skills and experience to lead a team towards success.
• Continue to excel in my current role and take on additional responsibilities

• Seek out opportunities for leadership training and development

• Build strong relationships with colleagues and mentors for guidance and support

• Set clear goals and milestones to track my progress towards
Answered by AI
Add your answer

Q1. Brief about your previous experience
Add your answer
Q2. How to delete duplicate records from table
Ans. 
Use DELETE statement with a self-join on the table to remove duplicate records.
• Identify the columns that define a duplicate record

• Use a self-join to identify the duplicate records

• Use DELETE statement with the self-join condition to remove the duplicates
Answered by AI
Add your answer

Q1. Questions on switching
Add your answer
Q2. Packet flow in routers, osi model , etc
Ans. 
Packet flow in routers involves data transmission through different layers of the OSI model.
• Packet flow starts at the network layer where packets are routed based on IP addresses.

• Packets then move to the data link layer where MAC addresses are used for communication.

• Finally, packets are transmitted physically through the network interface.

• OSI model consists of 7 layers: Physical, Data Link, Network, Transport, Session,
Answered by AI
Add your answer

Q1. Coding knowledge in python
Add your answer
Q2. Bdd writing and API testing
Add your answer

Write test cases on Camera

Q1. Database question
Add your answer
Q2. Inner join, constraint
Add your answer

Q1. Some JavaScript based question's
Add your answer
Q2. And, client round where will ask some scenario based question's
Add your answer