remove duplicates in an sorted array

 

using System;

public class HelloWorld

{

    

    public static void Main(string[] args)

    {

        int[] ar={2,2,3,3,4,6,6};

         Console.WriteLine("Original Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

        RemoveDuplicates(ar);

        Console.WriteLine("After removing duplicates :");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

    }

    static void RemoveDuplicates(int[] ar){

       

       int rd=0;

       

       for(int i=1;i<ar.Length;i++){

           if( ar[rd] != ar[i]){

               rd++;

               ar[rd]=ar[i];

           }

          

       }

        // resize array to actual unique count

        

    }

}

reverse an array c#

 // Online C# Editor for free

// Write, Edit and Run your C# code using C# Online Compiler

using System;

public class HelloWorld

{

    public static void Main(string[] args)

    {

        int[] ar={2,4,6,8,10,12,14};

         Console.WriteLine("Original Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

        reverse(ar);

        Console.WriteLine("Reversed Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

    }

    static void reverse(int[] ar){

        int i=0,j=ar.Length - 1;

        while(i < j){

            int t= ar[i];

            ar[i]=ar[j];

            ar[j]=t;

            i++;

            j--;

        }

    }

}

best

 The phrase "Everything should be made as simple as possible, but not simpler" is a quote by Albert Einstein, meaning that while complex ideas should be simplified for clarity, this simplification should not go so far as to lose essential aspects of the original idea. It advocates for clear, accessible explanations and explanations that don't distort the truth by removing crucial details. 

Iphone less price countries

 

Country	Key Reason iPhone 17 Is Cheaper	Notes
United States	Base price is lowest; minimal sales tax in some states	Home country of Apple; best deals in certain states
Japan	Lower consumption taxes, strong currency	Japanese market has competitive pricing for Apple products
United Arab Emirates (UAE)	Zero VAT on electronics in certain zones	Dubai and Abu Dhabi are popular for tax-free tech shopping
Singapore	Low import duties, strong Singapore dollar	Official warranties available, easy availability
Australia	Favorable currency and local pricing	Price cheaper than India despite GST
Canada	Lower import taxes, favorable exchange rate	Major cities like Toronto and Vancouver offer good deals
Germany	Competitive VAT rates, strong Euro pricing	European market pricing helps save on latest Apple devices

c# interviewquestions

 2. What is the difference between static, public, and void?

3. What is an object?

4. Define Constructors.

What is the benefit of ‘using’ statement in C#?

 Can “this” command be used within a static method?

 What is serialization?

What are Jagged Arrays?

 Discuss the various methods to pass parameters in a method.

Explain the four steps involved in the C# code compilation.

Mention the important IDEs for C# development provided by Microsoft.

 What is meant by Unmanaged or Managed Code?

What is meant by an Abstract Class?

 Differentiate between finalize blocks and finalize.

What is meant by an Interface?

 What is the difference between read-only and constants?

 What is an interface class? 

What are reference types and value types?

 What are User Control and Custom Control?

What are sealed classes in C#?

 What is method overloading?

 What is the difference between Arraylist and Array?

Is it possible for a private virtual method to be overridden?

Describe the accessibility modifier “protected internal”.

What’s the difference between the System.Array.CopyTo() and System.Array.Clone() ?

 What’s the difference between an abstract and interface class?

What are generics in C# .NET?

What are Custom Exceptions?

What are delegates?

. What is the difference between method overriding and method overloading?

. How do you inherit a class into another class in C#?

What are the various ways that a method can be overloaded??

Why can't the accessibility modifier be specified for methods within the interface?

How can we set the class to be inherited, but prevent the method from being overridden?

 What is the difference between a Struct and a Class

what happens if the method names in the inherited interfaces conflict

 How can we make an array with non-standard values?

What is the difference between “is” and “as” operators in c#?

What is a multicast delegate?

 What is the distinction between "throw" and "throw ex" in.NET?

In C#, how do you implement the singleton design pattern?

Is C# code managed or unmanaged code?

What is the distinction between the Dispose() and Finalize() methods?

What is tuple in C#?

 What are Events?

 What is the Constructor Chaining in C#? 

What is a multicasting delegate in C#?

. What is a Virtual Method in C#?

What is Multithreading with .NET?

. What is the Race condition in C#?

Questions are asked on C# in the interview

What is C#? This question is designed to test your basic knowledge of the language. You can answer by saying that C# is an object-oriented programming language developed by Microsoft that is used to create Windows applications, web applications, and games.

What is the difference between a class and an object in C#? This question is designed to test your understanding of object-oriented programming concepts. You can answer by saying that a class is a blueprint for creating objects, while an object is an instance of a class.

What is the difference between an abstract class and an interface in C#? This question is designed to test your understanding of advanced object-oriented programming concepts. You can answer by saying that an abstract class is a class that cannot be instantiated and is used as a base class for other classes, while an interface is a contract that defines a set of methods and properties that a class must implement.

What is the difference between a value type and a reference type in C#? This question is designed to test your understanding of C# data types. You can answer by saying that a value type stores its value directly in memory, while a reference type stores a reference to an object in memory.

What is the difference between a stack and a heap in C#? This question is designed to test your understanding of C# memory management. You can answer by saying that a stack is used to store value types and method calls, while a heap is used to store reference types and objects.

---

INTERMEDIATE LEVEL QUESTIONS

What is the difference between a struct and a class in C#? This question is designed to test your understanding of C# data types. You can answer by saying that a struct is a value type that is stored on the stack, while a class is a reference type that is stored on the heap.

What is the difference between a delegate and an event in C#? This question is designed to test your understanding of C# events and delegates. You can answer by saying that a delegate is a type that represents a method signature, while an event is a mechanism for notifying clients when something happens.

What is the difference between a private and a protected member in C#? This question is designed to test your understanding of C# access modifiers. You can answer by saying that a private member is accessible only within the class that defines it, while a protected member is accessible within the class that defines it and any derived classes.

What is the difference between a static class and a non-static class in C#? This question is designed to test your understanding of C# classes. You can answer by saying that a static class cannot be instantiated and contains only static members, while a non-static class can be instantiated and contains both static and non-static members.

What is the difference between an abstract class and a sealed class in C#? This question is designed to test your understanding of C# classes. You can answer by saying that an abstract class cannot be instantiated and is used as a base class for other classes, while a sealed class cannot be inherited from.

Find the missing data comparing two users. same table

 SELECT a.Site_Location

FROM tbl_UserAccessEntities a

LEFT JOIN tbl_UserAccessEntities b

    ON a.Site_Location = b.Site_Location

   AND b.User_ID = 'EROOSENSCHOON'

   AND b.country_code = 'US'

   AND b.Division_ID = 'msv'

WHERE a.User_ID = 'Scooper'

  AND a.country_code = 'US'

  AND a.Division_ID = 'msv'

  AND b.Site_Location IS NULL;

SQL Case studies

 https://drive.google.com/drive/folders/1uOX7A6r5SDN6NXhVtHc4lNWRYOwjhtE1

Data Enginer skills

 Must-Have Skills:

✔ AWS Services: Glue, Lambda, Athena, Lakehouse, Iceberg
✔ AWS CDK for IaC
✔ Programming: Python, PySpark, Spark SQL, TypeScript, Scala, or Java
✔ Data lakes & data warehousing on AWS

vvvvvvvvvvvvIMP link

 https://learnersbucket.com/examples/topics/interview/

https://zerotomastery.io/blog/dot-NET-interview-questions/

https://www.interviewbit.com/c-sharp-interview-questions/#types-of-classes-in-c-sharp

https://refactoring.guru/design-patterns/creational-patterns

https://neetcode.io/courses/system-design-for-beginners/0

https://algomaster.io/learn/lld/what-is-lld

https://www.techinterviewhandbook.org/software-engineering-interview-guide/

https://unwiredlearning.com/courses/react-masterclass