Clifford Chance Deputy Manager 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. Tell me about your self
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

Q1. About ur self, ceo of our company
Add your answer
Q2. Tell me about Oops concept
Ans. 
Oops concept is a programming paradigm that focuses on objects and their interactions.
• Oops stands for Object-Oriented Programming System

• It emphasizes on encapsulation, inheritance, and polymorphism

• Encapsulation is the process of hiding the implementation details of an object from the outside world

• Inheritance allows a class to inherit properties and methods from another class

• Polymorphism allows objects of different clas...read more
Answered by AI
Add your answer

Q1. Introduction and why u want to join us
Add your answer

Q1. Introduction of your self and y sales
Add your answer

Q1. Your kra What is Branding How would you manage a team
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

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