J. Sagar Associates Senior Associate Interview Questions and Answers

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

Q1. Enforcement of Equitable Mortgage and Registered Mortgage
Ans. 
Enforcement of Equitable Mortgage and Registered Mortgage involves different legal processes and remedies.
• Equitable mortgage is created by deposit of title deeds while registered mortgage is created by registration with the land registry.

• Enforcement of equitable mortgage involves filing a suit for foreclosure or sale of the property.

• Enforcement of registered mortgage involves initiating foreclosure proceedings through ...read more
Answered by AI
Add your answer
Q2. Types of mortgage
Ans. 
There are various types of mortgages, including fixed-rate, adjustable-rate, FHA, VA, and jumbo loans.
• Fixed-rate mortgages have a set interest rate for the entire term of the loan.

• Adjustable-rate mortgages have an interest rate that can change periodically.

• FHA loans are insured by the Federal Housing Administration and often require a lower down payment.

• VA loans are guaranteed by the Department of Veterans Affairs and ...read more
Answered by AI
Add your answer

General aptitude and descriptive questions to check communication skills

Drafting and prosecution assignment

Q1. Roles in previous organisations
Ans. 
I have held various roles in previous organisations including project manager, team leader, and sales associate.
• Project manager responsible for overseeing and executing multiple projects simultaneously

• Team leader in charge of guiding and motivating team members to achieve goals

• Sales associate focused on building relationships with clients and driving revenue

• Experience in collaborating with cross-functional teams and st
Answered by AI
Add your answer

Q1. Questions pertaining to current affairs of law
Add your answer
Q2. Questions on updates will be asked
Add your answer

Q1. Will examine your fitness with firm culture
Add your answer

Online test of 2 hrs
Cased based

Q1. Salary negotiation Joining date Work culture Submission of necessary documents
Add your answer
Q2. Why do you want to join this company? Your contribution to the company?
Add your answer