SQL
Ramling
This type is the default return type of a method that does not return any value.
What is void?
This method is used to render a React component into the DOM.
What is ReactDOM.render()?
This type of join returns all records when there is a match in either the left or right table.
What is a FULL OUTER JOIN?
This keyword is used to inherit a class in C#.
What is : (colon)?
This lifecycle method is invoked immediately after a component is added to the DOM.
What is componentDidMount()?
What is a SQL Injection Attack and how do you protect yourself against these?
SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution in order to effect the execution of predefined SQL commands.
A SQL Injection attack is a form of attack that comes from user input that has not been checked to see that it is valid. The objective is to fool the database system into running malicious code that will reveal sensitive information or otherwise compromise the server.
You protect from SQL Injection Attacks using a combination of stored procedures and parameters. Stored procedures alone will not protect against SQL injection attacks, because you still need use the stored procedure correctly. See here.
What are the .Net objects and classes used to communicate and execute commands at the database?
The SqlConnection Object
The SqlCommand Object
The SqlDataReader Object
The DataSet Object
The SqlDataAdapter Object
The SqlParameter Object
This hook is used to manage complex state logic and side effects in functional components.
What is useReducer()?
In T-SQL, this keyword is used to create a stored procedure.
What is CREATE PROCEDURE?
This ADO.NET object is used to execute a command against a database and return the number of rows affected.
What is SqlCommand?
This hook can be used to prevent unnecessary re-renders by memoizing values or functions
What is useMemo() or useCallback()?
explain cluster vs non cluster index
A clustered index is used to define the order or to sort the table or arrange the data by alphabetical order just like a dictionary. A non-clustered index collects the data at one place and records at another place.
This .NET feature helps improve performance by reducing the need to allocate new memory for small, commonly used objects.
What is the .NET String Intern Pool or String Interning?
What are higher order components.
Higher Order Component is an advanced way of reusing the component logic. Basically, it’s a pattern that is derived from React’s compositional nature. HOC are custom components which wraps another component within it. They can accept any dynamically provided child component but they won’t modify or copy any behavior from their input components. You can say that HOC are ‘pure’ components.