UST Software Engineer II Interview Questions, Process, and Tips

You will be asked to develop an application and based on that the next round will be proceeded. For me I have been asked to perform some crud operations with api using asp.net core and asp.net mvc application

Q1. What is api and why do we use it
Ans. 
API is a set of protocols and tools for building software applications. It allows different applications to communicate with each other.
• API stands for Application Programming Interface

• It defines how different software components should interact with each other

• APIs can be used to access data or functionality from other applications or services

• Examples of APIs include Google Maps API, Twitter API, and Facebook API
Answered by AI
Add your answer
Q2. Difference between interface and abstract class
Ans. 
Interface defines only method signatures while abstract class can have method implementations.
• An interface can be implemented by multiple classes while an abstract class can only be extended by one class.

• An abstract class can have constructors while an interface cannot.

• An abstract class can have instance variables while an interface cannot.

• An abstract class can provide default implementations for some methods while an ...read more
Answered by AI
Add your answer
Q3. How routing is performed in asp.net core api
Ans. 
Routing in ASP.NET Core API is performed using the built-in middleware called Endpoint Routing.
• Endpoint Routing is responsible for mapping incoming requests to the appropriate action methods in the controller.

• It uses the HTTP verb, URL pattern, and route data to determine the correct action method.

• Routes can be defined using attributes on the controller and action methods or in the Startup.cs file.

• Middleware like authe...read more
Answered by AI
Add your answer
Q4. What are solid principles
Ans. 
SOLID principles are a set of design principles for writing maintainable and scalable software.
• S - Single Responsibility Principle

• O - Open/Closed Principle

• L - Liskov Substitution Principle

• I - Interface Segregation Principle

• D - Dependency Inversion Principle
Answered by AI
Add your answer

Q1. Why are you switching to this job
Add your answer
Q2. What is your salary expectations
Add your answer

Average to easy difficulty level.

Q1. Java code of string manipulation
Add your answer
Q2. What is the Java code for various types of sorting algorithms?
Add your answer
Q3. Sql query and topics related to joins.
Add your answer

Q1. About yourself and family
Add your answer
Q2. What do you know about the company?
Add your answer
Q3. Can you provide examples of real-life scenarios where you handled conflicts with either a colleague or a manager?
Add your answer
Q4. What actions would you take if your manager does not approve your product idea, and how would you attempt to persuade them?
Add your answer

It was kind of difficult the coding part

They asked basic on going topic like impact of AI

Q1. Very much complex questions on cloud, oops, python and networks
Add your answer
Q2. What is diffrent between linear and logestic regression
Ans. 
Linear regression is used for predicting continuous values, while logistic regression is used for predicting binary outcomes.
• Linear regression is used when the dependent variable is continuous and has a linear relationship with the independent variable.

• Logistic regression is used when the dependent variable is binary or categorical and the relationship between the independent variables and the outcome is non-linear.

• Lin...read more
Answered by AI
Add your answer
Q3. Certain questions on cloud
Add your answer

Basic aptitudes question in online test

Two coding Q online test

Q1. Resume bsic Q asked
Add your answer
Q2. Oops question basic theory
Add your answer

Q1. One coding question asked to solve on paper of arrays
Add your answer
Q2. Basic questions from resume
Add your answer

Q1. Relocating related questions
Add your answer
Q2. Why u want to join global logic
Ans. 
I want to join Global Logic because of their reputation for cutting-edge technology solutions and collaborative work environment.
• Global Logic is known for their innovative technology solutions

• I am impressed by the collaborative work environment at Global Logic

• I believe Global Logic offers great opportunities for professional growth and development
Answered by AI
Add your answer

It was an aptitute round and 2 coding questions was there

Q1. Tell me about yourself
Add your answer
Q2. We had discussion on projects than mentioned in my resume
Add your answer
Q3. Then he moved to DSA question in which he told to how you will insert node in doubly linked list ,I answered all correctly he appreciated me also but after 5 min one person came and told you can go . I was...read more
Add your answer

Q1. Node.js question were asked
Add your answer
Q2. Project questions were also being asked
Add your answer

Q1. General Behavioural questions
Add your answer
Q2. Culture fit questions
Add your answer

Q1. All the questions were from SQL server.
Add your answer
Q2. How to get 3rd highest salary ?
Ans. 
To get the 3rd highest salary, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query to select distinct salaries in descending order.

• Use the 'LIMIT' keyword to limit the results to 3.

• Use the 'OFFSET' keyword to skip the first 2 highest salaries.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q3. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1,1]
Ans. 
The inner join of two tables with duplicate values results in a combined set of common values.
• Inner join combines rows from both tables where the key columns match

• In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables
Answered by AI
Add your answer
Q4. SSIS Package creation.
Add your answer
Q5. Latest project explanation
Ans. 
Developed a web application for tracking and managing project tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express

• Utilized MongoDB for database management

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer

Q1. What is difference between SQL and NoSQL
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores

• SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages

• SQL databases are vertically scalable, NoSQL databases are horizontally scalable

• SQL databa...read more
Answered by AI
Add your answer
Q2. Why is NoSQL better then SQL
Ans. 
NoSQL is better for handling unstructured data, providing scalability and flexibility.
• NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.

• NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.

• NoSQL databases offer more flexibility in terms of data model, allowing fo...read more
Answered by AI
Add your answer
Q3. Explain the data pipeline you have worked on.
Ans. 
Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.
• Used Apache Kafka for real-time data streaming

• Utilized Apache Spark for data processing and analysis

• Implemented data transformations and aggregations using Scala

• Stored processed data in a data warehouse like Amazon Redshift

• Built monitoring and alerting systems to ensure data pipeline reliability
Answered by AI
Add your answer
Q4. Managing team
Add your answer
Q5. What will you do if you have conflict with your manager.
Ans. 
I would address the conflict directly and professionally, seeking to understand the root cause and find a mutually beneficial solution.
• Schedule a private meeting with the manager to discuss the conflict

• Listen actively to the manager's perspective and express your own calmly

• Seek to find common ground and propose potential solutions

• If necessary, involve HR or a mediator to help resolve the conflict
Answered by AI
Add your answer
Q6. What do you love to do when you are free
Ans. 
I love to spend my free time hiking, reading, and trying out new recipes in the kitchen.
• Hiking in the mountains or local trails

• Reading fiction and non-fiction books

• Experimenting with new recipes and cooking techniques
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Family background
Add your answer