AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Deloitte
Compare
Filter interviews by
Deloitte Intern Interview Questions and Answers
13 Interview questions
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 i...
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 transact...
SQL joins are used to combine rows from two or more tables based on a related column between them.
Use INNER JOIN keyword to return rows when there is at least one match in both tables
Specify the columns to join on using ON keyword
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Google Dork is a search query that uses advanced search operators to find sensitive information on the internet.
Google Dork can be used to find vulnerabilities in websites and servers.
It can also be used to find usernames, passwords, and other sensitive information.
Examples of Google Dork include: site:example.com intitle:index.of password
Google Dorking can be used for both ethical and unethical purposes.
What people are saying about Deloitte
PCI-DSS stands for Payment Card Industry Data Security Standard.
It is a set of security standards designed to ensure that all companies that accept, process, store or transmit credit card information maintain a secure environment.
It was created by major credit card companies such as Visa, Mastercard, American Express, Discover, and JCB International.
It includes requirements for network security, data protection, a...
DMZ stands for Demilitarized Zone. It is a network security zone that separates an internal network from an external network.
DMZ is a buffer zone between the internet and a private network
It is used to host public-facing servers like web servers, email servers, etc.
DMZ is designed to prevent direct access to the internal network
It is a common security measure used in corporate networks and data centers
Examples of ...
Intangible assets are non-physical assets that have no intrinsic value but can generate revenue for a company.
Examples include patents, trademarks, copyrights, and goodwill.
They are not physical in nature and cannot be touched or seen.
They are recorded on a company's balance sheet and can be bought, sold, or licensed.
Their value is determined by their ability to generate future economic benefits.
They are important...
Outsourcing manufacturing is a common practice for many companies to reduce costs and increase efficiency.
Outsourcing can provide access to specialized skills and technology
It can also reduce labor costs and overhead expenses
However, outsourcing can also lead to quality control issues and communication challenges
The cable box manufacturer should carefully evaluate potential outsourcing partners and negotiate clear...
Agile is iterative and flexible, while waterfall is linear and rigid.
Agile focuses on delivering working software in short iterations
Waterfall follows a sequential approach with distinct phases
Agile encourages collaboration and adaptability
Waterfall emphasizes planning and documentation
Agile is better suited for complex and uncertain projects
Waterfall is better suited for projects with well-defined requirements
Exa...
ISO/IEC 27001 is a standard for information security management systems.
It provides a framework for managing and protecting sensitive information.
It includes requirements for risk assessment, security controls, and continuous improvement.
Compliance with ISO/IEC 27001 can help organizations demonstrate their commitment to information security.
Certification to the standard is often required by customers or regulator...
Deloitte Intern Interview Experiences
22 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
Normal level questions, 20 questions were there and they were little lengthy
(2 Questions)
- 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 ...
- 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...
Interview Preparation Tips
Skills evaluated in this interview
Easy , two programming questions and they were easy leetcode problems
(2 Questions)
- Q1. Who is in your family
- Q2. What does your father do
Interview Preparation Tips
(1 Question)
- Q1. Tell me about yourself and CV related questions
I applied via AmbitionBox and was interviewed in Jul 2023. There were 3 interview rounds.
(4 Questions)
- Q1. Any question related to bba
- Q2. Any question related to internship
- Q3. Any company related one
- Q4. Job related one to bba
Average it was good not that bad however and whatever
(2 Questions)
- Q1. 1) General Discussion on Qualification ? 2) About my Aspiration on learning new technologies ? 3) About my Family ?
- Q2. 1) General Discussion on my Qualification ? 2) About my Aspiration on learning new technologies ?
(1 Question)
- Q1. Write SQL joins inner
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them.
Use INNER JOIN keyword to return rows when there is at least one match in both tables
Specify the columns to join on using ON keyword
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Feb 2023. There was 1 interview round.
(2 Questions)
- Q1. Describe a situation where you handled a conflict.
- Ans.
I resolved a conflict between team members by facilitating open communication and finding common ground to reach a solution.
Identified the conflict: Two team members disagreed on project direction.
Facilitated a meeting: Encouraged both to express their viewpoints.
Promoted active listening: Ensured each person felt heard and understood.
Found common ground: Highlighted shared goals and objectives.
Developed a compromise: ...
- Q2. If you have to refute a senior at a meeting, how would you approach it?
- Ans.
Approach refuting a senior with respect, evidence, and constructive dialogue to maintain professionalism and foster collaboration.
1. Prepare thoroughly: Gather data and evidence to support your viewpoint. For example, if discussing a treatment plan, reference recent studies.
2. Choose the right moment: Wait for an appropriate time to present your perspective, ensuring it doesn't disrupt the flow of the meeting.
3. Use re...
Interview Preparation Tips
(2 Questions)
- Q1. Be confident and be aware
- Q2. Why should we hire you
(1 Question)
- Q1. Why do u want to work in hr
- Ans.
I am passionate about HR because it plays a crucial role in shaping organizational culture and supporting employee growth.
People-Centric Role: HR is all about understanding and supporting employees, which aligns with my passion for helping others. For example, I enjoy mentoring peers.
Organizational Development: I want to contribute to creating a positive workplace culture. In my previous role, I organized team-building...
Selected
I appeared for an interview before Oct 2022.
(3 Questions)
- Q1. Introduce yourself
- Q2. What is your opinion about DEI
- Ans.
DEI stands for Diversity, Equity, and Inclusion, promoting a fair and inclusive environment for all individuals.
Diversity: Embracing a variety of backgrounds, perspectives, and experiences, such as hiring individuals from different ethnicities and genders.
Equity: Ensuring fair treatment and access to opportunities, like providing mentorship programs for underrepresented groups.
Inclusion: Creating an environment where e...
- Q3. Why Consulting?
(2 Questions)
- Q1. Why do you want to join Deloitte?
- Ans.
Joining Deloitte offers exposure to diverse projects, a strong learning environment, and a commitment to innovation and excellence.
Global Presence: Deloitte operates in over 150 countries, providing opportunities to work on international projects and collaborate with diverse teams.
Professional Development: The firm invests heavily in training and development programs, such as Deloitte University, which enhances skills ...
- Q2. Are you more suitable for a research intensive role?
- Ans.
I possess strong analytical skills and a passion for discovery, making me well-suited for a research-intensive role.
Analytical Skills: I excel in analyzing complex data sets, as demonstrated in my previous project where I conducted a thorough literature review.
Attention to Detail: My meticulous nature ensures accuracy in research, which was crucial during my internship when I validated experimental results.
Curiosity an...
(1 Question)
- Q1. Case study on change management
Jordan Chow
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There was 1 interview round.
I was given an option of completing 1 of 3 assignments regarding artificial intelligence and presentation, to be submitted in 3 days. This was after a short interview with one of the managers in the department.
Deloitte Interview FAQs
Some of the top questions asked at the Deloitte Intern interview -
The duration of Deloitte Intern interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 11 interview experiences
Difficulty level
Duration
Intern Interview Questions from Similar Companies
Deloitte Intern Reviews and Ratings
based on 114 reviews
Rating in categories
|
Consultant
40k
salaries
|  ₹10 L/yr - ₹21.5 L/yr |
|
Senior Consultant
24.8k
salaries
| ₹16.6 L/yr - ₹33.3 L/yr |
|
Analyst
16.6k
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Assistant Manager
11.3k
salaries
| ₹12.1 L/yr - ₹22 L/yr |
|
Manager
7.9k
salaries
| ₹24.6 L/yr - ₹43.7 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions
