UnitedLex Associate Document Review Interview Questions and Answers

Q1. What you are currently doing?
Add your answer
Q2. Why are you changing job?
Add your answer

Q1. Quizzed on SQL and other technical questions.
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

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. Background and Experience?
Add your answer
Q2. About Your Education and Work Experience.
Add your answer

Q1. What are the important things you check while processing the invoice?
Ans. 
Important things to check while processing invoices include accuracy, proper documentation, approval, and matching with purchase orders.
• Verify accuracy of invoice details such as amounts, dates, and vendor information

• Ensure proper documentation is attached, such as receipts or purchase orders

• Confirm approval from authorized personnel before processing payment

• Match the invoice with corresponding purchase orders to preve
Answered by AI
Add your answer
Q2. Invoice Bill to address, Invoice Date, Currency, Tax Rate, Tax Amount, Description, Total Amount.
Add your answer

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