SQL Interview Questions and Answers

1) What is SQL?

2) When SQL appeared?

3) What are the usages of SQL?

4) Does SQL support programming?

5) What are the subsets of SQL?

6) What is a Data Definition Language?

7) What is a Data Manipulation Language?

8) What is Data Control Language?

9) What are tables and fields in the database?

10) What is a primary key?

11) What is a foreign key?

12) What is a unique key?

13) What is the difference between primary key and unique key?

14) What is a Database?

15) What is DBMS?

16) What are the different types of database management systems?

17) What is RDBMS?

18) What is Normalization in a Database?

19) What is the primary use of Normalization?

20) What are the disadvantages of not performing Database Normalization?

21) What is an inconsistent dependency?

22) What is Denormalization in a Database?

23) What are the types of operators available in SQL?

24) What is a view in SQL?

25) What is an Index in SQL?

26) Which are the different types of indexes in SQL?

27) What is the unique Index?

28) What is the Clustered Index in SQL?

29) What is the Non-Clustered Index in SQL?
30) What is the difference between SQL, MySQL and SQL Server?

31) What is the difference between SQL and PL/SQL?

32) Is it possible to sort a column using a column alias?

33) What is the difference between clustered and non-clustered index in SQL?

34) What is the SQL query to display the current date?

35) Which are the most commonly used SQL joins?

36) What are the different types of joins in SQL?

37) What is Inner Join in SQL?

38) What is Right Join in SQL?

39) What is Left Join in SQL?

40) What is Full Join in SQL?

41) What is a "TRIGGER" in SQL?

42) What is self-join and what is the requirement of self-join?

43) What are the set operators in SQL?

44) What is the difference between BETWEEN and IN condition operators?

45) What is a constraint? Tell me about its various levels.

46) Write an SQL query to find names of employee start with 'A'?

47) Write an SQL query to get the third maximum salary of an employee from a table named employee_table.

48) What is the difference between DELETE and TRUNCATE statement in SQL?


49) What is ACID property in a database?

50) What is the difference between NULL value, zero and blank space?

51) What is the usage of SQL functions?

52) What do you understand by case manipulation functions?

53) Which are the different case manipulation functions in SQL?

54) Explain character-manipulation functions?

55) Which are the different character-manipulation functions in SQL?

56) What is the usage of NVL() function?

57) Which function is used to return remainder in a division operator in SQL?

58) What are the syntax and use of the COALESCE function?

59) What is the usage of the DISTINCT keyword?

jQuery Interview Question and Answers

https://www.javatpoint.com/jquery-interview-questions


1) What is jQuery?

2) Is jQuery a programming language?

3) What is the difference between JavaScript and jQuery?

4) Is jQuery replacement of JavaScript?

5) Why do we use jQuery?

6) What is $() in jQuery library?

7) What are the effects methods used in jQuery?

8) What is the use of toggle() method in JQuery?

9) What is the purpose of fadeToggle() method in JQuery?

10) What is the use of delay() method in JQuery?

11) Is it possible that jQuery HTML work for both HTML and XML document?

12) What is the use of html() method in JQuery?

13) What is the use of css() method in JQuery?

14) Is jQuery library used for server scripting or client scripting?
15) Is jQuery a W3C standard?

16) What is the starting point of code execution in jQuery?

17) What is the basic requirement to start with the jQuery?

18) Can you use any other name in place of $ (dollar sign) in jQuery?

19) Can you use multiple document.ready() function on the same page?

20) What is the difference between find and children methods?

21) What is a CDN?

22) What is the goal of CDN and what are the advantages of using CDN?

23) How can you use a jQuery library in your project?

24) What are the selectors in jQuery? How many types of selectors in jQuery?

25) What is a use of jQuery filter?

26) What are the different types of selectors in jQuery?

27) What is the difference between the ID selector and class selector in jQuery?

28) What is the use of serialize() method in JQuery?

29) What is the use of val() method in JQuery?

30) How to add and remove CSS classes to an element using jQuery?

31) Can you write a jQuery code to select all links inside the paragraph?

32) What is the difference between prop and attr?

33) What are the two types of CDNs?

34) What is the use of the animate() method in jQuery?

35) How can you disable jQuery animation?

Azure Interview Questions and Answers

https://www.edureka.co/blog/interview-questions/azure-interview-questions/
1. What are the different types of services offered in the cloud?

2. What is cloud computing?

3. What are the different cloud deployment models?

4.I have some private servers on my premises, also I have distributed some of my workload on the public cloud, what is this architecture called?

5. What is Microsoft Azure and why is it used?

6. Which service in Azure is used to manage resources in Azure?

7. Which of the following web applications can be deployed with Azure?

8. What are Roles and why do we use them?

10. Is it possible to create a Virtual Machine using Azure Resource Manager in a Virtual Network that was created using classic deployment?

11. What are virtual machine scale sets in Azure?

12. Are data disks supported within scale sets?

13. What is an Availability Set?

14. What are Fault Domains?

15. What are Update Domains?

16. What are Network Security Groups?

17. Do scale sets work with Azure availability sets?

18. What is a break-fix issue?

19. Why is Azure Active Directory used?

20. What happens when you exhaust the maximum failed attempts for authenticating yourself via Azure AD?

21. Where can I find a list of applications that are pre-integrated with Azure AD and their capabilities?

22. How can I use applications with Azure AD that I’m using on-premises?

23. What is Azure Service Fabric?

24. What is a VNet?

25. What are the differences between Subscription Administrator and Directory Administrator?

26. Are there any scale limitations for customers using managed disks?

27. What is the difference between Service Bus Queues and Storage Queues?

28. What is Azure Redis Cache?

29. Why doesn’t Azure Redis Cache have an MSDN class library reference like some of the other Azure services?

30. What are Redis databases?

31. Is it possible to add an existing VM to an availability set?

32. What are the username requirements when creating a VM?

33. What are the password requirements when creating a VM?

34. How much storage can I use with a virtual machine?

35. How can one create a Virtual Machine in Powershell?

36. How to create a Network Security Group and a Network Security Group Rule?

37. How to create a new storage account and container using Power Shell?

38. How can one create a VM in Azure CLI?

39. What are the various power states of a VM?

40. How can you retrieve the state of a particular VM?

41. How can you stop a VM using Power Shell?

42. Why was my client disconnected from the cache?

43. What is Azure Search?

44. My web app still uses an old Docker container image after I’ve updated the image on Docker Hub. Does Azure support continuous integration/deployment of custom containers?

45. What are the expected values for the Startup File section when I configure the runtime stack?

46. How are Azure Marketplace subscriptions priced?

47. What is the difference between “price,” “software price,” and “total price” in the cost structure for Virtual Machine offers in the Azure Marketplace?

48. What are stateful and stateless microservices for Service Fabric?

49. What is the meaning of application partitions?

50. What are special Azure Regions?

https://www.javatpoint.com/microsoft-azure-interview-questions

1) What is Cloud Computing?
2) What is Azure Cloud Service?
3) Which service in Azure can be used to manage resources?
4) What type of web application can be deployed with Azure?
5) Explain Role in terms of Microsoft Azure.
6) What is Virtual Machine scale sets?
7) What are the principal segments of the Windows Azure platform?
8) What do you understand by autoscaling in Azure?
9) What is the storage key?
10) Explain the SQL Azure database.
11) Explain cmdlet in Azure?
12) Explain the Migration Assistant tool in Microsoft Azure.
13) What is Azure SLA (Service Level Agreement)?
14) What is Availability Set in Azure?
15) What steps should we take in case of drive failure?
16) Why we use VNet? Name the power states of a Virtual Machine.
17) What is network security groups?18) What is cspack?
19) Name two blobs used in Microsoft Azure.
20) Can we add an existing VM to an availability set?
21) How much storage can we use with a virtual machine?
22) How to create a VM in Azure CLI?
23) What is Azure Search?
24) Explain stateful and stateless micro-services for Service Fabric?
25) What is a Web role in Azure Cloud Service?
26) Can we create a VM using Azure Resource Manager in a Virtual Network that was created using classic deployment?
27) What are the options available in Azure for data storage?
28) What is Azure Redis Cache?29) What are Redis databases?
30) How to create a VM in PowerShell?

Object Oriented Programming Concepts (OOPs)

OOP is a technique to develop logical modules, such as classes that contains properties, fields and events. OOP provides many concepts such as inheritance, data binding, polymorphism etc.

Object Oriented Programming Concepts

Objects and Classes in C#

Abstract Class and Methods

Encapsulation

Interface

Abstract vs Interface

Constructor

Access Modifiers

Method Overloading vs Method Overriding

Inheritance

Polymorphism

Static Keyword

Desktop & Mobile App

We need a project to develop for contractors(Civil/Electrical) to manage their employees and their payments. We prefer Node JS/Monogo DB or ASP. Net Angular/Mysql or Sql Server. We are looking for an individual / small companies to start their career better. But not prefer the freshers. If you are good we will give you other modules to develop.

Finish .Net Core API backend project

Finish the backend part of a .Net Core project (API). This will be an API for supporting the UI.

The work consist in creating entities, tables, controllers and its actions. Store the data in SQL Server using Entity Framework.
The technologies required are: .Net Core, C#, SQL Server, Entity Framework, RESTful endpoints.
They are around 10 entities. (a detailed diagram is attached)
The Authentication and authorization is already in place with 2 roles: admin and general admin.

About the project:

This is a product price list system. The logged user can create and admin the company, company branches, users, price lists, categories, products and prices. Anonymous users can navigate products filtering by categories and buy them.

Detailed use cases:

Public actions (user not logged in):
Buy: Anonymous user can select different items and quantities and buy them. This will just generate a record in the database.
Given a branch id, list item categories.
List all items. List items that belong to a category: These last two lists must support order by and pagination. (pageSize, pageNumber or lastItemId)

Authorized actions (user must be logged in)
User can have admin role, general admin role or none.
General admin can change the hired plan and can add/remove/update branches. Check branches amount doesn't exced the maxBranches limit of the hired plan.
General admin can update company fields.
General admin can add/remove/update product categories and product base.
General admin can add , update, remove users to any branch and assign/remove roles. Check users amount doesn't exced the maxUsers limit of the hired plan. (1)
Admin can add, update, remove users to the branch he belongs and assign/remove admin role. Idem (1)
Admin and general admin can add, update, remove price lists and discounts. A discount can be applied to a price list and or to an item.
All logged users can add/remove/duplicate/update items. Each time an item amount or currency changes, a record on price history must be saved.
All logged users can add/remove/update products. A product can has attributes and or codes. They have a value and an attributeType. For example: size medium size is the attribute type, medium is the attribute value. Or SKU 12341, SKU is the attribute type and 12341 is the attribute value.
Check products amount doesn't exced the maxProducts limit of the hired plan.

Entities left:
Item, Product, Attribute Value, Attribute type,
Hired Plan and its dependencies
Price list, discount, price history
Purchase, Purchase Detail

Requirements:
I'll provide a GitHub repository, you will commit to it frequently.
You will provide a Postman collection or similar for API testing

React Native with ionic - Developer needed

ASP.NET Core – CRUD Using Angular And Entity Framework Core

Step - 1: Overview
In this article, I am going to create a web application using ASP.NET Core 3.1 and Angular 8.0 with the help of Entity Framework Core database first approach. I will be creating a sample Employee Record Management system. To read the inputs from the user, we are using Angular Forms with required field validations on the client-side. We are also going to bind a dropdown list in the Angular Form to a table in the database using EF Core. We will also learn how to deploy this application on IIS.

Step - 2 Required Tools
Install .NET Core 3.1 or above SDK from here.
Install the latest version of Visual Studio 2019 Community Edition from here.
Download and install the latest version of Node.js from here.
SQL Server 2008 or above.

We will be using Visual Studio 2017 and SQL Server 2012 or other like 2014, 2016, etc.

Step - 3 Database
We will be using two tables to store our data.

Employee: – Used to store the details of the employee. It contains fields such as EmployeeID, Name, City, Department, and Gender.
Cities: – This contains the list of cities and used to populate the City field of the Employee table. It contains two fields CityID and CityName.


CREATE TABLE Employee (
EmployeeID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
Name varchar(20) NOT NULL ,
City varchar(20) NOT NULL ,
Department varchar(20) NOT NULL ,
Gender varchar(6) NOT NULL
)
GO
CREATE TABLE Cities (
CityID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
CityName varchar(20) NOT NULL
)
GO
STEP - 4 Create MVC Web Application
Open Visual Studio and select File >> New >> Project.
After selecting the project, a “New Project” dialog will open. Select .NET Core inside the Visual C# menu
Then, select “ASP.NET Core 3.1 Web Application” from available project types. Put the name of the project as Proapp and press OK.e Model to the Application
We are using Entity Framework core database first approach to create our models. Navigate to Tools >> NuGet Package Manager >> Package Manager Console.
We have to install the package for the database provider that we are targeting which is SQL Server in this case. Hence run the following command:

Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
Scaffold-DbContext "Your connection string here" Microsoft.EntityFrameworkCore.SqlServer -
OutputDir Models -Tables tblEmployee, tblCities

Top 50 - Angular 8 Interview Questions & Answers

Microsoft SEAL is an easy-to-use and powerful open source homomorphic encryption library,

Microsoft SEAL is an easy-to-use and powerful open-source homomorphic encryption library, developed by researchers in the Cryptography and Privacy Research Group at Microsoft Research. Microsoft SEAL is licensed under the MIT license.
How to use this Microsoft SEAL open source  in .net

Examples : -