Clifford Chance Module Lead Interview Questions and Answers for Experienced

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. Java collection , Spring boot, mucroservices
Add your answer
Q2. Java 8 features , File handling
Add your answer

Basic problems on strings and arrays

Q1. Full detailed questions on .net technologies
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. About security standard
Add your answer

Q1. Security standards
Add your answer

Some aptitudes reasoning question , verbal, non verbal

Coding language, html, css, java script, knowledge check

Q1. Tell me about yourself ?
Add your answer
Q2. You really want join this company?
Add your answer
Q3. How much you motivate for join this company
Add your answer
Q4. How you see yourself after 5 years
Add your answer

Some questions were from velocity and time distance and some questions from basics maths

Q1. Why do u want to join us
Ans. Tell me how much time you can stay here
Answered Anonymously
Add your answer

Q1. Tell me about ur self
Add your answer