Aera Software Technology Interview Questions and Answers

Basic SQL questions on group and ranking. Good sql in touch will be able to solve easy. They have set of 4-5 questions which they ask often.

Q1. General project related questions in which they will try to know your capabilities
Add your answer
Q2. And Project scenario to understand if you are ready to work without any good technology as with aera they only work with their tools.
Add your answer

Q1. Basic expectations. And they will comback with the response.
Add your answer

Assignment based on HackerRank SQL Problems.

Q1. Difference between Truncate and Delete.
Add your answer
Q2. Scenario based questions for testing knowledge on SQL joins and window functions.
Add your answer

Hankerrank platform ,

Q1. About Resume and projects
Add your answer
Q2. More questions on your skills
Add your answer

Q1. Write code for below: Removed number character before hash based on count of hash Case 1 I/P= abc#d O/P= abcd Case 2 I/P=abc##d O/p=ad
Ans. 
Write code to remove number character before hash based on count of hash
• Count the number of hashes in the input string

• Loop through the string and remove the character before the hash based on the count of hashes

• Return the modified string
Answered by AI
Add your answer
Q2. Multiply ele E.g:[1,8,7,3,2] => 1 = 8*7*3*2 [336,42,48,112,168] If 1 then you should multiply all except 1 i.e 8*7*3*2=336
Ans. 
The question asks to multiply all elements in an array except for a given number.
• Iterate through the array and calculate the product of all elements except the given number.

• Use a variable to keep track of the product.

• If the given number is 1, multiply all other elements.

• Return the resulting array.
Answered by AI
View 1 more answer