Assam State Legal Services Authority Interview Questions and Answers

Q1. Excel formulas u knew
Ans. 
I am familiar with a variety of Excel formulas including VLOOKUP, SUMIF, COUNTIF, INDEX/MATCH, and IF functions.
• VLOOKUP: Used to search for a value in a table and return a corresponding value from another column.

• SUMIF: Adds the cells specified by a given condition or criteria.

• COUNTIF: Counts the number of cells within a range that meet a certain condition.

• INDEX/MATCH: Used together to look up a value in a table based o...read more
Answered by AI
Add your answer
Q2. Power query questions
Add your answer

Aptitude based on distance, time and pattern matching

Coding Test include Basic Question of DSA

Q1. Explain your Project?
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used HTML, CSS, and JavaScript for front-end development

• Utilized Node.js and Express for back-end development

• Implemented user authentication and authorization using JWT tokens

• Integrated with MongoDB for database storage
Answered by AI
Add your answer
Q2. Why do want to be a Software Developer?
Ans. 
I am passionate about problem-solving, enjoy coding, and want to contribute to innovative technology solutions.
• Passionate about problem-solving

• Enjoy coding and building software

• Want to contribute to innovative technology solutions
Answered by AI
Add your answer

Q1. Related to past experience and current role
Add your answer

Q1. Same as in 1st round
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. Basic details around experience
Add your answer

Q1. Basic details and system design
Add your answer

Q1. Coding for a solution
Add your answer

Q1. What are statics functions in OOPS
Ans. 
Static functions in OOP are functions that belong to the class itself, rather than to instances of the class.
• Static functions can be called without creating an instance of the class.

• They are commonly used for utility functions that do not require access to instance-specific data.

• Static functions are declared using the 'static' keyword in many programming languages.

• Example: In Java, a static function in a class can be c
Answered by AI
Add your answer
Q2. What is Polymorphism in OOPs
Ans. 
Polymorphism in OOPs allows objects of different classes to be treated as objects of a common superclass.
• Polymorphism allows methods to be called on objects of different classes that all inherit from a common superclass.

• It enables a single interface to be used for different data types or classes.

• Examples include method overriding in inheritance and method overloading within the same class.
Answered by AI
Add your answer
Q3. What is websockets and its alternative
Ans. 
Websockets are a communication protocol that allows for full-duplex communication between a client and a server over a single, long-lived connection.
• Websockets provide real-time, bi-directional communication between a client and a server.

• They are commonly used in applications that require instant updates, such as chat applications, online gaming, and financial trading platforms.

• Websockets use a persistent connection, u...read more
Answered by AI
Add your answer
Q4. What is JWT and How it works
Ans. 
JWT stands for JSON Web Token, a compact and self-contained way for securely transmitting information between parties as a JSON object.
• JWT is composed of three parts: header, payload, and signature.

• Header typically consists of the type of token and the hashing algorithm being used.

• Payload contains the claims, which are statements about an entity and additional data.

• Signature is created by encoding the header, payload, ...read more
Answered by AI
Add your answer

2 coding questions 1 easy ,1 hard , 20 MCQ question and 1 SQL question

Q1. Asked questions of coding round
Add your answer
Q2. Questions about project ,jwt architecture,nextjs vs react
Add your answer

Q1. 2 SQL query using group by
Add your answer
Q2. Question about projects and cs fundamentals
Add your answer

Two hours and 32 questions

Q1. Write commands for DML
Ans. 
DML commands are used to manipulate data in a database. Examples include INSERT, UPDATE, DELETE.
• INSERT: Adds new data into a table

• UPDATE: Modifies existing data in a table

• DELETE: Removes data from a table
Answered by AI
Add your answer
Q2. Write commands for Joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• INNER JOIN: Returns rows when there is at least one match in both tables

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

• FULL JOIN: Returns rows when there is a match in one of the tables
Answered by AI
Add your answer

Q1. Ask questions regarding advance excel
Add your answer
Q2. Ask questions from Power BI
Add your answer