LEK Consulting Intern Interview Questions and Answers

Normal level questions, 20 questions were there and they were little lengthy

Q1. What are different types of transactions in SQL
Ans. 
Different types of transactions in SQL include DML, DDL, DCL, and TCL.
• DML (Data Manipulation Language) - Used for manipulating data in a database (e.g. INSERT, UPDATE, DELETE)

• DDL (Data Definition Language) - Used for defining database schema (e.g. CREATE, ALTER, DROP)

• DCL (Data Control Language) - Used for controlling access to data (e.g. GRANT, REVOKE)

• TCL (Transaction Control Language) - Used for managing transactions
Answered by AI
Add your answer
Q2. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.
• Truncate is faster and uses less system resources compared to delete.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Truncate is not logged in the
Answered by AI
Add your answer

Q1. List a few concepts you learnt in your previous internship ?
Add your answer

Allm maths and probability

Q1. Oops concept specifer constructor
Add your answer

Q1. What is strength
Ans. 
Strength is the ability to overcome challenges and obstacles, both physically and mentally.
• Physical strength is the ability to exert force and lift heavy objects.

• Mental strength is the ability to stay resilient in the face of adversity.

• Strength can also refer to emotional resilience and the ability to cope with difficult situations.

• Strength can be developed through consistent practice and perseverance.

• Examples of stren...read more
Answered by AI
Add your answer

Was moderate in term of difficulty

Took a long time to finish

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in Computer Science and a passion for software development.
• Recent graduate with a degree in Computer Science

• Passionate about software development

• Experience with programming languages such as Java, Python, and JavaScript
Answered by AI
Add your answer
Q2. Explain your project on resumw
Ans. 
Developed a mobile app for tracking daily water intake and setting hydration goals.
• Designed user-friendly interface for inputting water consumption

• Implemented reminder notifications to encourage regular hydration

• Incorporated gamification elements to motivate users to reach their hydration goals
Answered by AI
Add your answer

Case studies on Profitability/Growth for a stock broker player

Q1. Why do you need this job
Add your answer

30 min. Aptitude logical reasoning

Commercial topics it may be any thing