Proserv Interview Questions and Answers

The command to run the server in Angular is 'ng serve'

• Use the command 'ng serve' in the terminal to start the server

• Make sure you are in the root directory of your Angular project before running the command

• You can add additional flags like '--open' to automatically open the browser after starting the server

Indexing in MySQL improves the speed of data retrieval by creating a sorted reference to the data.

• Indexes in MySQL are used to quickly locate rows in a table without having to search the entire table.

• They are created on columns in a table to speed up the query process.

• Indexes can be created using a single column or multiple columns for better performance.

• Examples of indexes in MySQL include primary keys, unique keys, and full-text indexes.

State in React JS is managed using component state or Redux for global state management.

• Use component state to manage local state within a component

• Use Redux for global state management across multiple components

• Update state using setState() method in class components or useState() hook in functional components

Join query in MySQL is used to combine rows from two or more tables based on a related column between them.

• Use JOIN keyword to combine tables

• Specify the columns to join on using ON keyword

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

NFT is a unique digital asset stored on a blockchain that represents ownership of a specific item or piece of content.

• NFT stands for Non-Fungible Token

• NFTs are created using blockchain technology

• Each NFT is unique and cannot be replicated

• NFTs can represent anything from digital art to virtual real estate

• NFTs are bought and sold using cryptocurrency