Sagent Interview Questions and Answers

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
Add your answer
Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
Ans. 
The query selects all columns and calculates the total amount for each customer in table t2.
• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partiti...read more
Answered by AI
Add your answer
Q3. How many Customers has purchased same item on the Same day more than onnce
Ans. 
To find customers who purchased the same item multiple times on the same day.
• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Answered by AI
Add your answer

Q1. Questions related to Java versions. System design, Kafka and rabbit mq
Add your answer

Q1. Some more questions on system design. Questions on Messaing system, EDA and Microservices architecture. AWS cloud.
Add your answer

I am not sure about what this round about. After couple of simple management questions, The interviewer asking leet code questions which was not expected as it was mentioned that its a managerial round. As it was on 31st I was little not prepared and wanted to skip the question. The interviewer got offended and talking very rude. At this point I got the idea that interview is not.

Worst part is after every round they is no feedback cycle. they just ghost you. very bad attitude.

General Computer Science Questions.

Q1. 2NF and 3NF difference
Ans. 
2NF eliminates partial dependencies, while 3NF eliminates transitive dependencies.
• 2NF eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the primary key.

• 3NF eliminates transitive dependencies by ensuring that non-key attributes are not dependent on other non-key attributes.

• Example: In a table with columns A, B, and C where A is the primary key, if B depends on A and C...read more
Answered by AI
Add your answer
Q2. Alternative of using loop to print 1 to 100
Ans. 
Using recursion to print numbers from 1 to 100 without a loop
• Create a recursive function that takes a number as input and prints it

• Call the function with 1 as the initial input and increment the input by 1 in each recursive call

• Stop the recursion when the input reaches 100
Answered by AI
Add your answer
Q3. Delete and Truncate Difference
Ans. 
Delete removes rows from a table while truncate removes all rows from a table.
• Delete is a DML command while truncate is a DDL command.

• Delete operation can be rolled back while truncate operation cannot be rolled back.

• Delete operation fires triggers on each row deletion while truncate operation does not fire triggers.
Answered by AI
Add your answer

Q1. Basic OOPs concept and coding
Add your answer

Q1. Basic DSA question
Add your answer
Q2. 1 mySql query to fetch records
Add your answer
Q3. Design patterns
Add your answer

Q1. What is the code to determine the minimum number of dice throws required to reach 100 in a game of Snakes and Ladders?
Add your answer

Q1. Have you used fluient wait in selenium and why we are not using mostly
Ans. 
Fluent wait in Selenium is used for handling dynamic elements and synchronization issues.
• Fluent wait is used to wait for a condition to be true before proceeding with the next steps in Selenium automation scripts.

• It provides more flexibility in defining wait conditions compared to implicit or explicit waits.

• Fluent wait can be used to wait for a specific element to be visible, clickable, or any other custom condition.

• It...read more
Answered by AI
Add your answer
Q2. How to get all the links available in the page

Ans. 

To get all the links available on a page, you can use web scraping techniques.

• Use a web scraping tool like BeautifulSoup in Python or Selenium to extract all the links from the page

• Identify the HTML elements that contain the links, such as tags with href attributes

• Iterate through the elements to extract the URLs and store them in a list

Answered by AI

Add your answer