Posts

SQL interview Questions for Fresher and Experienced developer

Here are detailed answers with explanations and examples for each SQL interview topic, especially suited for experienced candidates: 1. Table Type in SQL A Table Type is a user-defined data type in SQL Server that can store a result set for later use in functions, procedures, or batch execution. CREATE TYPE EmployeeType AS TABLE (EmpID INT, EmpName NVARCHAR(50)); 2. Non-Clustered Index A Non-Clustered Index maintains a separate structure with a pointer to the actual data. Unlike a clustered index, it doesn't rearrange the data. CREATE NONCLUSTERED INDEX idx_empname ON Employees(EmpName); 3. Temp Table Temporary tables store intermediate data temporarily for further processing. They exist only during the session. CREATE TABLE #TempTable (ID INT, Name NVARCHAR(50)); 4. EDMX for Oracle DB Yes, EDMX can be generated for Oracle using Entity Framework via third-party providers like Devart dotConnect for Oracle. 5. Difference Between Primary and Unique Key Primary Key: Cannot contain NULL...
Post a Comment
Read more

How Binary Search Works with Example

How Binary Search Works with Example Binary Search :  To find an value in array we are having different ways and binary search is one of the most efficient way. It will reduce the no. of iteration to find the solution thus get us the solution quickly. In simple form, we need to do 3 checks as follows :  target value = the value to find in the array.     1. if the target value = array[mid] => return the index.     2. if target value is smaller, than start searching on the left side else search on right side.     3. Keep repeating the process till either you get the value or till you iterate elements in array. How Binary Search Works :  Learn by solving a Problem :  Write a method to find an index of an element in an ascending Sorted Array using Binary Search.  If element doesn't exist return -1. Illustration 1 :      a[] = {1,2,4,5,7,8,10} , Find 5                 ...
Post a Comment
Location: Haribhau Upadhyay Nagar, Ajmer, Rajasthan 305004, India
Read more

C# .Net Core Interview Questions for Freshers and Experienced Developers

  C#, .NetFramework, .Net Core interview Questions For Angular and SQL Interview Questions, click here...! 1. IOC (Inversion of Control) Container in .NET Core The IOC container in .NET Core is responsible for managing object creation and their dependencies. It's used for Dependency Injection (DI), making it easy to manage lifecycles (transient, scoped, singleton). Example of registering a service: public void ConfigureServices(IServiceCollection services) {     services.AddScoped<IMyService, MyService>();  // DI registration } 2. Configure and ConfigureServices - When to Use What ConfigureServices: Used to register services with the dependency injection container. Typically includes services like database context, authentication, and MVC. Configure: Used to define the middleware pipeline (how requests are processed). Example: public void ConfigureServices(IServiceCollection services) {     services.AddControllers();     services.AddDbContex...
Post a Comment
Location: India
Read more