Logicsoft International Interview Questions and Answers

Java Arrays and String with data structure

Implementation of Java Oops in test framework

Q1. How frequently are you able to travel to support the project
Add your answer
Q2. Salary discussion
Add your answer
Q3. One and one call with Hiring manager
Add your answer
Q4. When are you feeling more excited during work.
Add your answer

Q1. Self introduction
Add your answer
Q2. Windows function and how you used
Ans. 
Window functions are used to perform calculations across a set of table rows that are related to the current row.
• Window functions are used in SQL to perform calculations on a specific subset of rows related to the current row.

• They are often used with aggregate functions like SUM, AVG, and COUNT to calculate running totals, moving averages, and rankings.

• Examples of window functions include ROW_NUMBER(), RANK(), LEAD(),
Answered by AI
Add your answer
Q3. Sql Coding questions. Window functions with joins.
Add your answer
Q4. Pyspark code for how you connect the data to ADLS with doing partition
Ans. 
Use PySpark code to connect data to ADLS with partitioning
• Use SparkSession to create a Spark application

• Set the configuration for ADLS storage account and container

• Read data from ADLS using Spark DataFrame API

• Partition the data based on a specific column while writing back to ADLS
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. About your experience
Add your answer

Q1. How you handle the escalation
Add your answer

Q1. Salary discussion
Add your answer

Q1. What are different KPI's
Ans. 
Key Performance Indicators (KPIs) are measurable values that demonstrate how effectively a company is achieving key business objectives.
• KPIs are specific, measurable, achievable, relevant, and time-bound metrics used to evaluate the success of an organization or a particular activity.

• Examples of KPIs include revenue growth rate, customer acquisition cost, customer retention rate, website traffic, conversion rate, and e
Answered by AI
Add your answer
Q2. Differentiate loc and iloc in pandas
Ans. 
loc is label-based indexing while iloc is integer-based indexing in pandas.
• loc is used to access a group of rows and columns by labels

• iloc is used to access a group of rows and columns by integer position

• Example: df.loc['row_label', 'column_label'] vs df.iloc[0, 1]
Answered by AI
Add your answer

Q1. Introduction about yourself
Ans. 
Experienced travel sales consultant with a passion for creating memorable experiences for clients.
• Over 5 years of experience in the travel industry

• Strong knowledge of various destinations, accommodations, and travel packages

• Excellent communication and customer service skills

• Proven track record of exceeding sales targets

• Passionate about helping clients create unforgettable travel experiences
Answered by AI
Add your answer
Q2. Sales skills
Add your answer

Average difficulty mainly logical tests

Q1. What is difference between Azure and Aws
Ans. 
Azure and AWS are both cloud computing platforms, but they have differences in services, pricing, and market share.
• Azure is developed by Microsoft, while AWS is developed by Amazon.

• AWS has been in the market longer and has a larger market share compared to Azure.

• Azure is known for its integration with Microsoft products and services, while AWS offers a wider range of services and features.

• Pricing models differ between ...read more
Answered by AI
Add your answer
Q2. How to handle end moment changes
Ans. 
End moment changes should be communicated effectively, assess impact, adjust plans accordingly, and prioritize tasks.
• Communicate changes promptly to all stakeholders

• Assess the impact of changes on project timeline, budget, and resources

• Adjust plans accordingly to accommodate the changes

• Prioritize tasks based on the urgency and importance of the changes

• Maintain open communication channels for feedback and updates
Answered by AI
Add your answer

Q1. React basic questions
Add your answer
Q2. Javascript and api
Add your answer

Q1. Software relate
Add your answer
Q2. What is diffrent maya and blender
Ans. 
Maya and Blender are both 3D modeling software, but Maya is more commonly used in professional settings while Blender is open-source and free.
• Maya is more commonly used in professional settings due to its advanced features and industry recognition.

• Blender is open-source and free, making it more accessible to beginners and hobbyists.

• Maya has a steeper learning curve compared to Blender.

• Blender has a more active online c...read more
Answered by AI
Add your answer
Q3. Are you know about unity and unreal engin
Add your answer
Q4. Are you use unity
Ans. 
Yes, I use Unity for creating 3D art and animations.
• I use Unity for creating 3D models, animations, and visual effects.

• Unity provides a user-friendly interface and powerful tools for 3D artists.

• I have experience with Unity's lighting and shading features to enhance the visual quality of my work.
Answered by AI
Add your answer
Q5. Are you using unreal engin ?
Ans. 
Yes, I am using Unreal Engine for my 3D projects.
• I use Unreal Engine for creating realistic environments and characters.

• Unreal Engine offers powerful tools for creating interactive experiences.

• I have experience with Unreal Engine's Blueprint visual scripting system.
Answered by AI
Add your answer
Q6. Tell me about your self
Add your answer