Deloitte
10+ Snapdeal Interview Questions and Answers
Q1. Case : I am a US based company and I sell 3 products A, B, C (I don’t rem exact name) and I am having losses. I assume the reason for facing losses can be either economic downturn, new competitors, or internal ...
read moreThe exact reason for facing losses cannot be determined without further analysis.
Further analysis is needed to identify the root cause of the losses.
Economic downturn, new competitors, and internal problems are all potential factors.
Examples of internal problems could include poor management, inefficient processes, or high overhead costs.
Q2. difference between agile and waterfall methodology of development (methods used in IT industry)
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
Examples of agile methodologies include Scrum and Kanban
Examples o...read more
Q3. A cable box manufacturer wants to outsource manufacturing
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 contracts to ensure quality and timely delivery
Q4. Accounting standard that deal with Asset, and depreciation
The accounting standard that deals with asset and depreciation is IAS 16.
IAS 16 stands for International Accounting Standard 16.
It provides guidance on how to account for property, plant, and equipment.
It also covers the recognition, measurement, and depreciation of assets.
Depreciation is the systematic allocation of the cost of an asset over its useful life.
Examples of assets covered by IAS 16 include buildings, machinery, and vehicles.
Q5. Direct and indirect taxes. Difference and types.
Direct taxes are paid directly to the government while indirect taxes are paid indirectly through goods and services.
Direct taxes are based on income or wealth, such as income tax, property tax, and corporate tax.
Indirect taxes are based on consumption, such as sales tax, excise tax, and value-added tax (VAT).
Direct taxes are progressive, meaning the more you earn, the higher percentage of tax you pay. Indirect taxes are regressive, meaning everyone pays the same percentage r...read more
Q6. What are intangible Asset ?
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 for companies as they can provide a competitive advantage and ...read more
Q7. What are different types of transactions in SQL
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 (e.g. COMMIT, ROLLBACK)
Q8. What ISO/IEC 27001
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 regulatory bodies.
Examples of organizations that have implemented ISO/IE...read more
Q9. What is DMZ?
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 DMZ devices include firewalls, routers, and switches
Q10. What is Google Dork?
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.
Q11. What is PCI-DSS?
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, access control, and regular monitoring and testing.
Compliance wi...read more
Q12. Difference between truncate and delete
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 transaction log, while delete is.
Q13. write SQL joins inner
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
More about working at Deloitte
Top HR Questions asked in Snapdeal
Interview Process at Snapdeal
Top Intern Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month