Interview-Questions

To Read Local file from MySql

noreply@blogger.com (Khaleek) — Mon, 11 Mar 2024 12:02:00 +0530

1. Right click on Connection

2. click on Edit

3. Go to Advance

4. Add this OPT_LOCAL_INFILE=1

5. close

SHOW GLOBAL VARIABLES LIKE 'local_infile';

SET GLOBAL local_infile = true;

drop temporary table if exists temp_vin_list;

create temporary table temp_vin_list(VinNumber varchar(100));

LOAD Data Local INFILE 'D:\\Sphere\\Report\\Input\\2024-03-14\\Vin.txt' INTO TABLE temp_vin_list;

call CheckVinNumber('2024-03-14');

call CheckVinNumbersWhichAreNotExistInDB('2024-03-14');

Run Mac OS on VM virtual box

noreply@blogger.com (Khaleek) — Thu, 28 Sep 2023 08:23:00 +0530

VBoxManage.exe modifyvm "MacOS" --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemProduct" "iMac19,1"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemVersion" "1.0"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiBoardProduct" "Mac-AA95B1DDAB278B95"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/DeviceKey" "ourhardworkbythesewordsguardedpleasedontsteal(c)AppleComputerInc"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/GetKeyFromRealSMC" 1

Source : https://www.makeuseof.com/tag/macos-windows-10-virtual-machine/

Delete Duplicate Rows

noreply@blogger.com (Khaleek) — Fri, 22 Sep 2023 23:01:00 +0530

Let’s create a sample Employee table and insert a few records in it.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE Employee
    ( 
    [ID] INT identity(1,1), 
    [FirstName] Varchar(100), 
    [LastName] Varchar(100), 
    [Country] Varchar(100), 
    ) 
    GO 
    
    Insert into Employee ([FirstName],[LastName],[Country] )values('Raj','Gupta','India'),
                                ('Raj','Gupta','India'),
                                ('Mohan','Kumar','USA'),
                                ('James','Barry','UK'),
                                ('James','Barry','UK'),
                                ('James','Barry','UK')

In the table, we have a few duplicate records, and we need to remove them.

SQL delete duplicate Rows using Group By and having clause

In this method, we use the SQL GROUP BY clause to identify the duplicate rows. The Group By clause groups data as per the defined columns and we can use the COUNT function to check the occurrence of a row.

For example, execute the following query, and we get those records having occurrence greater than 1 in the Employee table.

1
2
3
4
5
6
7
8
9
SELECT [FirstName], 
    [LastName], 
    [Country], 
    COUNT(*) AS CNT
FROM [SampleDB].[dbo].[Employee]
GROUP BY [FirstName], 
      [LastName], 
      [Country]
HAVING COUNT(*) > 1;

In the output above, we have two duplicate records with ID 1 and 3.

Emp ID 1 has two occurrences in the Employee table
Emp ID 3 has three occurrences in the Employee table

We require to keep a single row and remove the duplicate rows. We need to remove only duplicate rows from the table. For example, the EmpID 1 appears two times in the table. We want to remove only one occurrence of it.

We use the SQL MAX function to calculate the max id of each data row.

1
2
3
4
5
6
7
8
9
10
SELECT *
    FROM [SampleDB].[dbo].[Employee]
    WHERE ID NOT IN
    (
        SELECT MAX(ID)
        FROM [SampleDB].[dbo].[Employee]
        GROUP BY [FirstName], 
                 [LastName], 
                 [Country]
    );

In the following screenshot, we can see that the above Select statement excludes the Max id of each duplicate row and we get only the minimum ID value.

To remove this data, replace the first Select with the SQL delete statement as per the following query.

1
2
3
4
5
6
7
8
9
DELETE FROM [SampleDB].[dbo].[Employee]
    WHERE ID NOT IN
    (
        SELECT MAX(ID) AS MaxRecordID
        FROM [SampleDB].[dbo].[Employee]
        GROUP BY [FirstName], 
                 [LastName], 
                 [Country]
    );

Once you execute the delete statement, perform a select on an Employee table, and we get the following records that do not contain duplicate rows.

What is Middleware?

noreply@blogger.com (Khaleek) — Fri, 22 Sep 2023 22:41:00 +0530

A middleware is nothing but a component (class) which is executed on every request in ASP.NET Core application. In the classic ASP.NET, HttpHandlers and HttpModules were part of request pipeline. Middleware is similar to HttpHandlers and HttpModules where both needs to be configured and executed in each request.

Typically, there will be multiple middleware in ASP.NET Core web application. It can be either framework provided middleware, added via NuGet or your own custom middleware. We can set the order of middleware execution in the request pipeline. Each middleware adds or modifies http request and optionally passes control to the next middleware component.

Configure Middleware

We can configure middleware in the Configure method of the Startup class using IApplicationBuilder instance. The following example adds a single middleware using Run method which returns a string "Hello World!" on each request.

public class Startup
{
    public Startup()
    {
    } 
    public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
    {
        //configure middleware using IApplicationBuilder here..
            
        app.Run(async (context) =>
        {              
            await context.Response.WriteAsync("Hello World!");
              
        });

        // other code removed for clarity.. 
    }
}

In the above example, Run() is an extension method on IApplicationBuilder instance which adds a terminal middleware to the application's request pipeline. The above configured middleware returns a response with a string "Hello World!" for each request.

Understand Run Method

We used Run extension method to add middleware. The following is the signature of the Run method:

Method Signature:

public static void Run(this IApplicationBuilder app, RequestDelegate handler)

The Run method is an extension method on IApplicationBuilder and accepts a parameter of RequestDelegate. The RequestDelegate is a delegate method which handles the request. The following is a RequestDelegate signature.

Method Signature:

public delegate Task RequestDelegate(HttpContext context);

As you can see above, the Run method accepts a method as a parameter whose signature should match with RequestDelegate. Therefore, the method should accept the HttpContext parameter and return Task. So, you can either specify a lambda expression or specify a function in the Run method. The lambda expression specified in the Run method above is similar to the one in the example shown below.

public class Startup
{
    public Startup()
    {
    } 

    public void Configure(IApplicationBuilder app, IHostingEnvironment env)
    {
         app.Run(MyMiddleware);
    }

    private Task MyMiddleware(HttpContext context) 
    {
        return context.Response.WriteAsync("Hello World! ");
    }
}

The above MyMiddleware function is not asynchronous and so will block the thread till the time it completes the execution. So, make it asynchronous by using async and await to improve performance and scalability.

// other code removed for clarity

public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
     app.Run(MyMiddleware);
}

private async Task MyMiddleware(HttpContext context) 
{
    await context.Response.WriteAsync("Hello World! ");
}

Thus, the above code snippet is same as the one below.

app.Run(async context => await context.Response.WriteAsync("Hello World!") );

//or 

app.Run(async (context) =>
{
    await context.Response.WriteAsync("Hello World!"); 
});

So, in this way, we can configure middleware using Run method.

Configure Multiple Middleware

Mostly there will be multiple middleware components in ASP.NET Core application which will be executed sequentially. The Run method adds a terminal middleware so it cannot call next middleware as it would be the last middleware in a sequence. The following will always execute the first Run method and will never reach the second Run method.

public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
    app.Run(async (context) =>
    {
        await context.Response.WriteAsync("Hello World From 1st Middleware"); 
    });
    
    // the following will never be executed
    app.Run(async (context) =>
    {
        await context.Response.WriteAsync("Hello World From 2nd Middleware"); 
    });
}

To configure multiple middleware, use Use() extension method. It is similar to Run() method except that it includes next parameter to invoke next middleware in the sequence. Consider the following example.

public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
    app.Use(async (context, next) =>
    {
        await context.Response.WriteAsync("Hello World From 1st Middleware!");

        await next();
    });

    app.Run(async (context) =>
    {
        await context.Response.WriteAsync("Hello World From 2nd Middleware"); 
    });
}

The above example will display Hello World From 1st Middleware!Hello World From 2nd Middleware! in the browser.
Thus, we can use Use() method to configure multiple middlewares in the order we like.

What is Claim in api?

noreply@blogger.com (Khaleek) — Fri, 8 Sep 2023 23:07:00 +0530

Claims are the user data and they are issued by a trusted source. If we are working with token-based authentication, a claim may be added within a token by the server that generates the token. A claim can have any kind of data such as "DateOfJoining", "DateOfBirth", "email", etc. Based on a claim that a user has, a system provides the access to the page, which is called Claim based authorization. For example, the system will provide access to the page, if the user has a "DateOfBirth" claim. In short, claim based authorization checks the value of the claim and allows access to the system resource based on the value of a claim.

https://www.c-sharpcorner.com/article/claim-based-and-policy-based-authorization-with-asp-net-core-2-1/#:~:text=Claims%20are%20the%20user%20data,%2C%20%22email%22%2C%20etc.

Interview

noreply@blogger.com (Khaleek) — Mon, 4 Sep 2023 17:07:00 +0530

What is SingleOrDefault?

Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.

What is difference between run and use?

app.Run will end the request, and app.Use will pass the request to next middleware.

What is apiGateway?

The API Gateway serves as a reverse proxy to accept API calls from the client application, forwarding this traffic to the appropriate service. The API gateway also enforces security and ensures scalability and high availability.

how to merge all microservice outputs

error: update_ref failed for ref 'refs/remotes/origin/master': cannot lock ref 'refs/remotes/origin/master': unable to resolve reference 'refs/remotes/origin/master': reference broken

noreply@blogger.com (Khaleek) — Sun, 27 Aug 2023 01:23:00 +0530

Solution :

rm .git/refs/remotes/origin/master
git fetch

Interview

noreply@blogger.com (Khaleek) — Tue, 1 Aug 2023 17:03:00 +0530

1. We have millions of records in database. Write a optimized query to fetch data with where clause for name.

2. Write a linq query to fetch data from two databases.

3.How to pass data from controller to view?

4. How to imlement transaction in web api?

Covalense Global

noreply@blogger.com (Khaleek) — Wed, 26 Jul 2023 17:33:00 +0530

How to implement server side validation in MVC?
Ans : Data Annotation
How to pass data from View to Controller?
Which data typ you will take in java script to store key value pair?
Ans : map
How to implement Role Based Security in Sql Server?
If I want to dump data from SQL Server to MySQL what will you do.

Infosys

noreply@blogger.com (Khaleek) — Fri, 7 Jul 2023 17:33:00 +0530

1. What is COLESE?

2. What is Collete?

3. Difference between Cross Join and Cross Apply.

4. Difference between Store Procedure and Func

5 What is Recusrsive Store Procedure?

6. What is difference betweeen .Net framework and .Net core?

7. What are the main component on .Net core?

8. What is Kresteral?

9. What is GAC?

10. What if boxing and unboxing?

11. What is lifecycle hook in angular?

12. What is Single Page Application?

13. Difference between Promise and Obserbvables?

cannot read configuration file due to insufficient permissions

noreply@blogger.com (Khaleek) — Tue, 28 Mar 2023 14:50:00 +0530

Apply the following cnhages in IIS7.

1.In Windows Explorer, locate the web.config file that is associated with the Web site.
2.Right-click the web.config file
3.Click Properties.
4.Click the Security tab, and then click Edit.
5.Click Add.
6.In the Enter the object names to select box, type computername\IIS_IUSRS, click Check Names, and then click OK.
Note Computername is a placeholder for the computer name.
7.Click to select the Read check box, and then click OK.
8.In the Web.config Properties dialog box, click OK.

Call webservice using PostMan

noreply@blogger.com (Khaleek) — Wed, 22 Mar 2023 12:57:00 +0530

1. In header add Content-Type=text/xml.

2. In Body add row and Xml.

https://learning.postman.com/docs/sending-requests/soap/making-soap-requests/

Host Asp.net MYSql website on godaddy.

noreply@blogger.com (Khaleek) — Tue, 21 Mar 2023 15:13:00 +0530

1. Add database

2. Go to ASP.Net Setting and change connection string.

3. Download Publish Setting and import in Visual Studio.

QuickBook

noreply@blogger.com (Khaleek) — Mon, 20 Mar 2023 12:04:00 +0530

Quick Book API : https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#query-an-item

Get Access Token :- https://developer.intuit.com/app/developer/playground

Ref : https://www.youtube.com/watch?v=F5_6-21GaxM

Web Service to add in Web Connector : https://www.c-sharpcorner.com/article/how-to-integrate-quickbooks-desktop-using-web-service-qbxml/

Quickbook Sample Application : https://developer.intuit.com/app/developer/qbdesktop/docs/develop/sample-applications-and-code

SalesOrder : https://quickbooks.intuit.com/learn-support/en-us/other-questions/quickbooks-desktop-sales-order-transaction-date-setting/00/1025666

Add SSL in godaddy for Window hosting

noreply@blogger.com (Khaleek) — Tue, 7 Mar 2023 15:47:00 +0530

Ref : https://www.youtube.com/watch?v=HT4gNW79EzQ

The command npm install exited with code 1 visual studio 2022

noreply@blogger.com (Khaleek) — Tue, 7 Mar 2023 15:46:00 +0530

Run These Commands

# 👇 check your package.json for dependency updates

npx npm-check-updates

# 👇 write newer version in package.json

npx npm-check-updates -u

# 👇 install the latest version

npm install

Ref: https://sebhastian.com/npm-err-code-1/

Add new repository in bitbucket

noreply@blogger.com (Khaleek) — Mon, 6 Mar 2023 12:29:00 +0530

Assuming you have Git installed on your local machine, then:

Locally, change to the root directory of your existing source.
Initialize the project by running the following commands in the terminal:
```
git init
git add --all
git commit -m "Initial Commit"
```
Log into Bitbucket and create a new repository.
Locate the clone URL in the nav panel on the left (for example: https://username@your.bitbucket.domain:7999 /yourproject/repo.git).
Push your files to the repository by running the following commands in the terminal (change the URL accordingly):
```
git remote add origin https://username@your.bitbucket.domain:7999/yourproject/repo.git 
git push -u origin master
```
Done! Your repository is now available in Bitbucket.

Ref: https://confluence.atlassian.com/bitbucketserver/importing-code-from-an-existing-project-776640909.html

Running Lower Angular version at higher version

noreply@blogger.com (Khaleek) — Sun, 5 Mar 2023 16:24:00 +0530

Run this command :- npm install --legacy-peer-deps

The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.

noreply@blogger.com (Khaleek) — Sun, 5 Mar 2023 12:25:00 +0530

Create a registry key

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\eventlog\Application\MY-AWESOME-APP

Create a string value inside this

Name it EventMessageFile, set its value to

C:\Windows\Microsoft.NET\Framework\v2.0.50727\EventLogMessages.dll

That path appears to work in both 64 bit and 32 bit environments.

With this technique you don't need to set permissions in the registry, and once the key above is created it should just work.

Alternatively
f you don't have a large server farm but just a small "web garden" you could run a console application on each server that creates the event log source using EventLog.CreateEventSource, make sure the console application is run by an administrator.

Ref: https://stackoverflow.com/questions/286060/what-do-i-need-to-change-to-allow-my-iis7-asp-net-3-5-application-to-create-an-e/7848414#7848414

Get Free SSL

noreply@blogger.com (Khaleek) — Fri, 3 Mar 2023 14:38:00 +0530

https://www.youtube.com/watch?v=DJgxgOvK9Ig&t=67s

Unrelated Branches

noreply@blogger.com (Khaleek) — Fri, 3 Mar 2023 10:18:00 +0530

Run these commands

1. git pull origin master --allow-unrelated-histories

Host on Firebase

noreply@blogger.com (Khaleek) — Thu, 2 Mar 2023 17:58:00 +0530

https://www.youtube.com/watch?v=dPIyS5R6lHU

How to publish on SmarterAsp.Net

noreply@blogger.com (Khaleek) — Thu, 2 Mar 2023 11:18:00 +0530

https://www.youtube.com/watch?v=SWwPK_1WJ04

Run migration automatically in Production (.Net 6)

noreply@blogger.com (Khaleek) — Thu, 23 Feb 2023 12:01:00 +0530

public static class MigrationManager

{

    public static WebApplication MigrateDatabase(this WebApplication webApp)

{

        using (var scope = webApp.Services.CreateScope())

{

            using (var appContext = scope.ServiceProvider.GetRequiredService<ApplicationContext>())

{

try

{

                    appContext.Database.Migrate();

}

                catch (Exception ex)

{

                    //Log errors or do anything you think it's needed

                    throw;

}

}

}

        return webApp;

}

}

https://code-maze.com/migrations-and-seed-data-efcore/

Unified cloud

noreply@blogger.com (Khaleek) — Wed, 12 Jan 2022 10:02:00 +0530

Unified cloud final round interview questions

1. What will happen during interface implementation if methods are having same name?

Ans : There is nothing to identify. Interfaces only proscribe a method name and signature. If both interfaces have a method of exactly the same name and signature, the implementing class can implement both interface methods with a single concrete method.

2. What are sql check points?

Ans : For performance reasons, the Database Engine performs modifications to database pages in memory, in the buffer cache, and doesn't write these pages to disk after every change. Rather, the Database Engine periodically issues a checkpoint on each database. A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk, and also records the information in the transaction log.

The Database Engine supports several types of checkpoints: automatic, indirect, manual, and internal.

3. ado.net vs entity framwork which is better and why?

4. ORM Model?

5. If application is getting slow what are steps to improve performance?

6. Which Page load and unload events will fire if we call .Master page, .aspx page and .acsx page.

7. Diff between null, zero and blank?

8. How to create temp table in sql?

9. Can we use this keyword in staic method?

Ans : No , this keyword refer to current class object while static is not related to any object.

10. Constructor Reflaction?