Times Internet Interview Questions, Process, and Tips

I was asked to write a simple assignment.

Q1. I was asked about my past experience.
Add your answer

Q1. Write a SQL query to find all duplicate emails in a table named person
Ans. 
SQL query to find duplicate emails in a table named person
• Use GROUP BY and HAVING clause to group emails and count their occurrences

• Select only those emails which have count greater than 1

• Example: SELECT email, COUNT(*) FROM person GROUP BY email HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Given a weather table, write a sql query to find all date's ids with higher temperature compared to it's previous dates
Ans. 
SQL query to find date ids with higher temperature compared to previous dates in weather table
• Use self join to compare temperature of current date with previous dates

• Order the table by date to ensure correct comparison

• Select date ids where temperature is higher than previous dates
Answered by AI
Add your answer

Easy to medium-level coding questions on DSA

Q1. DSA question along with basic java needs
Add your answer
Q2. Create custom linked list
Ans. 
A custom linked list is a data structure where each node contains a value and a reference to the next node.
• Define a Node class with value and next properties

• Define a LinkedList class with head property and methods to add, remove, and traverse nodes

• Example: let list = new LinkedList(); list.add(1); list.add(2); list.remove(1);
Answered by AI
Add your answer

Q1. Of an elevator and some questions on how to implement it with some scenarios
Add your answer

Q1. How will you deliver revenue
Ans. 
I will deliver revenue by building strong relationships with clients, identifying their needs, and providing tailored solutions.
• Developing and maintaining relationships with existing clients to upsell and cross-sell products/services

• Identifying new business opportunities and pitching products/services to potential clients

• Analyzing market trends and competitor activities to adjust sales strategies accordingly

• Collaborati...read more
Answered by AI
Add your answer
Q2. What contacts do you have
Add your answer

Q1. The questions depends on the department and the roles and responsibilities.
Add your answer

Q1. The questions depends on the department and the roles and responsibilities.
Add your answer

Q1. These depends on the roles and responsibilities assigned to you.
Add your answer

Q1. The questions depends on the roles and responsibilities.
Add your answer

Q1. How skilled are you with MS Excel?
Add your answer