Faircode Technologies Interview Questions and Answers

UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.

• UNION removes duplicate rows from the result set, while UNION ALL includes all rows

• UNION is slower than UNION ALL because it performs a distinct operation

• UNION requires that all SELECT statements have the same number of columns with compatible data types

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table...read more

Clustered index determines the physical order of data in a table, while non-clustered index does not.

• Clustered index physically reorders the table data based on the indexed column

• Non-clustered index creates a separate structure to store the index data

• Clustered index is faster for retrieval but slower for insert and update operations

• Non-clustered index is slower for retrieval but faster for insert and update operations

The .NET Framework is a software framework developed by Microsoft that provides a large library of pre-coded solutions to common programming problems.

• Developed by Microsoft

• Provides a large library of pre-coded solutions

• Supports multiple programming languages

• Used for building applications for Windows, web, mobile, and cloud

• Consists of Common Language Runtime (CLR) and class library

LINQ stands for Language Integrated Query.

• LINQ is a set of features introduced in .NET Framework that allows for querying data from different data sources using a uniform syntax.

• LINQ can be used to query objects, databases, XML, and more.

• LINQ provides a consistent model for working with data regardless of the data source.

• Example: var query = from c in customers where c.City == 'London' select c;

Optimizing a React application involves reducing bundle size, improving rendering performance, and implementing code splitting.

• Use code splitting to load only necessary code for each page

• Minimize bundle size by removing unused dependencies and optimizing images

• Use React.memo and shouldComponentUpdate to prevent unnecessary re-renders

• Use lazy loading to defer loading of non-critical components

• Use server-side rendering to improve initial load time

• Use performance profiling tools...read more

A pure function is a function that always returns the same output for a given input and has no side effects.

• Pure functions are deterministic and have no side effects.

• They only depend on their input parameters and not on any external state.

• Pure functions are easier to test and reason about than impure functions.

• Examples of pure functions include mathematical functions like sin(x) and cos(x).

Shadow DOM is a way to encapsulate the styling and behavior of a web component.

• Shadow DOM allows for creating isolated DOM trees within a larger document.

• It helps to prevent CSS conflicts and JavaScript collisions between different parts of a web page.

• Shadow DOM can be used to create reusable web components that can be easily shared and used across different projects.

• It is supported by all modern browsers including Chrome, Firefox, Safari, and Edge.