Pressman Advertising Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a recent graduate with a degree in Computer Science and a passion for coding and problem-solving.
• Recent graduate with a degree in Computer Science

• Passionate about coding and problem-solving

• Experience with programming languages such as Java, Python, and C++

• Completed internships at tech companies like Google and Microsoft
Answered by AI
Add your answer
Q2. Tell me about your education baground
Ans. 
I have a Bachelor's degree in Computer Science with a focus on software development.
• Bachelor's degree in Computer Science

• Focus on software development

• Completed relevant coursework in algorithms, data structures, and programming languages
Answered by AI
Add your answer
Q3. What programming languages are you good at
Ans. 
I am proficient in Java, Python, and SQL.
• Java

• Python

• SQL
Answered by AI
Add your answer

Q1. No qualifications were discussed, more personal details were asked
Add your answer

It was a 100-minute test consisting of mcqs and one coding question on articulation points in the graph.

Q1. What is the difference between Postgresql and MySQL?
Ans. 
Postgresql is known for its advanced features and support for complex queries, while MySQL is popular for its ease of use and speed.
• Postgresql is known for its advanced features such as support for complex queries, indexing, and JSON data types.

• MySQL is popular for its ease of use, speed, and compatibility with various platforms.

• Postgresql has a strong focus on standards compliance and extensibility, while MySQL is mor...read more
Answered by AI
Add your answer
Q2. What are ACID properties in DBMS?
Ans. 
ACID properties in DBMS ensure data integrity and consistency in transactions.
• Atomicity: All operations in a transaction are completed successfully or none at all.

• Consistency: Data is always in a valid state before and after a transaction.

• Isolation: Transactions are executed independently without interference from other transactions.

• Durability: Once a transaction is committed, changes are permanent and cannot be lost.

• E...read more
Answered by AI
Add your answer

Q1. Are you planning pregnancy?
Ans. 
It is not appropriate to ask about pregnancy in a job interview as it is a personal matter.
• Politely redirect the conversation back to your qualifications and experience

• Explain that personal matters such as family planning are not relevant to the job

• Express that you are focused on your career and committed to your work
Answered by AI
Add your answer
Q2. Are you comfortable working late nights?
Add your answer

Q1. SQL Window Functions and RANK, DENSE RANK Difference
Ans. 
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
• RANK function assigns a unique rank to each distinct row within a partition.

• DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

• Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
Answered by AI
Add your answer
Q2. Hadoop Default Replication Factor
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced performance marketing manager with a proven track record of driving successful campaigns and maximizing ROI.
• Over 5 years of experience in performance marketing

• Proficient in utilizing various digital marketing channels such as PPC, SEO, and social media advertising

• Strong analytical skills to track and optimize campaign performance

• Managed budgets effectively to achieve desired results

• Previously increased conv
Answered by AI
Add your answer
Q2. Attribution models in Google ads?
Ans. 
Attribution models in Google Ads determine how credit for conversions is assigned to different touchpoints in a customer's journey.
• Common attribution models include last click, first click, linear, time decay, and position-based.

• Each model has its own way of assigning credit to touchpoints based on their position in the customer journey.

• For example, the last click model gives all credit for a conversion to the last tou...read more
Answered by AI
Add your answer
Q3. Define Ad Rank?
Ans. 
Ad Rank is a value used to determine the position of an ad on a search engine results page.
• Ad Rank is calculated based on the bid amount, ad quality, and ad extensions.

• Higher Ad Rank increases the chances of an ad being shown in a higher position.

• Ad Rank formula: Ad Rank = Bid Amount x Quality Score + Ad Extension Impact.

• Example: An ad with a high bid amount, good quality score, and relevant ad extensions will have a h
Answered by AI
Add your answer

String Array manipulation

Q1. Different activity launch modes, services, intent-services
Ans. 
Different launch modes control how activities are launched, services run in the background, and intent-services handle asynchronous tasks.
• Launch modes include standard, singleTop, singleTask, and singleInstance

• Services are used for long-running operations in the background

• Intent-services are used for handling asynchronous tasks on a separate worker thread
Answered by AI
Add your answer
Q2. Normal android sdk related questions and about third party libraries
Add your answer

Q1. Interview with India Director
Add your answer

Q1. Let me know about yourself
Add your answer
Q2. Normal queries about you
Add your answer

Q1. Do u know video editing
Ans. 
Yes, I have experience with video editing using tools like Adobe Premiere Pro and Final Cut Pro.
• Proficient in using video editing software such as Adobe Premiere Pro and Final Cut Pro

• Experience in editing videos for various projects including short films, promotional videos, and social media content

• Knowledge of video effects, transitions, color correction, and audio editing

• Familiarity with video formats and exporting o
Answered by AI
Add your answer
Q2. Do u know image processing
Ans. 
Yes, I have experience with image processing in Python.
• I have used libraries like OpenCV and PIL to manipulate and analyze images.

• I have worked on tasks like image enhancement, object detection, and image segmentation.

• I am familiar with techniques like edge detection, image filtering, and feature extraction.

• I have implemented image processing algorithms for various projects.

• I have experience with handling different ima...read more
Answered by AI
Add your answer