Paytm Payments Bank
10+ Snapdeal Interview Questions and Answers
Q1. What is Money laundering and it's process What do you understand by Aml What is Kyc and documents of KYC Transaction monitoring,FATCA , SAR Etc
Q2. 2. What experience do you have working on SQL, Excel
I have extensive experience working on SQL and Excel.
Proficient in writing complex SQL queries for data extraction and manipulation
Expertise in data analysis and visualization using Excel
Experience in creating dashboards and reports using Excel
Familiarity with advanced Excel functions such as VLOOKUP, Pivot tables, etc.
Q3. What is port no of POP SMTP and DNs dhcp
Q4. 2. When do you use where clause/ having Clause
Where clause is used to filter rows based on a condition, while having clause is used to filter groups based on a condition.
Where clause is used with SELECT, UPDATE, DELETE statements.
Having clause is used with GROUP BY clause.
Where clause filters rows before grouping, while having clause filters groups after grouping.
Where clause can use any comparison operator, while having clause can only use aggregate functions.
Example: SELECT * FROM table WHERE column = 'value';
Example: ...read more
Q5. What is IMAC and Ticketing tool
Q6. 3. Order of execution of an SQL statement
SQL statements are executed in a specific order to ensure accuracy and efficiency.
FROM and JOIN clauses are executed first to retrieve data from tables
WHERE clause is executed next to filter the data
SELECT clause is executed to retrieve specific columns
GROUP BY clause is executed to group the data based on specified columns
HAVING clause is executed to filter the grouped data
ORDER BY clause is executed to sort the data
LIMIT clause is executed to limit the number of rows return...read more
Q7. 1. Tell me about different type of joins
Different types of joins are inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables
Left join returns all the rows from the left table and matching rows from the right table
Right join returns all the rows from the right table and matching rows from the left table
Full outer join returns all the rows from both tables, with NULL values in the columns where there is no match
Join types can be specified using keywords such a...read more
Q8. Hoe many tickets you are doing per day.
Q9. What is DNS and wsus.
Q10. What is Keychain.
Q11. What does mean by IAM
Top HR Questions asked in Snapdeal
Interview Process at Snapdeal
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month