OPK e Services Email Marketing Executive Interview Questions, Process, and Tips

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.

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
Add your answer
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
Add your answer

Q1. Sql questions and queries will be there
Add your answer
Q2. All basic queries and constraints
Add your answer
Q3. Joins questions
Add your answer
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
Add your answer

Q1. Technical interview based on queries
Add your answer

About your qualifications and skills

Basic knowledge of html and css

Sql queries related to all the functoons and joins.

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