Accenture
90+ Abt Foods Interview Questions and Answers
Q1. Automerge Jobs In Informatica MDM? Running Synchronization Batch Jobs After Changes To Trust Settings In Informatica MDM? Defining Trust Settings For Base Objects In Informatica MDM? How Informatica MDM Hub Han...
read moreA list of questions related to Informatica MDM and its processes.
Automerging jobs in Informatica MDM
Defining trust settings for base objects
Loading data into Siperian Hub
Match rules and tokenization in Informatica MDM
Data loading stages and components of Informatica Hub Console
Q2. why HTML semantic elements, doctype is used why, which will seen in browser in which order, different units of css attributes, js call by value or refrence with example, diff let &const and let & var, diff arro...
read moreHTML semantic elements are used for better structure and accessibility, doctype is used to specify the version of HTML, different CSS units include px, %, em, etc., JavaScript can call by value or reference, let and const are block-scoped while var is function-scoped, arrow functions are more concise than regular functions, sessionStorage is tab-specific while localStorage is window-specific, media queries are used for responsive design, flexbox is used for flexible layouts i...read more
Q3. What is the procedure you have followed when critical priority issues are hitting the application? What will be your response to the customer??
I prioritize the issue based on its impact and severity, communicate with the team, and provide timely updates to the customer.
Assess the impact and severity of the issue
Communicate with the team to gather more information and work on a solution
Provide timely updates to the customer on the progress and expected resolution time
Ensure that the issue is resolved as quickly as possible without compromising on quality
Conduct a post-mortem analysis to identify the root cause and pr...read more
Q4. What are the differences between ECC and HANA on depreciation AFAB?
ECC and HANA differ in depreciation AFAB due to HANA's in-memory computing and real-time processing capabilities.
ECC uses a batch processing approach for depreciation AFAB, while HANA uses real-time processing.
HANA's in-memory computing allows for faster processing and analysis of large amounts of data.
HANA also offers predictive analytics capabilities for more accurate forecasting of depreciation.
ECC may require additional hardware and maintenance costs compared to HANA.
HANA...read more
Q5. What approach are taken before defining a scenario of the test data?
Various approaches are taken before defining a scenario of the test data.
Understanding the requirements of the system
Identifying the types of data needed for testing
Creating a data model or schema
Generating test data based on the model
Ensuring data privacy and security
Q6. What do you mean by Scrum Ceremonies?
Scrum ceremonies are regular meetings held by Scrum teams to plan, review, and adapt their work.
Scrum ceremonies include Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective.
Sprint Planning is held at the beginning of each sprint to plan the work to be done.
Daily Scrum is a daily meeting where team members discuss progress and plan for the day.
Sprint Review is held at the end of each sprint to review the work done and get feedback from stakeholders.
Sprint Ret...read more
Q7. What is the importance of checking the requirement document before Testing Process starts?
Checking requirement document before testing process is important for successful testing.
Requirement document helps in understanding the expected behavior of the application.
It helps in identifying any missing or incomplete requirements.
It helps in creating test cases that cover all the requirements.
It helps in avoiding unnecessary rework and delays in the testing process.
Example: If the requirement document states that the application should be able to handle 1000 concurrent...read more
Q8. Difference between if and where?
if is a conditional statement used to execute code based on a condition. where is used to filter data in a query.
if is used in programming languages to execute code based on a condition
where is used in SQL to filter data in a query
if can have multiple conditions and can be nested
where can only have one condition per query
Q9. What are basic requirements during setting the environment for testing?
Basic requirements for setting up testing environment
Identify the scope of testing
Select appropriate hardware and software
Ensure availability of necessary tools and resources
Create test data and test cases
Establish communication channels for reporting issues
Define testing timelines and milestones
Q10. How to determine that the requirement of testing is over?
Testing requirements are determined by meeting acceptance criteria and achieving desired quality levels.
Testing requirements are met when all acceptance criteria are fulfilled.
Testing requirements are met when the desired quality levels are achieved.
Testing requirements may also be determined by the project timeline and budget constraints.
Testing requirements may also be determined by the risk associated with the application.
Testing requirements may also be determined by the ...read more
Q11. Syntax of proc format and difference between union and union all?
Proc format syntax and difference between union and union all
Proc format is used to create custom formats for variables in SAS
Syntax: proc format lib=library cntlin=dataset; value formatname low-high='label'; run;
Union combines the results of two or more SELECT statements, while Union All includes duplicates
Union All is faster but may return duplicate rows
Union requires sorting and removing duplicates, but returns only distinct rows
Q12. What is Spring framework, What are the different versions I have worked on, What is a controller in servlet, Rest API versions. What is marker interface, AWS, SQL.
Answering questions related to Spring framework, servlets, Rest API, marker interface, AWS, and SQL.
Spring framework is a popular Java framework used for building web applications.
I have worked on Spring 4 and Spring 5 versions.
A controller in servlet is a Java class that handles HTTP requests and generates HTTP responses.
Rest API versions include 1.0, 1.1, 2.0, and 3.0.
A marker interface is an interface that has no methods but is used to mark a class as having a certain beha...read more
Q13. Difference between proc means and proc summary? And ways to create macro variable?
Proc means and proc summary are SAS procedures used for summarizing data. Macro variables can be created using %let statement.
Proc means provides more detailed statistics like standard deviation, minimum and maximum values, while proc summary provides only basic statistics like count, sum, mean, etc.
Proc means can handle missing values by default, while proc summary requires the MISSING option to be specified.
Macro variables can be created using the %let statement followed by...read more
Q14. Project explaination, Difference between Java and C++, Examples for procedure-oriented and object-oriented language, Whether Python is procedure-oriented or object-oriented, OOPs concepts
Questions related to programming languages and OOPs concepts.
Java and C++ are both object-oriented languages, but C++ also supports procedural programming.
Procedure-oriented languages focus on procedures or functions, while object-oriented languages focus on objects.
Python is an object-oriented language, but it also supports procedural programming.
OOPs concepts include encapsulation, inheritance, polymorphism, and abstraction.
Q15. What is OOPS concept what is class what is inheritance what is Function what is Map what is sting
OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
Class is a blueprint for creating objects. It defines the properties and behaviors of objects.
Inheritance allows a class to inherit properties and methods from another class. It promotes code reusability.
Function is a block of code that performs a specific task. It can be called multiple times.
Map is a collection of key-value pairs where each key is un...read more
Q16. Flow of case creation and bulk email. What is better workflow or plugin?
It depends on the specific requirements and complexity of the case creation and bulk email process.
If the process is simple and straightforward, a workflow may suffice.
If the process involves complex logic and requires frequent updates, a plugin may be a better option.
Consider the cost and time required for development and maintenance of both options.
Evaluate the scalability and performance of both options.
Consult with stakeholders and developers to determine the best approac...read more
Q17. What is Category, Extension and what is the different b/w them
Category and Extension are terms used in file management. Category is a grouping of files based on their purpose, while Extension refers to the file type.
Category is a way of organizing files based on their function or purpose, such as work documents, personal photos, or music files.
Extension refers to the three or four letters at the end of a file name that indicate its type, such as .docx for a Microsoft Word document or .jpg for an image file.
The difference between them is...read more
Q18. What is the difference between Asynchronous and Synchronous Apex?
Asynchronous Apex allows for processing to continue while waiting for external processes, while Synchronous Apex waits for processes to complete before continuing.
Asynchronous Apex allows for long-running processes to run in the background without blocking the user interface.
Synchronous Apex executes in a single transaction and waits for processes to complete before moving on to the next step.
Examples of Asynchronous Apex include future methods, batch Apex, and queueable Apex...read more
Q19. Name few api of jvs and where have they been used?
Some popular Java APIs include JDBC, Servlet, and JavaMail.
JDBC (Java Database Connectivity) - used for connecting Java applications to databases
Servlet - used for developing web applications in Java
JavaMail - used for sending and receiving email in Java applications
Q20. How to copy the structure of table only?
To copy the structure of a table only, use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement with a WHERE clause that is always false to copy only the structure of the table.
Example: CREATE TABLE new_table AS SELECT * FROM existing_table WHERE 1=0;
Alternatively, use the SHOW CREATE TABLE statement to generate the SQL code for creating the table structure.
Example: SHOW CREATE TABLE existing_table;
Q21. What is the difference between implicit and explicit enhancement?
Implicit enhancements are modifications made to standard SAP objects without modifying the original code, while explicit enhancements involve adding custom code directly into the standard SAP objects.
Implicit enhancements are done using enhancement points or sections provided by SAP, allowing developers to add custom code without modifying the original object.
Explicit enhancements involve directly modifying the standard SAP object by adding custom code within the object itsel...read more
Q22. What do you mean by defect density?
Defect density refers to the number of defects found in a software component or system per unit of size or complexity.
Defect density is a metric used to measure the quality of software.
It is calculated by dividing the number of defects by the size or complexity of the software component or system.
Defect density can be used to identify areas of the software that need improvement.
For example, if a software component has a high defect density, it may indicate that there are issu...read more
Q23. Put NA if all the character variable are blank?
To check if all character variables are blank, we can use the COUNT function in SQL.
Use COUNT function to count the number of non-blank character variables.
If the count is zero, then all character variables are blank.
Example: SELECT COUNT(*) FROM table_name WHERE column_name <> '';
Q24. Who watched over Adhaar Card development in the country
The Unique Identification Authority of India (UIDAI) watched over Adhaar Card development in the country.
The Unique Identification Authority of India (UIDAI) was established in 2009 to manage the Aadhaar project.
UIDAI is responsible for the enrollment and authentication of Aadhaar cardholders.
UIDAI also oversees the security and privacy of Aadhaar data.
UIDAI has partnered with various government agencies and private organizations to implement Aadhaar-based services.
UIDAI has ...read more
Q25. What does %sysfunc do?
sysfunc is a SAS function used to execute system commands and return their output.
It can be used to execute operating system commands within SAS programs.
It can be used to retrieve system information such as the current date and time.
It can be used to manipulate character strings.
Example: %sysfunc(date(), word)
Example: %sysfunc(systeminfo, word)
Q26. Proc report and it's working and options in it?
Proc report is a SAS procedure used for creating tabular reports.
It allows for customization of column headers, footers, and data cells.
Options include sorting, grouping, and summarizing data.
Example: proc report data=mydata; column var1 var2 var3; run;
Example: proc report data=mydata; column var1 var2 var3; define var1 / group; run;
Q27. What is Future Method? How do we Define it?
Future method is a way to run asynchronous Apex code in Salesforce.
Future methods are annotated with @future and are used to run code asynchronously in Salesforce.
They are commonly used for long-running operations like callouts to external systems.
Future methods cannot return a value and must be static methods.
They are queued for execution and run in a separate thread, allowing the main thread to continue processing.
Example: @future public static void myFutureMethod() { // co...read more
Q28. Find the sum of each digit in a given string of number using Lambda expressions.
Use Lambda expressions to find sum of each digit in a string of numbers.
Convert each string of numbers to a list of integers using map and lambda function.
Use sum function to find the sum of all digits in the list.
Q29. What is a closure and some application of closures
A closure is a function that has access to variables in its outer scope. It can be used for data privacy and memoization.
Closures can be used to create private variables and methods in JavaScript.
They can also be used for memoization, where the result of a function call is cached for future use.
Closures are commonly used in event handling and callbacks.
Example: function counter() { let count = 0; return function() { return ++count; } }
Example: function memoize(func) { let cac...read more
Q30. What is DOM? Difference between == and ====
DOM stands for Document Object Model. == is a loose equality comparison, while === is a strict equality comparison.
DOM is a programming interface for web documents.
== checks for equality after type coercion, while === checks for equality without type coercion.
Example: 1 == '1' is true, but 1 === '1' is false.
Q31. Working of streams in java. How are they executed?
Streams in Java are sequences of elements that support functional-style operations. They are executed lazily.
Streams are created from collections, arrays, or I/O resources.
Operations on streams are either intermediate (e.g. filter, map) or terminal (e.g. forEach, collect).
Stream operations are executed only when a terminal operation is invoked.
Streams can be parallelized to improve performance using parallelStream() method.
Q32. How to find commutative sum?
Commutative sum is the sum of two numbers that remains the same even if the order of the numbers is reversed.
Add two numbers
Reverse the order of the numbers
Check if the sum remains the same
Q33. What is organisational and merchandising heirarchy
Organisational and merchandising hierarchy refers to the structure and arrangement of departments, products, and services within a company.
Organisational hierarchy refers to the levels of management and reporting within a company.
Merchandising hierarchy refers to the arrangement of products and services within a company.
Both hierarchies are important for efficient operations and customer satisfaction.
Examples include a retail store with departments for clothing, electronics, ...read more
Q34. Determination of various entities like Route, Shipping Point, Item Category etc.
Various entities like Route, Shipping Point, Item Category are determined based on specific criteria.
Route is determined based on the origin and destination of the shipment.
Shipping Point is determined based on the location from where the shipment is being sent.
Item Category is determined based on the type of product being shipped.
Criteria for determining these entities may vary depending on the business requirements.
These entities are important for efficient and accurate shi...read more
Q35. What does %include do?
The %include directive is used in SAS programming to include external files or code snippets.
It allows for reusability of code
It can be used to include macro definitions or data sets
It can be used to include code from other SAS programs
Syntax: %include 'filename';
Q36. P2P cycle - how FI is integrated with MM
The FI (Financial Institution) is integrated with MM (Materials Management) in the P2P (Procure-to-Pay) cycle to facilitate seamless financial transactions.
The FI and MM systems are connected through interfaces or integration tools.
When a purchase requisition is created in MM, it triggers a purchase order in the FI system.
The FI system handles the financial aspects of the procurement process, such as vendor payments and invoice processing.
Integration between FI and MM ensures...read more
Q37. What is difference between == and ===
The difference between == and === is that == compares values while === compares both values and types.
The == operator compares values and coerces the types if necessary.
The === operator compares both values and types without coercion.
For example, 1 == '1' is true because the values are the same, but 1 === '1' is false because the types are different.
Q38. Find number of each alphabet occurrence in a given string
Count occurrences of each alphabet in a given string
Create an array of size 26 to store count of each alphabet
Iterate through the string and increment count for each alphabet
Use ASCII values to map characters to array indices
Handle both uppercase and lowercase characters separately
Q39. What are the other OOPS concepts
Other OOPS concepts include Inheritance, Polymorphism, Abstraction, and Encapsulation.
Inheritance allows a class to inherit properties and behavior from another class.
Polymorphism allows objects to be treated as instances of their parent class.
Abstraction hides the implementation details and only shows the necessary features.
Encapsulation bundles data and methods that operate on the data into a single unit.
Q40. Document type control which things?
Document type control manages the types of documents that can be created, accessed, and modified within a system.
Document type control determines the allowed file formats and extensions for documents.
It also controls the access permissions for different document types.
Document type control ensures consistency and standardization in document creation and management.
Examples include controlling the creation of PDF documents only, restricting access to confidential document type...read more
Q41. Steps of APP ( automatic payment program)
The automatic payment program (APP) is a process used to automate the payment of invoices.
Define payment methods and terms
Set up payment proposal
Review and adjust payment proposal
Execute payment run
Post payment documents
Q42. How do you monitor java app newrelic
Monitoring Java applications with New Relic involves setting up agents and configuring alerts.
Install New Relic Java agent in the application server
Configure New Relic settings in the newrelic.yml file
Set up custom dashboards and alerts in New Relic Insights
Monitor application performance metrics like response time, throughput, and error rate
Q43. Would you tell the difference between SQL and NoSQL DBs?
SQL is a relational database while NoSQL is a non-relational database.
SQL databases use tables to store data while NoSQL databases use documents, key-value pairs, or graphs.
SQL databases have a predefined schema while NoSQL databases have a dynamic schema.
SQL databases are good for complex queries and transactions while NoSQL databases are good for handling large amounts of unstructured data.
Examples of SQL databases include MySQL, Oracle, and PostgreSQL while examples of NoS...read more
Q44. what are the bug fixes you have done
I have fixed various bugs related to user interface, data processing, and system integration.
Resolved issues with incorrect data display on user interface
Fixed errors in data processing algorithms leading to inaccurate results
Addressed integration bugs causing system crashes
Optimized code for better performance and stability
Q45. Describe oops concepts
OOPs concepts are the fundamental principles of object-oriented programming.
Encapsulation - binding data and functions together
Inheritance - creating new classes from existing ones
Polymorphism - ability of objects to take on multiple forms
Abstraction - hiding implementation details from users
Q46. What is encapsulation and abstraction?
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit. Abstraction is the concept of hiding the complex implementation details and showing only the necessary features of an object.
Encapsulation helps in data hiding and prevents direct access to data from outside the class.
Abstraction helps in reducing complexity by hiding unnecessary details and showing only relevant information.
Encapsulation is achieved through access specifier...read more
Q47. What is oops concepts in java
Object-oriented programming concepts in Java
Encapsulation: Bundling data and methods that operate on the data into a single unit
Inheritance: Allows a class to inherit properties and behavior from another class
Polymorphism: Ability to present the same interface for different data types
Abstraction: Hiding the implementation details and showing only the necessary features
Example: Creating classes like Car, Truck, and Vehicle with inheritance hierarchy
Q48. Difference between const and readonly in c#
const is compile-time constant, readonly is runtime constant
const value is determined at compile time and cannot be changed, readonly value can be set at runtime but cannot be changed after initialization
const is static by default, readonly can be instance-level
const can be used for primitive data types, readonly can be used for complex types like classes or structs
Q49. Difference between varchar and nvarchar in SQL
varchar stores non-Unicode data, nvarchar stores Unicode data in SQL.
varchar is used for storing non-Unicode characters, nvarchar is used for storing Unicode characters.
varchar takes 1 byte per character, nvarchar takes 2 bytes per character.
varchar is more space-efficient but nvarchar supports a wider range of characters.
Q50. What is string
A string is a sequence of characters used to represent text.
Strings are typically enclosed in quotation marks, such as 'hello world'.
Strings can contain letters, numbers, symbols, and spaces.
Strings can be manipulated using various string functions like concatenation and substring extraction.
Q51. Notification flow in SAP Plant maintenance
Notification flow in SAP Plant maintenance
Notifications are created for maintenance tasks
Notifications can be created manually or automatically
Notifications can be assigned to a work order
Notifications can trigger notifications to other departments or individuals
Notifications can be tracked and monitored for status updates
Q52. How would you handle hot customers
Handle hot customers with patience, empathy, and professionalism.
Listen actively to their concerns and show empathy towards their frustrations.
Remain calm and composed, even if the customer is being difficult or angry.
Offer solutions or alternatives to address their issues in a timely manner.
Ensure clear communication and follow-up to keep the customer informed and satisfied.
Maintain a positive attitude and focus on resolving the issue to the best of your ability.
Q53. Program to find if number is divisible by 10
A program to check if a number is divisible by 10.
Check if the number is a multiple of 10
Use the modulo operator to check if the remainder is 0
Divide the number by 10 and check if the result is an integer
Q54. What is SFTP channel in SAP PI
SFTP channel in SAP PI is used for secure file transfer protocol communication.
SFTP channel is used to transfer files securely between systems in SAP PI
It uses SSH (Secure Shell) for encryption and authentication
SFTP channel configuration includes setting up host, port, user credentials, and file paths
It ensures data integrity and confidentiality during file transfer
Q55. Difficulties faced in implementing project
One of the difficulties faced in implementing a project is managing scope creep.
Managing scope creep can be challenging as it involves controlling changes to the project scope.
It requires constant communication with stakeholders to ensure that project requirements are clearly defined and any changes are properly evaluated.
Scope creep can lead to delays, increased costs, and potential conflicts within the project team.
For example, if a client requests additional features that ...read more
Q56. What are catchweight items
Catchweight items are products sold by weight that may vary in weight from package to package.
Catchweight items are commonly found in the food industry, such as meat, fish, and produce.
They are priced per unit of weight, but the actual weight of each package may vary.
This can create challenges for inventory management and pricing.
Catchweight items require specialized software to track inventory and sales accurately.
Q57. Difference between list and array list
List is a collection of elements of any data type while ArrayList is a resizable array implementation of List interface.
List is an interface while ArrayList is a class that implements List interface.
ArrayList can dynamically increase or decrease its size while List cannot.
ArrayList is faster for accessing elements while List is faster for adding or removing elements.
Example: List
names = new ArrayList<>(); Example: List
numbers = new LinkedList<>();
Q58. Explain the CI/CD pipeline flow?
CI/CD pipeline flow is a process of continuous integration and delivery of software applications.
The process starts with the development of code and its integration into a shared repository.
The code is then built and tested in an automated environment.
If the tests pass, the code is deployed to a staging environment for further testing.
Once the code passes all tests, it is deployed to production.
Continuous monitoring and feedback are provided to ensure the application is runni...read more
Q59. What is reflection in java?
Reflection in Java is a feature that allows a program to examine or modify its own structure at runtime.
Reflection allows you to inspect classes, interfaces, fields, and methods at runtime.
You can use reflection to instantiate objects, invoke methods, and access or modify fields dynamically.
Reflection is commonly used in frameworks like Spring and Hibernate for dependency injection and ORM mapping.
Example: Using reflection to dynamically load and execute a class or method.
Q60. Difference between ppulator and converter
Populator is used to fill data in a field while converter is used to change data format or type.
Populator fills data in a field based on certain criteria
Converter changes data format or type without altering the original data
Example: Populator can be used to automatically fill in a user's address based on their zip code, while converter can change a date from MM/DD/YYYY to YYYY-MM-DD
Q61. What is static code analyse?
Static code analysis is a method of analyzing software code without executing it.
It is a type of code review that checks for potential errors, security vulnerabilities, and coding standards compliance.
It can be done manually or with the help of automated tools.
Examples of static code analysis tools include SonarQube, Checkstyle, and PMD.
It helps to improve code quality and reduce the number of bugs in software applications.
Q62. Build mvc app using spring boot
Spring Boot is a framework that simplifies the development of Java applications. MVC architecture separates concerns for clean code.
Create a new Spring Boot project using Spring Initializr
Add dependencies for Spring Web and Thymeleaf for MVC support
Create controller, model, and view components to implement MVC pattern
Use annotations like @Controller, @RequestMapping, and @ModelAttribute for mapping requests
Q63. Describe sprint cycle and steps
Sprint cycle is a time-boxed period during which a specific amount of work must be completed.
Sprint cycle typically lasts 2-4 weeks
Steps include sprint planning, daily stand-ups, development, testing, and sprint review
At the end of the sprint, a working product increment should be delivered
Q64. What is payment method
Payment method refers to the way a customer pays for goods or services.
It can be cash, credit/debit card, bank transfer, or mobile payment.
Payment methods can vary by country and industry.
Some businesses may offer multiple payment options to cater to customer preferences.
Security and convenience are important factors to consider when choosing a payment method.
Q65. What are events in reports
Events in reports refer to specific occurrences or incidents that are recorded and analyzed within a report.
Events can include data points such as sales transactions, customer interactions, system errors, etc.
Events are typically organized and presented in a chronological order within a report.
Analyzing events in reports can help identify patterns, trends, and anomalies for decision-making.
Examples of events in reports include website traffic spikes, product returns, employee...read more
Q66. Performance tuning for ABAP objects?
Performance tuning for ABAP objects involves optimizing code, database queries, and system configurations.
Identify and eliminate unnecessary database calls
Use appropriate indexing for database tables
Optimize loops and data retrieval methods
Avoid nested SELECT statements
Leverage buffering techniques for frequently accessed data
Monitor and analyze performance using tools like SQL Trace and Runtime Analysis
Q67. What are platform events?
Platform events are high-performance, event-driven messaging services in Salesforce that enable real-time data processing.
Platform events allow developers to deliver secure, scalable, and customizable event notifications within Salesforce or external systems.
They are based on the publish-subscribe model, where publishers send events and subscribers receive them.
Platform events can trigger processes, update records, or notify external systems about changes in Salesforce data.
D...read more
Q68. Lifecycle of a deal in endur
Deal lifecycle in Endur involves deal capture, validation, confirmation, scheduling, settlement, and reporting.
Deal capture: Entering deal details into the system
Validation: Ensuring deal details are accurate and complete
Confirmation: Confirming the deal with counterparties
Scheduling: Planning the delivery of commodities
Settlement: Executing the deal and exchanging payments
Reporting: Generating reports on deal performance
Q69. Trigger for a master detail Relationship
A trigger is used to enforce a master-detail relationship in a database.
Triggers can be used to automatically create child records when a parent record is created.
Triggers can also be used to prevent deletion of parent records if child records exist.
Example: Creating a trigger to insert a new detail record when a master record is inserted.
Q70. why ssis over other technology
SSIS is preferred over other technologies for its robust ETL capabilities and seamless integration with other Microsoft products.
SSIS offers a user-friendly interface for designing and managing ETL processes
It provides a wide range of data transformation and workflow capabilities
SSIS integrates seamlessly with other Microsoft products like SQL Server and Azure
It has strong support for handling complex data integration scenarios
SSIS allows for easy scheduling and monitoring of...read more
Q71. What is angular components
Angular components are reusable building blocks for creating user interfaces in Angular applications.
Angular components are classes that are responsible for controlling a part of the UI.
They consist of a TypeScript class and an HTML template.
Components can have inputs and outputs to communicate with other components.
Examples of components in Angular include buttons, forms, and navigation bars.
Q72. Oops concepts and implementation
Oops concepts refer to object-oriented programming principles like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation involves bundling data and methods that operate on the data into a single unit.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
Abstraction focuses on hiding the implementation details and showing only the necess...read more
Q73. Types of events in Aura?
Events in Aura are actions that can be handled in Lightning components.
Component events: Fired by a component and handled by the component or its ancestors.
Application events: Fired by a component and handled by any component in the application.
System events: Fired by the Aura framework.
Examples: component event to notify parent component, application event to communicate between unrelated components.
Q74. Difference between SFTP and FTP
SFTP is a secure version of FTP that encrypts data during transfer, providing better security.
SFTP uses SSH for secure data transfer, while FTP does not encrypt data.
SFTP requires a secure connection, while FTP does not.
SFTP is commonly used for transferring sensitive data, while FTP is more basic and less secure.
Q75. Write program for palindrome number
Program to check if a number is a palindrome or not.
Convert the number to a string to easily check for palindrome
Reverse the string and compare it with the original string to check for palindrome
If the reversed string is equal to the original string, then the number is a palindrome
Q76. Current/Expected CTC Notice Period
Current CTC is INR 10 LPA, Expected CTC is INR 12 LPA. Notice period is 30 days.
Current CTC: INR 10 LPA
Expected CTC: INR 12 LPA
Notice Period: 30 days
Q77. What is a DOM
DOM stands for Document Object Model, a programming interface for web documents.
DOM is a programming interface for web documents.
It represents the structure of a document as a tree of objects.
It allows scripts to dynamically access and update the content, structure, and style of a document.
DOM is platform and language-independent, making it a crucial part of web development.
Example: Using DOM, JavaScript can change the text color of an HTML element.
Q78. WHat is Closure
Closure is a function that captures the surrounding state within its scope.
Closure allows a function to access and manipulate variables from its outer scope.
It 'closes over' the variables it needs, preserving their values even after the outer function has finished executing.
Commonly used in asynchronous programming to maintain state between function calls.
Q79. Python coding practices
Python coding practices are essential for writing clean, efficient, and maintainable code.
Use meaningful variable names and comments for better readability
Follow PEP 8 guidelines for consistent code style
Avoid using global variables whenever possible
Use virtual environments to manage dependencies
Write unit tests to ensure code functionality and catch bugs early
Q80. Authentication in application
Authentication in application is the process of verifying the identity of a user before granting access to the system.
Use secure login credentials such as username and password
Implement multi-factor authentication for added security
Utilize encryption to protect sensitive data
Regularly update authentication methods to stay ahead of potential threats
Q81. Difference between C and Java
C is a procedural language while Java is an object-oriented language.
C is compiled while Java is interpreted
C has pointers while Java does not
Java has automatic garbage collection while C does not
Java has platform independence while C does not
Java has built-in exception handling while C does not
Q82. Complete flow of redux
Redux is a predictable state container for JavaScript apps.
Actions are dispatched to the store
Reducers update the state based on the action
Subscribers are notified of state changes
Middleware can intercept actions before they reach the reducers
Q83. What is sap cpi?
SAP CPI (Cloud Platform Integration) is a cloud-based integration platform that allows for connecting different systems and applications.
SAP CPI enables seamless integration between cloud and on-premise applications
It provides pre-built connectors for popular applications like Salesforce, SAP S/4HANA, and SuccessFactors
Users can create custom integrations using a web-based design tool called Integration Flow
Q84. What is BW HANA?
BW HANA is a data warehouse solution that combines SAP Business Warehouse (BW) with SAP HANA in-memory database technology.
Combines SAP BW with SAP HANA technology
Provides real-time data processing and analytics capabilities
Improves performance and scalability of data warehouse operations
Q85. What is indexing
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick lookup of data.
Indexing involves creating a data structure that maps key values to their corresponding data entries.
It helps in speeding up data retrieval operations by reducing the number of disk accesses needed.
Examples of indexing include creating indexes on columns in a database table to improve query performance.
Q86. Events in ABAP reports?
Events in ABAP reports are triggers that are executed based on certain conditions or user actions.
Events can be defined at different levels in an ABAP report, such as initialization, start-of-selection, end-of-selection, etc.
These events help in controlling the flow of the report and executing specific logic at different stages.
For example, the initialization event is triggered only once at the beginning of the report execution.
Another example is the end-of-selection event, w...read more
Q87. Directives in Angular
Directives in Angular are markers on a DOM element that tell Angular to attach a specified behavior to that DOM element or even transform the DOM element and its children.
Directives are used to create reusable components in Angular applications.
There are three types of directives in Angular: Component, Structural, and Attribute directives.
Component directives are used to create custom components with their own templates and logic.
Structural directives like *ngIf and *ngFor ma...read more
Q88. Explain encapsulation
Encapsulation is the process of hiding implementation details and exposing only necessary information.
Encapsulation is achieved through access modifiers like public, private, and protected.
It helps in achieving data abstraction and information hiding.
It prevents unauthorized access to the internal state of an object.
Example: A bank account class with private variables for account number and balance, and public methods for deposit and withdrawal.
Example: A car class with priva...read more
Q89. What is P2P process
P2P process refers to the Procure-to-Pay process, which involves the entire cycle of purchasing goods or services.
P2P process starts with the identification of a need for goods or services.
It includes the selection of suppliers, negotiation of terms, and creation of purchase orders.
Goods or services are received, and invoices are matched with the purchase orders.
Payment is made to the supplier, and the process is completed with recording and reconciliation of transactions.
P2P...read more
Q90. Structure of data modelling
Data modelling is the process of creating a visual representation of data and its relationships within a system.
Data modelling involves identifying entities, attributes, and relationships.
Entities represent real-world objects or concepts, attributes describe the properties of entities, and relationships show how entities are connected.
Data modelling helps in designing databases, improving data quality, and ensuring data consistency.
Common data modelling techniques include Ent...read more
Q91. Current CTC and expected CTC
Current CTC is confidential. Expectation is based on industry standards and job responsibilities.
Current CTC is confidential information and not typically shared during interviews.
Expected CTC is based on industry standards, job responsibilities, and candidate's experience.
It is important to research average salaries for similar roles in the industry before stating expected CTC.
Q92. Explain @ input decorator
The @ input decorator is used in Angular to define an input property for a component.
Used to pass data into a component from its parent component
Can be used to bind a property on the parent component to a property on the child component
Syntax: @Input() propertyName: propertyType;
Q93. Explain release Strategy
Release strategy is a plan or approach for deploying software updates or new features to users.
Release strategy involves determining the timing and frequency of software releases.
It includes deciding which features or bug fixes to include in each release.
Release strategy may involve different release channels, such as alpha, beta, and stable releases.
It also includes testing and quality assurance processes to ensure the stability and reliability of the release.
Release strateg...read more
Q94. Explain about LO extraction
LO extraction is the process of extracting data from SAP systems using Logistics Information System (LIS) tables.
LO extraction is commonly used in SAP BW (Business Warehouse) for data warehousing purposes.
It involves extracting data related to logistics, such as sales, purchasing, inventory, etc.
The extracted data is transformed and loaded into the data warehouse for reporting and analysis.
Examples of LO extraction include extracting sales order data, delivery data, material ...read more
Q95. Maintenance Plans and usage
Maintenance plans are essential for ensuring the smooth functioning of applications and systems.
Maintenance plans involve regular checks and updates to prevent system failures and downtime.
They can include tasks such as backups, security updates, and performance tuning.
Usage of maintenance plans can vary depending on the specific needs of the application or system.
For example, a mission-critical system may require more frequent and thorough maintenance than a non-critical sys...read more
Q96. Write a hashmap code
A hashmap code implementation in Java
Create a HashMap object
Add key-value pairs using put() method
Retrieve values using get() method
Q97. Explain Triggers with example
Triggers are database objects that are automatically executed or fired when certain events occur in a database.
Triggers are used to maintain referential integrity, enforce business rules, and automate actions in a database.
They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
For example, a trigger can be created to automatically update a 'last_modified' timestamp column whenever a row is updated in a table.
Q98. Promisies in JS?
Promises in JavaScript are objects representing the eventual completion or failure of an asynchronous operation.
Promises are used to handle asynchronous operations in JavaScript.
They can be in one of three states: pending, fulfilled, or rejected.
Promises can be chained using .then() method to handle success and failure.
Example: const myPromise = new Promise((resolve, reject) => { ... });
Q99. Breakeven in ssis
Breakeven in SSIS refers to the point at which the costs of a project are equal to the revenue generated.
Breakeven in SSIS is calculated by dividing the fixed costs by the difference between the selling price per unit and the variable cost per unit.
It helps in determining the minimum number of units that need to be sold in order to cover all costs.
For example, if the fixed costs are $10,000, the selling price per unit is $20, and the variable cost per unit is $10, the breakev...read more
More about working at Accenture
Top HR Questions asked in Abt Foods
Interview Process at Abt Foods
Reviews
Interviews
Salaries
Users/Month