Filter interviews by
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.
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
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
Rate your
company
🤫 100% anonymous
How was your last interview experience?
I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.
About general awareness about process
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,
OPK e Services interview questions for popular designations
I applied via Approached by Company and was interviewed before Nov 2022. There were 3 interview rounds.
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
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
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.
I applied via Referral and was interviewed before Sep 2021. There were 3 interview rounds.
Basic knowledge of html and css
I applied via Naukri.com and was interviewed before Feb 2022. There were 2 interview rounds.
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...
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
I applied via Referral and was interviewed before Feb 2022. There were 2 interview rounds.
Top trending discussions
The duration of OPK e Services interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 9 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 83 reviews
Rating in categories
1-2 Yrs
Not Disclosed
6-8 Yrs
Not Disclosed
Email Marketing Executive
54
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
25
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
20
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Team Leader
13
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech