Deloitte Intern Interview Questions, Process, and Tips

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

Easy , two programming questions and they were easy leetcode problems

Q1. Who is in your family
Add your answer
Q2. What does your father do
Add your answer

Q1. Tell me about yourself and CV related questions
Add your answer

Q1. Any question related to bba
Add your answer
Q2. Any question related to internship
Add your answer
Q3. Any company related one
Add your answer
Q4. Job related one to bba
Add your answer

Average it was good not that bad however and whatever