Deloitte
1500+ Spell Inspire Overseas Academy Interview Questions and Answers
Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
Entry for travel expenses incurred and reimbursed by employee
Employee submits travel expense report with receipts
Finance team verifies and approves the report
Entry is made in the accounting system debiting travel expense and crediting accounts payable
Once reimbursement is made, entry is made debiting accounts payable and crediting cash/bank account
Q2. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .....
read moreCode to calculate number of people in a room at EOD given X enter and Y leave throughout the day.
Create a variable to keep track of the current number of people in the room
Increment the variable by X every time someone enters the room
Decrement the variable by Y every time someone leaves the room
Return the final value of the variable at the end of the day
Example: If 10 people enter and 5 leave, there will be 5 people in the room at EOD
Write a program to generate the reverse of a given number N. Print the corresponding reverse number.
Note : If a number has trailing zeros, then its reverse will not include them. For e.g., r...read more
Q4. If you are given an array of 6 numbers 123345 give the logic for finding the duplicate numbers in this array Other technical questions where purely based on what we say previously. When I talked about my course...
read moreLogic to find duplicate numbers in an array of 6 numbers
Iterate through the array and compare each element with the rest of the elements
If a match is found, print the duplicate number
Use nested loops to compare all elements
Alternatively, use a hash table to keep track of seen elements
You have been given an integer array/list(ARR) of size N that contains only integers, 0 and 1. Write a function to sort this array/list. Think of a solution which scans the array/list only once and don'...read more
The function sorts an integer array containing only 0s and 1s in linear time complexity.
Use two pointers, one starting from the beginning and the other from the end of the array.
Swap the elements at the pointers if the element at the beginning pointer is 1 and the element at the end pointer is 0.
Continue moving the pointers towards each other until they meet in the middle of the array.
Q6. Your client wants to enter the after sales service market for passenger cars – 1. How would you segment the customer base? How can you use it to target your services? 2. Examine the cost structure of your clien...
read moreSegmenting customer base and differentiating cost structure for after sales service market entry
Segment customer base based on demographics, usage patterns, and brand preferences
Target services based on customer needs and preferences
Differentiate cost structure by offering competitive pricing, bundled services, and loyalty programs
Offer value-added services such as extended warranties, maintenance packages, and roadside assistance
Leverage technology to improve service deliver...read more
Given a N * N matrix and the task is to check matrix is idempotent matrix or not.
See the sample input.
Idempotent matrix M follows the following property :
M*M = M
Input format :
Line 1 : Siz...read more
You have been given an Encrypted String where repetitions of substrings are represented as substring followed by the count of substrings.
Example: String "aabbbcdcdcd" wil...read more
Q9. What is the journal entry for prepaid expenses and how do you treat it?
Prepaid expenses are initially recorded as assets and then expensed over time as they are used.
Prepaid expenses are recorded as assets on the balance sheet
Journal entry: Debit Prepaid Expense, Credit Cash/Bank
As the prepaid expense is used, it is expensed and moved from the balance sheet to the income statement
Journal entry: Debit Expense, Credit Prepaid Expense
Q10. Scenario : 2 Talend jobs related to each other. If one fails somehow,the other shouldn't. How to do that?
Use Talend job dependencies to ensure one job doesn't fail if the other does.
Create a parent job that calls both jobs as child jobs
Use the OnSubjobOk and OnSubjobError triggers to handle success and failure of child jobs
Set the 'Die on child error' option to false in the parent job to ensure it continues even if a child job fails
You have been given a Binary Search Tree of integers. You are supposed to convert it to a greater sum tree such that the value of every node in the given BST is replaced with ...read more
The task is to convert a Binary Search Tree into a Greater Sum Tree.
Traverse the BST in reverse inorder (right, root, left) to visit nodes in descending order.
Keep track of the sum of all greater nodes encountered so far.
Update the value of each node by adding the sum of greater nodes and update the sum.
Continue this process until all nodes have been visited.
Return the modified BST.
Q12. Suppose you are testing an application and you find a bug and now you assigned that bug to a developer but he revert by saying he is not getting this bug in his system. What will you do ?
Discuss with the developer and provide detailed steps to reproduce the bug.
Ask the developer to check the environment and configuration settings.
Provide screenshots and detailed steps to reproduce the bug.
Collaborate with the developer to find a solution.
If necessary, escalate the issue to the project manager.
Q13. How Profit and Loss account, Balance Sheet and Cash flow statement are different from each other? Usage of theses.
Profit and Loss account, Balance Sheet, and Cash flow statement are different financial statements used for different purposes.
Profit and Loss account shows the company's revenues, expenses, and net profit or loss over a specific period.
Balance Sheet provides a snapshot of a company's financial position at a specific point in time, showing its assets, liabilities, and shareholders' equity.
Cash flow statement tracks the inflow and outflow of cash in a company, providing inform...read more
Q14. what are the differences between stored procedure and triggers in SQL?
Stored procedures are precompiled SQL statements that can be executed on demand, while triggers are automatically executed in response to specific events.
Stored procedures are explicitly called by the user, while triggers are automatically invoked by the database system.
Stored procedures can accept parameters and return values, while triggers cannot.
Stored procedures can be executed independently, while triggers are always associated with a specific table or view.
Stored proce...read more
You are given an array/list ‘ARR’ consisting of ‘N’ distinct integers arranged in ascending order. You are also given an integer ‘TARGET’. Your task is to count all the distinct pairs in ‘ARR’ such that...read more
You have been given an integer array/list(ARR) of size 'N'. It only contains 0s, 1s and 2s. Write a solution to sort this array/list.
Note :
Try to solve the problem in 'Single Scan'. ' Single Scan' r...read more
Q17. You want to enter the ice cream market in in Jammu. Let us say a Baskin Robbins store. What all would you do?
To enter the ice cream market in Jammu, I would establish a Baskin Robbins store by conducting market research, selecting a suitable location, creating a unique menu, implementing effective marketing strategies, and ensuring high-quality customer service.
Conduct market research to understand the demand for ice cream in Jammu and identify potential competitors.
Select a prime location with high foot traffic, preferably in a popular shopping area or near tourist attractions.
Crea...read more
Q18. 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.
Q19. Guesstimate: ‘How much would a tea seller earn in a year by selling a tea on the roadside joint in Mumbai’
The tea seller in a roadside joint in Mumbai can earn an average annual income of around INR 2,40,000.
The average price of a cup of tea in Mumbai is around INR 10.
Assuming the tea seller sells 100 cups of tea per day, the daily revenue would be INR 1,000.
Considering the tea seller operates 300 days a year, the annual revenue would be INR 3,00,000.
After deducting expenses like rent, ingredients, and wages, the tea seller's net income could be around INR 2,40,000.
OOPS concepts.
What is SQL and NO SQL database?
What is difference between Stored procedures and functions?
Q21. Scenario : Create one talend job which will read may be 1 csv file today, next day 2 or more csv files and process it.
Create a Talend job to read and process varying numbers of CSV files
Use a tFileList component to dynamically retrieve the CSV files
Use a tFlowToIterate component to iterate over the files
Use a tFileInputDelimited component to read the CSV files
Process the data as required using other Talend components
Use a tLogRow component to output the results
Q22. What is the cycel of RTR
RTR cycle refers to the Record to Report cycle, which is the process of recording financial transactions and preparing financial statements.
RTR cycle involves several steps such as data collection, journal entry preparation, general ledger reconciliation, and financial statement preparation.
Data collection involves gathering information about financial transactions from various sources.
Journal entry preparation involves recording the transactions in the general ledger.
General...read more
Q23. Why do you think Infrastructure in India is a high growth sector ?
Infrastructure in India is a high growth sector due to increasing urbanization, government initiatives, and foreign investments.
India's urban population is expected to reach 600 million by 2030, leading to a demand for better infrastructure
The government's initiatives like Smart Cities Mission, Bharatmala Project, and Sagarmala Project are driving infrastructure development
Foreign investments in infrastructure projects like Delhi-Mumbai Industrial Corridor and Chennai-Bangalo...read more
Q24. Write a trigger to update contact when accounts phone changed.
Trigger to update contact when accounts phone changed
Create a trigger on Account object
Query for related Contacts
Update Contact phone field with Account phone field value
You have been given an undirected graph with 'N' vertices and 'M' edges. The vertices are labelled from 1 to 'N'.
Your task is to find if the graph contains a cycle or not.
A ...read more
Q26. 1. can we extract related object from parent object and vice versa and how? 2. what is sharing rules and what all things can you do using it? 3. flows 4. features of permission sets ( i included expiring of prm...
read moreInterview questions for Salesforce Consultant
Extract related object from parent object and vice versa using relationship fields
Sharing rules control access to records based on criteria
Flows automate business processes
Permission sets grant additional permissions to users
Frameworks like Apex and Lightning provide structure for development
Role hierarchy determines access to records based on job function
Plugins like Salesforce Inspector help with debugging
Mandatory fields can be ...read more
You have been given two Strings “STR1” and “STR2” of characters. Your task is to find the length of the longest common subsequence.
A String ‘a’ is a subsequence of a String ‘b’ if ‘a’...read more
You are given a number 'N' in the form of a string 'S', which is a palindrome. You need to find the greatest number strictly less than 'N' which is also a palindrome.
Note:
1. A palindrom...read more
Q29. Sql is installed on the server for enable which port needs to be open?
Port 1433 needs to be open for SQL Server.
SQL Server uses port 1433 for communication.
Ensure that port 1433 is open in the server's firewall.
Check the SQL Server configuration to confirm the port number.
Q30. What if you have unlimited budget but only two areas to spend on where will you spend?
Invest in research and development and employee training.
Invest in research and development to drive innovation and stay ahead of competitors.
Allocate funds for employee training and development to enhance skills and expertise.
Examples: Setting up state-of-the-art R&D facilities, hiring top researchers, conducting market research, organizing training programs and workshops.
Q31. You have to design a database for library. Which language will u prefer?
I would prefer using SQL for designing a database for a library.
SQL is a widely used language for managing relational databases.
It provides a structured and efficient way to store, retrieve, and manipulate data.
SQL allows for easy querying and joining of tables, which is essential for library operations.
It supports transactions and ensures data integrity.
SQL also offers various security features to protect sensitive library information.
You have given a sorted array 'A' of 'N' integers.
Now, you are given 'Q' queries, and each query consists of a single integer 'X'. Your task is to check whether 'X' is present in a...read more
Q33. 1. Guess the total no. of order complaints placed on the major online food delivery service in the location of your choice. 2. Guess the total no. of executives assigned for customer service department in the o...
read moreThe total number of order complaints on major online food delivery service in a chosen location can vary based on factors like population, service quality, and competition.
The total number of order complaints can be influenced by the size of the population in the chosen location. Higher population may result in more orders and potentially more complaints.
Service quality plays a crucial role in the number of order complaints. If the delivery service consistently fails to meet ...read more
Q34. Find out positions of numbers form an array whose sum is 9.
The positions of numbers in an array whose sum is 9 need to be found.
Iterate through the array and check for pairs of numbers that add up to 9.
Store the positions of the numbers that satisfy the condition.
Return the positions as the result.
Q35. How to get some orders in a specific date range, with the help of Shopify API
To get orders in a specific date range using Shopify API
Use the Orders API endpoint with the 'created_at_min' and 'created_at_max' parameters to specify the date range
Format the date range in ISO 8601 format
Example: GET /admin/api/2021-07/orders.json?created_at_min=2021-07-01T00:00:00-04:00&created_at_max=2021-07-31T23:59:59-04:00
You have been given a binary tree of integers. Your task is to print the boundary nodes of this binary tree in an Anti-Clockwise direction starting from the root node.
NOTE: The boundary nodes...read more
Q37. write a small query to get the details of employee whose department id is not available
Query to get details of employee with missing department id
Use SELECT statement to retrieve employee details
Filter the results using WHERE clause to only include employees with missing department id
Example: SELECT * FROM employees WHERE department_id IS NULL
Q38. Is it possible to convert bytecode in Java back to original code and how to do it?
Yes, it is possible to decompile bytecode in Java back to the original code.
Decompilation is the process of converting bytecode back to its original source code.
There are several tools available for decompiling Java bytecode, such as JD-GUI, FernFlower, and Procyon.
Decompiling bytecode can be useful for understanding how a program works, reverse engineering, or debugging.
However, the decompiled code may not be an exact replica of the original source code, as some information ...read more
Q39. What I think of issues related to formation of new states such as Telangana
The formation of new states like Telangana raises various issues and considerations.
The historical, cultural, and linguistic aspects of the region play a significant role in the formation of new states.
Political and administrative implications need to be carefully evaluated.
Economic viability and resource distribution are important factors to consider.
Social harmony and potential conflicts between different communities should be addressed.
The impact on neighboring states and ...read more
Q40. A big multinational computer($8 billion)hardware and software services company is planning to de-merge its business into two units -hardware business and software services / consulting business. After the de-me...
read moreThe strategy for the division of IT systems in the de-merger of the multinational computer hardware and software services company.
For Applications: Evaluate the criticality and interdependencies of each application, prioritize based on business needs, and allocate resources accordingly.
For Data Centers: Assess the capacity and redundancy requirements of each unit, consolidate or establish new data centers as needed, and ensure seamless transition of data and services.
For Test...read more
Q41. If C drive is running out of space , what kind of troubleshooting you will do.
To troubleshoot a C drive running out of space, check for large files, uninstall unnecessary programs, clear temporary files, and consider expanding storage capacity.
Check for large files that can be deleted or moved to another drive
Uninstall unnecessary programs to free up space
Clear temporary files using disk cleanup tools
Consider expanding storage capacity by adding a new hard drive or using external storage
Q42. What is the difference between accounting and audit
Accounting is the process of recording financial transactions, while audit is the examination of financial statements.
Accounting involves the recording, classifying, and summarizing of financial transactions.
Audit involves the examination of financial statements to ensure they are accurate and comply with accounting standards.
Accounting is done on a regular basis, while audit is done periodically.
Accounting is done by the company's own accountants, while audit is done by exte...read more
Q43. Who regulates Markets in US? Responsibilities of their Market regulator?
The Securities and Exchange Commission (SEC) regulates markets in the US. Their responsibilities include enforcing federal securities laws, protecting investors, and maintaining fair and orderly markets.
The SEC is responsible for overseeing securities exchanges such as the New York Stock Exchange (NYSE) and NASDAQ.
They enforce laws such as the Securities Act of 1933 and the Securities Exchange Act of 1934.
The SEC also regulates investment advisers, mutual funds, and other inv...read more
Q44. How would you build flipkart from a $100m company to a billion dollar one?
To build Flipkart from a $100m company to a billion dollar one, focus on expanding product offerings, improving customer experience, and expanding into new markets.
Expand product offerings to attract a wider customer base
Improve customer experience through personalized recommendations, faster delivery, and easy returns
Invest in technology infrastructure to handle increased traffic and improve website performance
Expand into new markets, both domestically and internationally
For...read more
Q45. Explain the concept of inheritance in Java .What is its use?
Inheritance in Java allows a class to inherit properties and methods from another class, promoting code reuse.
Inheritance is achieved using the 'extends' keyword in Java.
The class that is being inherited from is called the superclass or parent class.
The class that inherits from the superclass is called the subclass or child class.
The subclass can access the public and protected members of the superclass.
Inheritance promotes code reuse and allows for the creation of more speci...read more
Q46. How much Foreign Direct Investment is coming into India ?
India received $64 billion in FDI in 2020-21, a 10% increase from the previous year.
India is one of the top FDI destinations in the world.
Major sectors attracting FDI include services, computer software and hardware, and telecommunications.
Singapore, Mauritius, and the United States are the top sources of FDI in India.
The Indian government has implemented various policies to attract more FDI, such as liberalizing FDI norms and creating special economic zones.
Q47. Can we do functional testing at any stage of the development ?
Yes, functional testing can be done at any stage of development.
Functional testing can be done at any stage of development.
It helps in identifying defects early on in the development cycle.
It ensures that the software meets the functional requirements.
Examples of functional testing include unit testing, integration testing, and system testing.
Q48. What are the important use cases in SIEM on which you have worked?
Important use cases in SIEM
Threat detection and response
Compliance management
Incident investigation
User activity monitoring
Network traffic analysis
Log management and analysis
Q49. Can create automation scripts for non regression test case? If yes then explain
Yes, automation scripts can be created for non regression test cases.
Automation scripts can be created using tools like Selenium, Appium, etc.
These scripts can be used to automate repetitive test cases that need to be executed frequently.
Non regression test cases are used to ensure that new changes or updates to the system do not break existing functionality.
Automation of non regression test cases can save time and effort in manual testing.
However, it is important to regularl...read more
Write query for selecting top 10 rows of an employee table?
Then he asked which topics I am comfortable with.I answered Dbms and Os.So he asked me few questions from Dbms
1. What are different...read more
Q51. Estimate market size for an American nutrition food maker, who is planning to launch a product in Indian market. There is an existing player in Indian market with a not so good product.
Estimating market size for an American nutrition food maker planning to launch in the Indian market.
Analyze the current market size and growth rate of the nutrition food industry in India.
Identify the target audience and their preferences for nutrition food products.
Assess the market share and performance of the existing player with a not so good product.
Evaluate the potential demand for a high-quality nutrition food product in India.
Consider factors such as population size, ...read more
Q52. What is PE Ratio? How is it used? What ERP have you worked on and a little about that? Cost and profit variances? Liquidity ratios?
PE Ratio is a valuation ratio that compares a company's current share price to its per-share earnings.
PE Ratio = Market Price per Share / Earnings per Share
It is used to determine if a stock is overvalued or undervalued
Example: A company with a PE ratio of 20 means investors are willing to pay $20 for every $1 of earnings
ERP (Enterprise Resource Planning) systems automate and integrate business processes
Cost variances are the differences between actual and budgeted costs
Profi...read more
Q53. What is the Difference between GraphQL API and REST API
GraphQL API allows clients to request only the data they need, while REST API returns fixed data structures.
GraphQL allows clients to request only the data they need, reducing over-fetching and under-fetching.
REST API returns fixed data structures, which can lead to over-fetching or under-fetching of data.
GraphQL uses a single endpoint for all data requests, while REST API uses multiple endpoints for different resources.
GraphQL provides a more flexible and efficient way to qu...read more
Q54. How to show different products in different regions in shopify
To show different products in different regions in Shopify, use the Shopify Plus feature called 'Script Editor'.
Use the 'Script Editor' feature in Shopify Plus to create scripts that show/hide products based on customer's location
Utilize geolocation apps or services to determine customer's location
Create different collections for each region and assign products accordingly
Q55. Case Questions: Estimate the number of shoes sold in Hyderabad in a year(Case type:Guesstimate)
Estimate the number of shoes sold in Hyderabad in a year.
Consider the population of Hyderabad and the percentage of people who wear shoes
Factor in the income level of the population and their purchasing power
Look at the number of shoe stores in Hyderabad and their average sales per day
Consider the seasonality of shoe sales, such as during festivals or weddings
Take into account the lifespan of a pair of shoes and the frequency of replacement
You are given an array 'ARR' of N integers. Each integer represents the height of a balloon. So, there are N balloons lined up.
Your aim is to destroy all these balloons. Now, a balloon can onl...read more
Q57. A Telecommunication giant has been mandated by the Indonesia government to provide internet services to all the residents of the country. The company is already a player in the market, providing other services ...
read moreAs a Deloitte consultant, I would proceed by conducting a feasibility study and developing a comprehensive strategy.
Conduct a feasibility study to assess the current infrastructure and identify gaps
Develop a comprehensive strategy that includes network expansion, technology upgrades, and partnerships with local providers
Establish a project management team to oversee the implementation of the strategy
Engage with stakeholders, including government officials, to ensure complianc...read more
Q58. What is the diifference between cyber kill chain and mitre framework?
Cyber kill chain and MITRE framework are both used for cyber threat intelligence, but differ in their approach and focus.
Cyber kill chain focuses on the different stages of a cyber attack, from reconnaissance to exfiltration.
MITRE framework focuses on the tactics and techniques used by attackers, and maps them to specific threat actors.
Cyber kill chain is more focused on the technical aspects of an attack, while MITRE framework takes into account the broader context of the at...read more
Q59. Tell me some highly recommended test scenarios for ATM machine ?
Test scenarios for ATM machine
Testing card insertion and removal
Testing PIN entry and validation
Testing cash withdrawal and balance inquiry
Testing receipt printing
Testing network connectivity and response time
Q60. Choco bar sales of a company is going down in last two months. Sales given below: Month 1: 55000 Month 2: 55000 Month 3: 60000 Month 4: 60000 Month 5: 25000 Month 6: 10000
The company's choco bar sales have been declining in the last two months.
Sales remained constant at 55,000 units for the first two months.
Sales increased to 60,000 units for the next two months.
Sales dropped significantly to 25,000 units in the fifth month.
Sales further decreased to 10,000 units in the sixth month.
Q61. What were the most important events in the past year which affected global supply chains?
The COVID-19 pandemic and trade tensions were the most important events affecting global supply chains.
The COVID-19 pandemic caused disruptions in supply chains due to lockdowns, travel restrictions, and reduced demand.
Trade tensions between the US and China led to tariffs and uncertainty, affecting global trade and supply chains.
Natural disasters such as hurricanes and wildfires also impacted supply chains, causing delays and shortages.
The Suez Canal blockage in March 2021 c...read more
Q62. How to find the minimum number from a given set of numbers ?
To find the minimum number from a set of numbers, compare each number with the others and select the smallest.
Compare each number with the others in the set
Select the smallest number as the minimum
Q63. What is difference between article and section tag?
Article and section tags are used for structuring HTML documents, but have different semantic meanings.
The
tag represents a self-contained piece of content that can be distributed independently from the rest of the page. The
tag represents a group of related content, typically with a heading. The
tag is often used for blog posts, news articles, and product descriptions. The
tag is often used for chapters, sections, and sub-sections of a document. Both tags can be nested withi...read more
Q64. 2. When and How Selenium throws State Element Exception? How to handle this scenario ?
Selenium throws State Element Exception when the element is not in the expected state.
This exception is thrown when the element is not clickable, visible, or enabled.
To handle this scenario, wait for the element to be in the expected state using explicit or implicit waits.
Alternatively, try to locate the element again or use a different locator strategy.
Example: driver.findElement(By.id("elementId")).click() may throw State Element Exception if the element is not clickable.
Ex...read more
Q65. If 4 warehouses were combined how would the inventory levels change?
Combining 4 warehouses would affect inventory levels. How?
Inventory levels would increase due to consolidation of stock
There may be redundancies in inventory that could be eliminated
The combined warehouse may have more efficient inventory management systems
The location of the combined warehouse may affect inventory levels for certain products
Q66. What are the different rate limits in Shopify API?
Shopify API has different rate limits for different endpoints and actions.
Shopify API has a default rate limit of 2 requests per second per shop.
Certain endpoints have specific rate limits, such as 40 requests per second for the GraphQL Admin API.
Rate limits can vary based on the type of request and the endpoint being accessed.
Exceeding rate limits can result in HTTP 429 Too Many Requests responses.
Q67. Case Questions: What is the difference between ‘risk’ and ‘flexibility’?
Risk and flexibility are two different concepts. Risk is the possibility of loss or harm, while flexibility is the ability to adapt to changing circumstances.
Risk refers to the potential negative consequences of a decision or action, while flexibility refers to the ability to adjust to changing circumstances.
Risk is often associated with uncertainty and the potential for loss, while flexibility is associated with adaptability and the ability to respond to new situations.
For e...read more
Q68. How to find Largest element in the array wid most efficiency?
Use a loop to iterate through the array and keep track of the largest element.
Initialize a variable to store the largest element as the first element of the array
Loop through the array and compare each element to the current largest element
If the current element is larger, update the largest element variable
Return the largest element variable
Q69. how to call a stored procedure without using stored procedure
It is not possible to call a stored procedure without using a stored procedure.
Stored procedures are designed to be called from within a database.
Attempting to call a stored procedure without using a stored procedure would defeat the purpose of having a stored procedure.
If you need to execute a set of SQL statements without using a stored procedure, you can use a script or a batch file.
Q70. What are the different CVEs that you have encountered?
I have encountered various CVEs related to software vulnerabilities.
CVE-2019-0708 (BlueKeep) - Remote code execution vulnerability in Microsoft Windows
CVE-2017-5638 - Remote code execution vulnerability in Apache Struts
CVE-2014-0160 (Heartbleed) - Information disclosure vulnerability in OpenSSL
CVE-2018-11776 - Remote code execution vulnerability in Apache Struts
CVE-2018-8174 - Remote code execution vulnerability in Microsoft Windows
CVE-2019-11510 - Information disclosure vuln...read more
Q71. What is incident response cycle? Kindly explain it.
The incident response cycle is a process that organizations follow to respond to and manage security incidents.
The cycle typically includes preparation, identification, containment, eradication, recovery, and lessons learned.
Preparation involves creating incident response plans and training staff.
Identification involves detecting and analyzing potential security incidents.
Containment involves isolating the incident to prevent further damage.
Eradication involves removing the c...read more
Q72. What are key controls in Procurement to payment process?
Key controls in Procurement to payment process include segregation of duties, approval hierarchy, and invoice matching.
Segregation of duties to prevent fraud and errors
Approval hierarchy to ensure proper authorization
Invoice matching to verify accuracy of invoices
Vendor master data management to prevent duplicate or fraudulent vendors
Purchase order management to ensure goods/services are received as ordered
Contract management to ensure compliance with terms and conditions
Paym...read more
Q73. 4) How to send the values without using sendkeys method?
Values can be sent without using sendkeys method by directly manipulating the DOM or using JavaScriptExecutor.
Use JavaScriptExecutor to execute JavaScript code to set values of input fields.
Find the element using appropriate locators and then use JavaScriptExecutor to set the value.
Example: driver.executeScript("document.getElementById('elementId').value='text'");
Q74. If you have created the server , some website is not working . what will you do.
I would check the server logs and troubleshoot the issue.
Check if the website is properly configured on the server
Check if there are any errors in the server logs
Check if there are any issues with the website's code or database
Restart the server or relevant services if necessary
Q75. Two VM's are running on differenct host how they are communicating.
VMs communicate through network protocols and virtual switches.
VMs use network protocols like TCP/IP to communicate.
Virtual switches connect VMs to the physical network.
Hosts can also use virtual network adapters to communicate with VMs.
Firewalls and security policies can restrict VM communication.
Examples of virtual switches include VMware vSwitch and Hyper-V Virtual Switch.
Q76. How will you perform feature selection in market mix models?
Feature selection in market mix models involves identifying and selecting the most relevant variables to include in the model.
Start by analyzing the correlation between each feature and the target variable.
Use techniques like stepwise regression, LASSO, or random forest to identify the most important features.
Consider domain knowledge and business objectives when selecting features.
Regularly evaluate and update the selected features to ensure model accuracy.
Q77. how to run second session after completion of first session
To run a second session after completion of the first session, follow these steps:
Ensure that all necessary resources are available for the second session
Communicate with participants to confirm their availability for the second session
Review the outcomes of the first session and adjust the agenda for the second session accordingly
Schedule the second session at a convenient time and location
Send out reminders to participants prior to the second session
Q78. what type of testing u have used what's ur test strategy plan
I have used various types of testing such as functional, regression, performance, and security testing. My test strategy plan involves identifying test scenarios, creating test cases, executing tests, and reporting defects.
Functional testing to ensure the software meets the specified requirements
Regression testing to ensure new changes do not affect existing functionality
Performance testing to ensure the software can handle expected load and response times
Security testing to ...read more
Q79. I was asked to project the daily sales revenue of a renowned restaurant in the nearby city area
To project daily sales revenue of a restaurant, analyze past sales data, consider current market trends, and factor in any upcoming events or promotions.
Analyze past sales data to identify patterns and trends
Consider current market trends and competition
Factor in any upcoming events or promotions that may impact sales
Use forecasting models to project future sales revenue
Adjust projections based on seasonality and other external factors
Q80. 13) What is requestSpecification? What is serialization and how to achieve this?
requestSpecification is a class in RestAssured library used to define the request details for API testing.
It is used to set the base URI, path, headers, query parameters, etc. for the API request.
It allows customization of the request before sending it.
Serialization is the process of converting an object into a format that can be stored or transmitted.
In API testing, serialization is used to convert Java objects into JSON or XML format for API request or response.
To achieve s...read more
Q81. What are the important protocols with their port numbers?
Important protocols with their port numbers
HTTP - 80
HTTPS - 443
FTP - 21
SSH - 22
SMTP - 25
DNS - 53
POP3 - 110
IMAP - 143
LDAP - 389
SNMP - 161
RDP - 3389
Q82. Can we debug AMDP and CDS?
Yes, we can debug AMDP and CDS.
We can debug AMDP using ABAP debugger or Eclipse debugger.
We can debug CDS using Eclipse debugger or SQL Trace.
For AMDP, we can set breakpoints in the method and debug it.
For CDS, we can use SQL Trace to analyze the SQL statements generated by CDS view.
Debugging helps in identifying and fixing issues in the code.
Q83. You know Normalizastion? Tell me what is 3rd normal form
3rd normal form is a database normalization technique where every non-key attribute is dependent on the primary key.
In 3NF, there should be no transitive dependencies between non-key attributes.
It reduces data redundancy and improves data integrity.
Example: A table with columns for customer ID, order ID, and product ID. The product name should not be stored in this table as it is dependent on the product ID, not the customer or order ID.
Another example: A table with columns f...read more
Q84. Diff bw c and .py *How rate Ur self in .py *Types of data types *Diff bw list Nd tuple *How many operators in .py *Oops concepts *Inheritance with example *Polymorphism *Write program for even numbers from 0-10...
read moreInterview questions for AWS Cloud Engineer including Python basics, OOP concepts, and video editing skills.
Differentiate between C and Python
Rate yourself in Python
Types of data types in Python
Difference between list and tuple in Python
Number of operators in Python
Object-oriented programming concepts
Example of inheritance in Python
Polymorphism in Python
Program to print even numbers from 0-100 in Python
Video editing skills using CyberLink PowerDirector 15 Ultimate
Q85. How do you set up or use Jmeter for performance testing?
JMeter is a tool for performance testing. Here's how to set it up and use it.
Download and install JMeter
Create a test plan
Add thread groups and samplers
Configure the samplers with appropriate settings
Run the test and analyze the results
Q86. 1. Estimate the number of students doing coursework online on a Wednesday afternoon in Bangalore?
Estimating the number of students doing coursework online on a Wednesday afternoon in Bangalore.
Consider the total number of students in Bangalore
Identify the percentage of students who prefer online coursework
Take into account the day of the week (Wednesday) and the time of the day (afternoon)
Consider factors like availability of internet access and infrastructure
Gather data from educational institutions, online platforms, and surveys
Use statistical methods to estimate the n...read more
Q87. what logs to refer Software Update fails? What cycles to initiate? how the patches will be deployed ( Deployment or direct updates?
Refer to SCCM logs for software update fails. Initiate cycles and deploy patches through deployment or direct updates.
Refer to SCCM logs such as UpdatesDeployment.log, UpdatesHandler.log, and WUAHandler.log for software update fails
Initiate cycles such as Software Update Scan Cycle, Software Update Deployment Evaluation Cycle, and Software Update Deployment Cycle
Deploy patches through Deployment or Direct Updates depending on the organization's requirements and policies
Deploy...read more
Q88. - If you had to choose between two processes which give the same outcome, but one of them is longer but more accurate and the other is short but less accurate, which one would you choose?
I would choose the longer but more accurate process.
Accuracy is crucial in decision-making and can have long-term consequences.
Investing more time in a process can lead to better outcomes and prevent costly mistakes.
Examples: Medical diagnosis, financial analysis, scientific research.
Q89. 8) What is the Bank Reconciliation Statement? Explain with a practical example?
Bank Reconciliation Statement is a document that matches the bank balance with the company's balance.
It is used to identify any discrepancies between the two balances.
It includes items such as outstanding checks, deposits in transit, and bank fees.
A practical example would be comparing the company's records of deposits and withdrawals with the bank statement to ensure accuracy.
Any differences found are then investigated and resolved.
The end result is a reconciled balance that...read more
Q90. Case - Client is an ice cream manufacturer and is facing stockouts and delays. How will you help them manage their finished goods inventory? Round 1 - 25 minutes
Helping an ice cream manufacturer manage finished goods inventory
Analyze demand patterns and forecast future demand
Optimize production and scheduling to reduce delays
Implement safety stock levels to prevent stockouts
Consider outsourcing production or increasing capacity
Evaluate distribution channels and optimize logistics
Implement a real-time inventory tracking system
Q91. What is Persona in Analysis?Zero sprint- Informal meeting
Persona in analysis refers to creating fictional characters that represent the target audience to better understand their needs and behaviors.
Personas are created based on research and data collected about the target audience.
They help in designing products and services that meet the needs of the target audience.
Personas are often given names, demographics, and personal characteristics to make them more relatable.
For example, a persona for a fitness app could be 'Active Annie...read more
Q92. How do components interact with each other in Angular?
Components interact with each other through inputs, outputs, and services.
Components can pass data to child components through inputs.
Components can emit events to parent components through outputs.
Components can share data and functionality through services.
Components can also communicate through the @ViewChild and @ContentChild decorators.
Example: A parent component passes data to a child component through an input property.
Example: A child component emits an event to a par...read more
Q93. How will you Audit the bank balance appearing in financial statements?
Bank balance in financial statements can be audited by verifying bank statements, reconciling balances, and testing internal controls.
Verify bank statements to ensure accuracy of reported balance
Reconcile bank balance with general ledger balance
Test internal controls related to bank transactions
Confirm balances with the bank directly
Review any unusual transactions or discrepancies
Consider the risk of fraud or error in bank transactions
Q94. If you are a thief and you have an option which shop will you steal? Why? 1) Chandeliers shop. 2) Flower shop 3) Bakery.
I would steal from the bakery because it is likely to have cash on hand and valuable equipment.
Bakeries often have cash on hand from daily sales.
Bakeries may have valuable equipment like ovens or mixers.
Flower shops may not have much cash and chandeliers shops may have high security measures.
Q95. What is the purpose of retesting while you already doing integraton testing ?
Retesting during integration testing ensures that defects have been fixed and new defects have not been introduced.
Retesting ensures that previously identified defects have been fixed
Retesting also ensures that new defects have not been introduced during integration testing
Retesting helps to ensure the overall quality of the software product
Q96. What would be your approach of test execution if you are working on a bank application ?
My approach would be to prioritize security and compliance testing, followed by functional and performance testing.
Conduct security testing to ensure customer data is protected
Verify compliance with banking regulations and standards
Test functionality of key features such as account creation and transactions
Perform load testing to ensure application can handle high traffic
Test for usability and accessibility for all users
Conduct regression testing to ensure updates do not impa...read more
Q97. Our client manufactures a screen protector. Should he enter the market or not?
Yes, the client should enter the market.
There is a high demand for screen protectors in the market.
Entering the market will allow the client to capitalize on the growing smartphone industry.
Competitors are already present in the market, indicating its viability.
The client can leverage their manufacturing capabilities to produce high-quality screen protectors at a competitive price.
Market research and analysis can provide further insights into potential profitability.
Q98. Which development methodology is used water fall or agile
It depends on the project requirements and team preferences.
Waterfall is a linear approach while Agile is iterative.
Waterfall is best suited for projects with well-defined requirements.
Agile is best suited for projects with changing requirements.
Waterfall requires extensive planning upfront while Agile focuses on adaptability.
Examples of companies using Agile include Spotify and Google.
Examples of companies using Waterfall include NASA and the military.
Q99. Difference between synchrounous and asynchronous processes in nodejs
Synchronous processes block the execution until completion, while asynchronous processes allow the program to continue executing without waiting.
Synchronous processes wait for a task to finish before moving on to the next one.
Asynchronous processes allow multiple tasks to be executed simultaneously.
Node.js uses asynchronous processes to handle I/O operations efficiently.
Example: Reading a file synchronously will block the program until the file is fully read, while reading it...read more
Q100. Batch calls in OData, association and navigation in OData?
Batch calls allow multiple requests in a single HTTP call. Associations and navigation allow querying related data in OData.
Batch calls can improve performance by reducing the number of HTTP requests.
Associations define relationships between entities in OData.
Navigation allows querying related entities using the $expand query option.
Example: /Orders?$expand=Customer
Example: /Customers('ALFKI')/Orders
More about working at Deloitte
Top HR Questions asked in Spell Inspire Overseas Academy
Interview Process at Spell Inspire Overseas Academy
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month