Upload Button Icon Add office photos

Filter interviews by

OPK e Services Interview Questions, Process, and Tips

Updated 18 Nov 2024

Top OPK e Services Interview Questions and Answers

OPK e Services Interview Experiences

Popular Designations

10 interviews found

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

I applied via Indeed and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Assignment 

So in the first round they will give you assignment related to SQL..You need to know SQL very well. Like joins, Functions, window function etc.

Round 2 - Technical 

(2 Questions)

  • Q1. What is union and union all?
  • Ans. 

    UNION and UNION ALL are SQL commands used to combine the result sets of two or more SELECT statements.

    • UNION removes duplicate rows from the combined result set

    • UNION ALL does not remove duplicate rows

    • Both commands require that the number of columns in each SELECT statement must be the same

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FRO

  • Answered by AI
  • Q2. What is delete and truncate?
  • Ans. 

    Delete and truncate are SQL commands used to remove data from a table, but with different implications.

    • DELETE is a DML command used to remove specific rows from a table without affecting the table structure

    • TRUNCATE is a DDL command used to remove all rows from a table, resetting the table to its initial state

    • DELETE can be rolled back, while TRUNCATE cannot be rolled back

    • DELETE triggers the delete trigger, while TRUNCAT

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please Learn Intermediate SQL. Because Sql is very important in all roles related Data Analysis. No need to be advance but know all the basic things..

Skills evaluated in this interview

Email Marketing Executive Interview Questions asked at other Companies

Q1. If someone is expert in bringing leads for USA or UK, he/she indulged in just bringing leads for that country.
View answer (1)

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview

Associate Interview Questions & Answers

user image komal sisodia

posted on 26 Jun 2024

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Introduction and experience
  • Q2. Salary expection

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't work here please
They don't have manners how to talk and even they think there company is very huge and they are like mnc but it is very small company

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR & why required for powder coating process ?
View answer (17)
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

About general awareness about process

Senior Immigration Consultant Interview Questions asked at other Companies

Q1. If you are not getting enough sales through dialing what else via you will utilize for bringing up sales?
View answer (1)

Team Lead Interview Questions & Answers

user image Anonymous

posted on 31 Jan 2024

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

EXCEL TEST , DATA ANALYSIS USING EXCEL

Round 2 - Coding Test 

SQL - 1 HRS , BASIC FUNCTIONS , GROUP BY , ORDER BY CLAUSES,

Team Lead Interview Questions asked at other Companies

Q1. write a java program to get maxing profit by buying and selling a share from a given set of values (they will change the question after you give solution, like if consider buying only once and selling once they will say to buying multiple t... read more
View answer (3)

OPK e Services interview questions for popular designations

 Email Marketing Executive

 (5)

 Process Associate

 (1)

 Senior Immigration Consultant

 (1)

 Team Lead

 (1)

 Associate

 (1)

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 Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all Resume tips
Round 2 - Technical 

(4 Questions)

  • Q1. Sql questions and queries will be there
  • Q2. All basic queries and constraints
  • Q3. Joins questions
  • Q4. All type of SQLqueries
  • Ans. 

    SQL queries are used to retrieve and manipulate data in databases.

    • SELECT statement is used to retrieve data from a database

    • UPDATE statement is used to modify existing records in a database

    • INSERT INTO statement is used to insert new records into a database

    • DELETE statement is used to delete records from a database

    • JOIN statement is used to combine rows from two or more tables based on a related column

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Technical interview based on queries

Skills evaluated in this interview

Email Marketing Executive Interview Questions asked at other Companies

Q1. If someone is expert in bringing leads for USA or UK, he/she indulged in just bringing leads for that country.
View answer (1)

I applied via LinkedIn and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Case Study 

About your qualifications and skills

Round 3 - Coding Test 

Basic knowledge of html and css

Interview Preparation Tips

Interview preparation tips for other job seekers - Market yourself. ...
Apply even if you're not fully qualified. ...
Job search like it's your job. ...
Use informational interviews to network. ...
Set yourself apart with letters of recommendation. ...

Email Marketing Executive Interview Questions asked at other Companies

Q1. If someone is expert in bringing leads for USA or UK, he/she indulged in just bringing leads for that country.
View answer (1)

I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Assignment 

Sql queries related to all the functoons and joins.

Round 2 - Technical 

(1 Question)

  • Q1. Asked about flow of sql queries, what is self join and how you can use self join toh optimize query

Interview Preparation Tips

Interview preparation tips for other job seekers - Get as much knowledge of sql queries and advance excel if you are applying for this job.

Email Marketing Executive Interview Questions asked at other Companies

Q1. If someone is expert in bringing leads for USA or UK, he/she indulged in just bringing leads for that country.
View answer (1)

Interview Questions & Answers

user image Anonymous

posted on 25 Sep 2022

I applied via Referral and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

Basic knowledge of html and css

Round 3 - HR 

(2 Questions)

  • Q1. Talk about Introduction
  • Q2. Skill knowledge and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Please Market yourself. ...
Apply even if you're not fully qualified. ...
Job search like it's your job. ...
Use informational interviews to network. ...
Set yourself apart with letters of recommendation. ...
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am an experienced Email Marketing Executive with a strong background in creating effective email campaigns and driving customer engagement.

    • I have successfully managed email marketing campaigns for various clients, resulting in increased open rates and click-through rates.

    • I am skilled in creating compelling email content that resonates with the target audience and drives conversions.

    • I have a deep understanding of emai...

  • Answered by AI
  • Q2. Do you know html css
  • Ans. 

    Yes, I am proficient in HTML and CSS.

    • Proficient in writing clean and efficient HTML code

    • Skilled in styling web pages using CSS

    • Experience in creating responsive designs using CSS frameworks like Bootstrap

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - No advice just keep the bootlicking game on. No matter wat u do, they will always find faults and if u won't make any error they will just blame you and put their own mistakes burden on u..

Skills evaluated in this interview

Email Marketing Executive Interview Questions asked at other Companies

Q1. If someone is expert in bringing leads for USA or UK, he/she indulged in just bringing leads for that country.
View answer (1)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Asks about work experience. Asks about the future plans.
  • Q2. Asks to take a call to judge how you sounds over the call.

Interview Preparation Tips

Interview preparation tips for other job seekers - It is a very good company to work with. Good environment and good work culture.

Process Associate Interview Questions asked at other Companies

Q1. How will you explain a red colour (or any colour) to a person who is blind since his or her birth?
View answer (21)
Contribute & help others!
anonymous
You can choose to be anonymous

OPK e Services Interview FAQs

How many rounds are there in OPK e Services interview?
OPK e Services interview process usually has 2-3 rounds. The most common rounds in the OPK e Services interview process are Resume Shortlist, HR and Technical.
How to prepare for OPK e Services 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 OPK e Services. The most common topics and skills that interviewers at OPK e Services expect are Email Marketing, SQL, SEO, Python and SEM.
What are the top questions asked in OPK e Services interview?

Some of the top questions asked at the OPK e Services interview -

  1. What is union and union a...read more
  2. What is delete and trunca...read more
  3. Do you know html ...read more
How long is the OPK e Services interview process?

The duration of OPK e Services interview process can vary, but typically it takes about less than 2 weeks to complete.

Recently Viewed

COMPANY BENEFITS

UGC Supply Chain Solutions

No Benefits

DESIGNATION

REVIEWS

OPK e Services

No Reviews

REVIEWS

OPK e Services

No Reviews

REVIEWS

OPK e Services

No Reviews

REVIEWS

OPK e Services

No Reviews

REVIEWS

OPK e Services

No Reviews

SALARIES

OPK e Services

REVIEWS

OPK e Services

No Reviews

SALARIES

Rigas Technologies

No Salaries

Tell us how to improve this page.

OPK e Services Interview Process

based on 9 interviews

Interview experience

3.3
  
Average
View more

Anonymously discuss salaries, work culture, and many more

Get Ambitionbox App

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
Data Entry Interview Questions
4.1
 • 97 Interviews
View all

OPK e Services Reviews and Ratings

based on 83 reviews

3.3/5

Rating in categories

2.9

Skill development

3.3

Work-life balance

3.2

Salary

3.2

Job security

3.3

Company culture

3.0

Promotions

3.1

Work satisfaction

Explore 83 Reviews and Ratings
Email Marketing Executive
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Team Leader
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare OPK e Services with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview