10+ Emirates Global Oil & Gas Services LLC Interview Questions and Answers

I break down the problem into smaller parts and research each part to find a solution.

• Identify the problem and its requirements

• Break down the problem into smaller parts

• Research each part to find a solution

• Try different approaches and test them

• Collaborate with colleagues or seek help from online communities

Cut the chain twice to give one gold bar each day.

• Cut the chain between the first and second gold bar to give one bar each day.

• On the last day, cut the chain between the sixth and seventh gold bar to give the last bar.

• Total number of cuts required is 2.

Data Annotations are attributes used in .NET Framework to provide metadata about data elements.

• Data Annotations are used to validate data in models.

• They can be used to specify data types, display names, and format strings.

• Examples include [Required], [StringLength], and [RegularExpression].

Using a balance scale, find the lighter coin among 9 identical coins with only 2 weighings.

• Divide the coins into 3 groups of 3 coins each.

• Weigh any 2 groups against each other.

• If the scales balance, the lighter coin is in the third group.

• If the scales do not balance, the lighter coin is in the lighter group.

• Divide the lighter group into 3 individual coins and weigh any 2 of them against each other.

• If the scales balance, the lighter coin is the one that was not weighed.

• If the ...read more

To tune a Stored Procedure, identify bottlenecks, optimize queries, and use indexes.

• Identify slow queries and optimize them

• Use indexes to improve query performance

• Avoid using cursors and temporary tables

• Minimize network traffic by reducing data returned

• Use SET NOCOUNT ON to reduce network traffic

• Use stored procedure parameters instead of constants or variables

• Use TRY/CATCH blocks to handle errors

• Monitor performance using SQL Server Profiler and Database Engine Tuning Advisor

Routing in MVC is the process of mapping URLs to controller actions.

• Routing determines which controller and action should handle a request.

• Routes are defined in the RouteConfig.cs file.

• Routes can include parameters that are passed to the controller action.

• Routes can also include constraints to limit which requests match the route.

• Example: /products/5 maps to the ProductsController's Details action with id parameter 5.

Java 8 introduced several new features including lambda expressions, streams, and default methods.

• Lambda expressions allow for functional programming and simplify code.

• Streams provide a way to process collections of data in a functional style.

• Default methods allow for adding new methods to interfaces without breaking existing implementations.

• Other features include the new Date and Time API, method references, and the Optional class.

Solid Principles are a set of five design principles for writing maintainable and scalable software.

• Single Responsibility Principle (SRP)

• Open/Closed Principle (OCP)

• Liskov Substitution Principle (LSP)

• Interface Segregation Principle (ISP)

• Dependency Inversion Principle (DIP)

Increase user adoption by focusing on user experience, education, incentives, and feedback.

• Improve user experience by making the product intuitive and easy to use

• Provide educational resources such as tutorials, guides, and FAQs

• Offer incentives like discounts, rewards, or exclusive features for early adopters

• Collect and act on user feedback to continuously improve the product