AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
OPK e Services Interview Questions, Process, and Tips
Top OPK e Services Interview Questions and Answers
- Q1. What is union and union all?asked in Email Marketing Executive interview
- Q2. What is delete and truncate?asked in Email Marketing Executive interview
- Q3. Do you know html cssasked in Email Marketing Executive interview
OPK e Services Interview Experiences
10 interviews found
Anonymous
Selected
I applied via Indeed and was interviewed in May 2024. There were 2 interview rounds.
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.
(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
- 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
Interview Preparation Tips
Skills evaluated in this interview
Email Marketing Executive Interview Questions asked at other Companies
komal sisodia
I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Introduction and experience
- Q2. Salary expection
Interview Preparation Tips
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
About general awareness about process
Senior Immigration Consultant Interview Questions asked at other Companies
Selected
I applied via Approached by Company and was interviewed in Jul 2023. There were 2 interview rounds.
EXCEL TEST , DATA ANALYSIS USING EXCEL
SQL - 1 HRS , BASIC FUNCTIONS , GROUP BY , ORDER BY CLAUSES,
Team Lead Interview Questions asked at other Companies
OPK e Services interview questions for popular designations
Selected
I applied via Approached by Company and was interviewed before Nov 2022. There were 3 interview rounds.
(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
(1 Question)
- Q1. Technical interview based on queries
Skills evaluated in this interview
Email Marketing Executive Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Mar 2022. There were 3 interview rounds.
About your qualifications and skills
Basic knowledge of html and css
Interview Preparation Tips
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
Jobs at OPK e Services
I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.
Sql queries related to all the functoons and joins.
(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
Email Marketing Executive Interview Questions asked at other Companies
I applied via Referral and was interviewed before Sep 2021. There were 3 interview rounds.
Basic knowledge of html and css
(2 Questions)
- Q1. Talk about Introduction
- Q2. Skill knowledge and experience
Interview Preparation Tips
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. ...
Selected
I applied via Naukri.com and was interviewed before Feb 2022. There were 2 interview rounds.
(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...
- 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
Interview Preparation Tips
Skills evaluated in this interview
Email Marketing Executive Interview Questions asked at other Companies
Selected
I applied via Referral and was interviewed before Feb 2022. There were 2 interview rounds.
(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
Process Associate Interview Questions asked at other Companies
OPK e Services Interview FAQs
The duration of OPK e Services interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
OPK e Services Interviews By Designations
Interview Questions for Popular Designations
- Email Marketing Executive Interview Questions
- Design Engineer Interview Questions
- Senior Associate Interview Questions
- Senior Engineer Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- System Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Show more
OPK e Services Interview Process
based on 10 interviews
Interview experience
Interview Questions from Similar Companies
OPK e Services Reviews and Ratings
based on 86 reviews
Rating in categories
|
Email Marketing Executive
57
salaries
|  ₹1.8 L/yr - ₹5.8 L/yr |
|
Senior Executive
24
salaries
| ₹3 L/yr - ₹6 L/yr |
|
Executive
20
salaries
| ₹1.9 L/yr - ₹4.5 L/yr |
|
Data Analyst
15
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Assistant Team Leader
13
salaries
| ₹6 L/yr - ₹7.2 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- OPK e Services Interview Questions
