Elancer It Solutions Interview Questions and Answers for Freshers

Basic logical questions

Q1. Write simple SQL queries
Ans. 
Basic SQL queries for software engineer interview
• SELECT * FROM table_name;

• SELECT column1, column2 FROM table_name WHERE condition;

• INSERT INTO table_name (column1, column2) VALUES (value1, value2);

• UPDATE table_name SET column1 = value1 WHERE condition;

• DELETE FROM table_name WHERE condition;
Answered by AI
Add your answer

Q1. Salary Discussion
Add your answer

In the first round they ask some technical mcq and gave some coding questions in python and SQL.there were less aptitude questions.

Q1. Just asking simple string based questions and some difficult sql questions .it was 1hr section.
Add your answer
Q2. Groupby having, joins like inner outer left right
Add your answer
Q3. Most frequent word in a sentence ?
Ans. 
The most frequent word in a sentence can be found by counting the occurrence of each word and selecting the one with the highest count.
• Split the sentence into words using whitespace as delimiter

• Create a dictionary to store the count of each word

• Iterate through the words and update the count in the dictionary

• Find the word with the highest count in the dictionary
Answered by AI
Add your answer
Q4. Given some tables and extract the values between some values and fileter by some values
Add your answer

Q1. Introduce yourself difference between abstract class and interface difference between final and finally this and super keyword hard assert and soft assert string immutable concept prime number program char...read more
Add your answer

Q1. Prime number assertion some selenium based code using action handling parent child window
Add your answer

Q1. Web design use in php
Ans. 
Web design is an important aspect of PHP development as it determines the look and feel of the website.
• PHP can be used to create dynamic web pages with custom designs

• CSS can be used to style the HTML elements generated by PHP

• Frameworks like Laravel and CodeIgniter provide pre-built templates for web design

• Responsive design can be implemented using media queries in CSS
Answered by AI
Add your answer
Q2. Use in html and css includes function use and include_once function difference
Ans. 
HTML and CSS include functions and difference between include and include_once
• HTML includes are used to include external files into a webpage

• CSS includes are used to include external stylesheets into a webpage

• include() function is used to include a file and will produce a warning if the file is not found

• include_once() function is used to include a file only once, even if it is called multiple times

• Both functions are us
Answered by AI
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Tell me about yourself.
Add your answer

Q1. Reverse a link list, reverse a binary tree
Ans. 
To reverse a linked list, traverse it and change the pointers. To reverse a binary tree, swap left and right child nodes recursively.
• For reversing a linked list, traverse the list and change the pointers to point to the previous node instead of the next node.

• For reversing a binary tree, swap the left and right child nodes of each node recursively starting from the root node.

• Both operations can be done in O(n) time comp...read more
Answered by AI
Add your answer
Q2. Why merge short is better than any other shorting technique
Ans. 
Merge short is better than other shorting techniques due to its ability to minimize risk and maximize profits.
• Merge short involves combining multiple short positions into one, reducing the risk of individual short positions

• It allows for greater flexibility in managing short positions and can lead to higher profits

• For example, if an investor wants to short a stock but is unsure of the timing, they can use merge short to...read more
Answered by AI
Add your answer