Accenture
3500+ Canibuild Interview Questions and Answers
Q201. What is journal entry and tell what is golden rule.
Journal entry is a record of financial transactions. Golden rule is a principle of accounting that ensures accuracy in recording transactions.
Journal entry is a chronological record of financial transactions.
It includes the date, accounts involved, and amounts debited or credited.
Golden rule states that for every debit entry, there must be a corresponding credit entry and vice versa.
This ensures that the accounting equation (Assets = Liabilities + Equity) remains balanced.
For...read more
Q202. How does Power BI help in visualisation? Give me difference between basic and advance dashboards
Power BI helps in visualizing data through interactive and customizable dashboards.
Power BI allows users to create visually appealing charts, graphs, and maps to represent data in a meaningful way.
Basic dashboards in Power BI typically include simple visuals like bar charts, line graphs, and pie charts to display key metrics.
Advanced dashboards in Power BI involve more complex visuals like heat maps, scatter plots, and custom visuals created using Power BI's developer tools.
A...read more
Q203. Have you explored any AI features integrating with CRM? What's your thoughts on Copilot capabilities
Yes, I have explored AI features integrating with CRM and I believe Copilot capabilities can greatly enhance productivity and efficiency.
I have experience implementing AI chatbots for customer service in CRM systems
AI features can automate repetitive tasks, improve data accuracy, and provide personalized customer interactions
Copilot capabilities can assist users in making data-driven decisions and predicting customer behavior
Integration of AI with CRM can lead to better custo...read more
Q204. In C# can you write code to a plugin quickly? What are classess in C#
Yes, in C# you can quickly write code to a plugin using classes.
Yes, in C# you can quickly write code to a plugin by creating a class that implements a specific interface or inherits from a base class.
Classes in C# are blueprints for creating objects. They can contain fields, properties, methods, events, and more.
For example, you can create a plugin interface and then create a class that implements that interface to write code for the plugin.
Q205. How to add a column in dataframe ? How to rename the column in dataframe ?
To add a column in a dataframe, use the 'withColumn' method. To rename a column, use the 'withColumnRenamed' method.
To add a column, use the 'withColumn' method with the new column name and the expression to compute the values for that column.
Example: df.withColumn('new_column', df['existing_column'] * 2)
To rename a column, use the 'withColumnRenamed' method with the current column name and the new column name.
Example: df.withColumnRenamed('old_column', 'new_column')
Q206. Write a code for Octal to Decimal Conversion.
Code for Octal to Decimal Conversion
Start from the rightmost digit and move towards the leftmost digit
Multiply each digit with 8 raised to the power of its position
Add all the products obtained in the previous step to get the decimal equivalent
Q207. 1. OOPS CONCEPTS 2. DIFFERENCE BETWEEN ABSTRACT AND INTERFACE 3. WRITE A SQL QUERY TO GET SECOND HIGH SALARY FROM SALARY TABLE. 4. What is index in SQL server 5. Define primary key, foreign key and unique key 6...
read moreInterview questions for Senior Software Engineer position
OOPS concepts include inheritance, polymorphism, encapsulation, and abstraction
Abstract classes cannot be instantiated while interfaces cannot have implementation
SQL query to get second highest salary: SELECT MAX(salary) FROM table_name WHERE salary < (SELECT MAX(salary) FROM table_name)
Index in SQL server is a data structure that improves the speed of data retrieval operations
Primary key uniquely identifies a record, f...read more
Q208. Accounting principles application in preparation of financial statements
Accounting principles are applied in the preparation of financial statements to ensure accuracy and compliance with regulations.
The principles of accounting include the matching principle, revenue recognition principle, and the cost principle.
Financial statements must be prepared in accordance with Generally Accepted Accounting Principles (GAAP).
The balance sheet, income statement, and cash flow statement are the three main financial statements that must be prepared.
Examples ...read more
Q209. Please share details of experience related to specific areas (supply chain, packaging, logistics, client management, project and team handling)
I have extensive experience in supply chain, packaging, logistics, client management, project and team handling.
Managed end-to-end supply chain operations for a consumer goods company
Developed and implemented packaging solutions for a pharmaceutical company
Managed logistics for a global e-commerce company
Successfully handled key client accounts and maintained strong relationships
Led cross-functional teams to deliver complex projects on time and within budget
Q210. Normal what I have done in my past experiences. What is P2P cycle. What do you understand by catalogue.
P2P cycle is the process of procuring goods or services from a supplier, while catalogue is a list of available items for purchase.
P2P cycle involves requisition, purchase order, receipt of goods or services, and payment to supplier.
Catalogue is a list of items available for purchase, often with descriptions and prices.
Catalogues can be physical or digital, and can be used to streamline the procurement process.
Catalogues can also be customized to meet the specific needs of a ...read more
Q211. The company has implemented a demand forecasting system and improved the forecast accuracy significantly. What operational processes will be affected, which process metrics will improve and what will be the fin...
read moreQ212. How to scan if new hard is attached to a system
Use 'lsblk' command to scan for new hard drives attached to the system.
Open terminal and type 'lsblk' command
Check for any new devices listed in the output
Alternatively, use 'fdisk -l' command to list all disks and partitions
Q213. What is the important of accounting
Accounting is important for businesses to track financial transactions, make informed decisions, and comply with regulations.
Helps track financial transactions and monitor cash flow
Provides financial information for decision-making
Assists in complying with tax and regulatory requirements
Helps in budgeting and forecasting
Provides insights into the financial health of the business
Helps in identifying areas for cost-cutting or revenue growth
Assists in securing loans or investmen...read more
Q214. Wat do you know about p2p
P2P stands for peer-to-peer, a decentralized network where participants can directly interact and share resources without a central authority.
P2P networks allow users to share files, data, or resources directly with each other.
These networks eliminate the need for intermediaries or central servers.
Examples of P2P networks include BitTorrent for file sharing and Bitcoin for decentralized digital currency.
P2P networks can be used for various purposes such as file sharing, commu...read more
Q215. Which subject did you like the most in first term?Explain economies of scale? Why does the cost increase after certain volume? How can that be avoided?
I enjoyed studying economics the most in my first term. Economies of scale occur when production costs decrease as output increases. However, after a certain volume, costs increase due to diminishing returns.
Economies of scale refer to the cost advantages that a business can achieve by increasing production output.
As production increases, fixed costs are spread over a larger output, resulting in lower average costs.
However, after a certain point, the benefits of economies of ...read more
Q216. Issues faced during migration of SharePoint 2010 sites to SharePoint online sites using sharegate tool
Issues faced during migration of SharePoint 2010 sites to SharePoint online sites using sharegate tool
Possible issues with metadata and content types
Permissions and user mapping issues
Custom solutions and workflows may not work
Large amounts of data may cause performance issues
Possible data loss or corruption
Q217. What are the various branching strategies used in the version control system?
Various branching strategies in version control systems help manage code changes effectively.
Mainline/Branch by Release: Each release has its own branch for bug fixes and maintenance.
Feature Branching: Each new feature is developed in a separate branch and merged back to main branch after completion.
Gitflow Workflow: Uses main, develop, feature, release, and hotfix branches for a structured workflow.
Trunk-Based Development: All developers work on a single branch, promoting co...read more
Q218. What are key elements which are there in continuous testing tools?
Key elements in continuous testing tools include automation, integration with CI/CD pipelines, reporting and analytics, scalability, and support for various testing types.
Automation of test cases to ensure quick feedback on code changes
Integration with CI/CD pipelines for seamless testing in the software delivery process
Reporting and analytics capabilities to track test results and identify issues
Scalability to handle testing across different environments and configurations
Su...read more
Q219. 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
Q220. 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
Q221. A link layer switch is involved in_____layers of the TCP/IP protocol suite. a.2 b.3 c.4 d.5
A link layer switch is involved in which layers of the TCP/IP protocol suite?
A link layer switch operates at the data link layer (layer 2) of the TCP/IP protocol suite.
It is responsible for forwarding data packets between devices on the same network segment.
It does not operate at the network, transport, or application layers.
Q222. How does cloud computing help to manufacturer industry? And their features?
Cloud computing helps manufacturers by providing cost-effective and scalable solutions for data storage, analysis, and collaboration.
Cloud computing allows manufacturers to store and access large amounts of data without the need for expensive on-premise infrastructure.
Manufacturers can use cloud-based analytics tools to gain insights into their operations and optimize their processes.
Cloud-based collaboration platforms enable manufacturers to work with partners and suppliers ...read more
Q223. Ind as 115 case study and journal entries of deferred revenue
Ind AS 115 deals with revenue recognition and deferred revenue. Journal entries are made to record deferred revenue.
Ind AS 115 provides guidelines for recognizing revenue from contracts with customers.
Deferred revenue is recognized when a company receives payment for goods or services that have not yet been delivered.
Journal entries for deferred revenue involve debiting cash or accounts receivable and crediting deferred revenue.
As goods or services are delivered, deferred rev...read more
Q224. 1. Calculate the cost of the disease ( opportunity cost+ medical expenses+ social +emotional cost ) 2. List down all the parameters to be considered while constructing a Toll booth on a highway to generate maxi...
read moreThe cost of a disease includes opportunity cost, medical expenses, social and emotional cost.
Opportunity cost refers to the potential income or productivity lost due to the disease.
Medical expenses include the cost of treatments, medications, hospital stays, and doctor visits.
Social cost includes the impact on relationships, social activities, and support systems.
Emotional cost refers to the psychological impact, such as stress, anxiety, and depression.
Examples of opportunity...read more
Q225. What is the approach of your WAPT?
Our WAPT approach involves a comprehensive testing methodology to identify and address vulnerabilities in web applications.
We use a combination of automated and manual testing techniques
We prioritize vulnerabilities based on their severity and potential impact
We work closely with development teams to ensure timely remediation
We conduct regular retesting to ensure vulnerabilities have been properly addressed
Q226. what is broadcast and it's type of broadcast and what is the use of broadcast?
Broadcast is a messaging system in Android that allows communication between different components of an app or between different apps.
Broadcast is a way to send messages to multiple components or apps at once.
There are two types of broadcasts: ordered and unordered.
Ordered broadcasts are delivered to receivers in a specific order, while unordered broadcasts are delivered to all receivers at once.
Broadcasts can be used for various purposes such as sending system events, notify...read more
Q227. Do you have any technical ceritificate,how many programming languages do you know?
Yes, I have a technical certificate and I am proficient in 3 programming languages.
I have a certificate in Java programming from Oracle.
I am also proficient in Python and C++.
I have experience in developing web applications using HTML, CSS, and JavaScript.
Q228. Datagurd - how to sync databases if is there huge log gap. What are the necessary paratemers in datagurd and uses of those parameters . Db_file_name_converter, log_file_name_converter. Database architecture - w...
read moreSyncing databases with huge log gap using Dataguard and resolving related issues.
Dataguard can be used to sync databases with huge log gap by creating a standby database and applying archived redo logs.
Parameters like db_file_name_converter and log_file_name_converter can be used to convert file names between primary and standby databases.
Redo logs record all changes made to the database and can be used for recovery in case of a failure.
Undo logs record the before-image of ch...read more
Q229. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, while also summing the values in column 'C' ?
Group data by column 'A', calculate mean of column 'B' and sum values in column 'C' for each group.
Use groupby() function in pandas to group data by column 'A'
Apply mean() function on column 'B' and sum() function on column 'C' for each group
Example: df.groupby('A').agg({'B':'mean', 'C':'sum'})
Q230. Journal entry of salary expense with 10% TDS
Journal entry for salary expense with 10% TDS
Debit Salary Expense account for the gross salary amount
Credit TDS Payable account for the TDS amount
Credit Cash/Bank account for the net salary amount
Example: Debit Salary Expense account for $10,000, Credit TDS Payable account for $1,000, Credit Cash/Bank account for $9,000
Ensure to record the entry at the end of the month or the payment period
Q231. What is difference between flow and flow action
Flow is a sequence of steps while flow action is a single step in a flow.
Flow is a collection of flow actions that define a process
Flow action is a single step in a flow
Flow can have multiple flow actions
Flow actions can be reused in multiple flows
Example: A loan application process can be a flow with flow actions like 'Check eligibility', 'Verify documents', 'Approve loan'
Example: 'Approve loan' can be a flow action that can be reused in other loan approval processes
Q232. Which POR is the one in which you feel you had the maximum impact?
My maximum impact was in the XYZ project where I successfully implemented cost-saving measures resulting in a 20% reduction in expenses.
XYZ project - maximum impact
Implemented cost-saving measures
20% reduction in expenses
Q233. What is GC? Can we force GC to run? If yes, how to do it?
GC stands for Garbage Collection. It is a process of automatically reclaiming memory occupied by objects that are no longer in use.
GC is a part of the .NET runtime that manages memory by automatically freeing up memory occupied by objects that are no longer needed.
We can suggest the GC to run by calling the GC.Collect() method, but it is not recommended to force GC as it can have performance implications.
Forcing GC to run can be done by calling GC.Collect() method with option...read more
Q234. What is oops? Oops is a object oriented programing system
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
OOP focuses on creating reusable code by organizing data and behavior into objects.
It emphasizes concepts like encapsulation, inheritance, and polymorphism.
Objects have attributes (data) and methods (functions) that can interact with each other.
Example: In C#, classes are used to define objects and their properties and methods.
Q235. What is abstract class? What is interface? Difference between both and when do we use them?
Abstract class is a class that cannot be instantiated and may contain abstract methods. Interface is a contract that defines methods that a class must implement.
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
A class can inherit only one abstract class but can implement multiple interfaces.
Abstract classes are used when you want to provide a default implementation for some methods, while interfaces are used to def...read more
Q236. Cursors in SQL, Is trigger really required? In what cases can we use it? Syntax of it
Cursors in SQL are used to iterate through a result set, triggers are not always required but can be useful for enforcing business rules.
Cursors in SQL are used to fetch and process individual rows from a result set.
Triggers in SQL are used to automatically perform actions when certain events occur in a database.
Triggers can be useful for enforcing data integrity constraints or auditing changes to data.
Syntax of a trigger: CREATE TRIGGER trigger_name ON table_name FOR INSERT,...read more
Q237. How many stages will create from the above code that I have written
The number of stages created from the code provided depends on the specific code and its functionality.
The number of stages can vary based on the complexity of the code and the specific tasks being performed.
Stages may include data extraction, transformation, loading, and processing.
It is important to analyze the code and identify distinct stages to determine the total number.
Q238. 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
Q239. What are the advantages of OOPS?
OOPS provides modularity, reusability, and extensibility in software development.
Encapsulation ensures data security and prevents unauthorized access.
Inheritance allows for code reuse and reduces redundancy.
Polymorphism enables flexibility and allows for dynamic behavior.
Abstraction simplifies complex systems and hides implementation details.
OOPS promotes better organization and maintenance of code.
Examples: Java, C++, Python, Ruby, etc.
Q240. What is Exceptional Handling in Java?
Exceptional Handling is a mechanism to handle runtime errors in Java programs.
It is done using try-catch blocks.
It prevents the program from crashing due to errors.
It helps in debugging and maintaining the code.
Examples include NullPointerException, ArrayIndexOutOfBoundsException, etc.
Q241. You have to 200 Petabyte of data to load how you will decide the number of executor required ?out of cache you have
The number of executors required to load 200 Petabytes of data depends on the size of each executor and the available cache.
Calculate the size of each executor based on available resources and data size
Consider the amount of cache available for data processing
Determine the optimal number of executors based on the above factors
Q242. What is virtual private cloud or Vnet? What is the use of Vnet and why we use it in DevOps?
A virtual private cloud (VPC) or Vnet is a private network in the cloud that allows you to isolate resources and control network traffic.
VPC/Vnet provides a secure and isolated environment for resources in the cloud.
It allows you to define your own IP address range, subnets, route tables, and network gateways.
VPC/Vnet helps in creating a secure connection between on-premises data centers and cloud resources.
It is used in DevOps to ensure secure communication between different...read more
Q243. Cloud security and other experiences and projects worked in the past?
I have extensive experience in cloud security and have worked on multiple projects in the past.
Implemented security measures for cloud-based applications and infrastructure
Conducted vulnerability assessments and penetration testing
Developed and implemented disaster recovery plans
Worked on projects involving AWS, Azure, and Google Cloud Platform
Collaborated with cross-functional teams to ensure compliance with industry standards and regulations
Q244. What do you know about content management?
Content management involves organizing, storing, and publishing digital content.
It includes creating and editing content
It involves managing workflows and permissions
Examples include WordPress, Drupal, and SharePoint
Q245. If there is a requirement of doing the invoice before pGI , is it possible without making it an order related billing?
Yes, it is possible to create an invoice before pGI without making it an order related billing.
The invoice can be created directly in the billing document without reference to a sales order.
The billing type can be set up to allow for this scenario.
The billing document can be linked to the delivery document instead of the sales order.
This scenario is useful when the customer wants to be invoiced before the goods are delivered.
It is important to ensure that the billing document...read more
Q246. How to convert a column into a row?
Use UNPIVOT operator in SQL to convert a column into a row.
Use UNPIVOT operator in SQL to convert a column into a row
Syntax: SELECT * FROM (SELECT [column_name] FROM [table_name]) AS [alias_name] UNPIVOT ([new_column_name] FOR [old_column_name] IN ([column_name])) AS [alias_name]
Example: SELECT * FROM (SELECT col1, col2, col3 FROM table1) AS t UNPIVOT (val FOR col IN (col1, col2, col3)) AS u
Transpose function in Excel can also be used to convert a column into a row
Q247. 1.What is Overloading, Overriding, different types of Comstructors . Why do we need it?
Overloading is when multiple methods have the same name but different parameters. Overriding is when a subclass provides a different implementation of a method from its superclass. Constructors are special methods used to initialize objects.
Overloading allows us to have multiple methods with the same name but different parameters, providing flexibility and code reusability.
Overriding allows a subclass to provide its own implementation of a method inherited from its superclass...read more
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
HashMap uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.
If multiple keys hash to the same index (collision), a linked list is used to store all the key-value pairs at that index.
HashMap allows null keys and values, and only one null key.
Example: HashM...read more
The index in a HashMap is calculated by applying a hash function to the key's hashCode value.
The hashCode() method is called on the key object to get its hash code value.
The hash code value is then passed through a hash function to generate the index in the HashMap.
The index is usually calculated by performing bitwise operations on the hash code value.
For example, in Java, the index is calculated as (hash & (capacity - 1)).
Q250. what is Iam what is sa what is bigquery various optimisations joins sql complex query what is qliksense GIThub schema routines schedules delete drop truncate GUI and terraform related spark basics file formats...
read moreIAM is Identity and Access Management, SA is Service Account, BigQuery is a data warehouse, QlikSense is a data visualization tool, GitHub is a version control system, Spark is a distributed computing framework, Airflow is a workflow automation tool, Bigtable is a NoSQL database, Cloud Composer is a managed workflow orchestration service, Pub/Sub is a messaging service.
IAM is used to manage access to resources in Google Cloud Platform.
SA is a special Google account that repre...read more
Q251. What ia the difference between Hibernate get() and load()
Hibernate get() returns object by id, load() returns proxy object until accessed.
get() method returns the object from the database by its id.
load() method returns a proxy object until it is accessed, then it loads the object from the database.
get() method returns null if the object is not found in the database, while load() method throws an exception.
get() method is eager loading, while load() method is lazy loading.
Q252. Do you know about some recent trending technologies? Tell me about it.
Artificial Intelligence and Machine Learning are trending technologies.
AI and ML are being used in various industries like healthcare, finance, and retail.
AI-powered chatbots are becoming popular for customer service.
ML algorithms are being used for fraud detection and risk management.
Deep learning is being used for image and speech recognition.
Natural Language Processing (NLP) is being used for sentiment analysis and language translation.
Reinforcement learning is being used ...read more
Q253. What is a Friend Function in C++?
Friend function is a non-member function that has access to private and protected members of a class.
Declared inside the class but defined outside the class scope
Can access private and protected members of the class
Not a member of the class but has access to its private and protected members
Used to provide access to private or protected members to non-member functions or other classes
Example: friend void display(A);
Example: class A { friend void display(A); };
Q254. How to bring data from an excel sheet into databricks?
Data from an Excel sheet can be brought into Databricks using the read method in Databricks.
Use the read method in Databricks to read the Excel file.
Specify the file path and format (e.g. 'xlsx') when using the read method.
Transform the data as needed using Databricks functions and libraries.
Example: df = spark.read.format('com.crealytics.spark.excel').option('useHeader', 'true').load('file.xlsx')
Q255. What is the latest Android OS available in the market?
The latest Android OS available in the market is Android 11.
Android 11 was released on September 8, 2020.
It comes with features like improved privacy controls, chat bubbles, and screen recording.
Some of the latest devices that come with Android 11 pre-installed are Google Pixel 5, Samsung Galaxy S21, and OnePlus 9.
Android 11 is the successor to Android 10 and is currently the latest version of the Android operating system.
Q256. What are the risks when dealing with foreign countries and currencies
Dealing with foreign countries and currencies involves risks such as exchange rate fluctuations, political instability, and legal issues.
Exchange rate fluctuations can affect profitability and cash flow
Political instability can lead to changes in regulations and policies
Legal issues such as contract disputes and intellectual property rights violations can arise
Cultural differences can also impact business relationships and communication
Examples include Brexit affecting the va...read more
Q257. Write a code of prime numbers 1 to 100 and write sql query.
Code for prime numbers 1 to 100 and SQL query.
Use a loop to iterate through numbers 1 to 100.
For each number, check if it is divisible by any number from 2 to itself-1.
If not divisible, it is a prime number.
SQL query: SELECT * FROM table_name WHERE number_column >= 1 AND number_column <= 100 AND is_prime = true;
Q258. difference between primary key and unique key
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column.
Primary key cannot have null values, while unique key can have one null value.
A table can have only one primary key, but multiple unique keys.
Primary key is used as a foreign key in other tables, while unique key is not.
Example: Employee ID can be a primary key, while email address can be a unique key.
Q259. which of the following digital notebook application that automatically saves and synchronizes your notes as you work
Q260. What the different types of troubleshooting you have done as a DBA?
Types of troubleshooting as a DBA include performance tuning, backup and recovery issues, security concerns, and database connectivity problems.
Performance tuning - optimizing queries, indexes, and server configurations
Backup and recovery issues - resolving failed backups, restoring data from backups
Security concerns - identifying and fixing vulnerabilities, managing user permissions
Database connectivity problems - troubleshooting network issues, resolving connection errors
Q261. What are the backend and front end technologies used
The backend technologies used are Java, Spring Boot, and MySQL. The front end technologies used are Angular and TypeScript.
Backend: Java
Backend Framework: Spring Boot
Database: MySQL
Frontend: Angular
Frontend Language: TypeScript
Q262. What is React state and props, what is Redux flow, how can we update state in a component, css flexbox, css position property
React state and props, Redux flow, updating state in component, css flexbox and position property
React state is an object that determines how a component renders and behaves
Props are read-only data passed from parent to child components
Redux is a state management library for React
Updating state in a component can be done using setState() method
CSS flexbox is a layout model that allows flexible and responsive design
CSS position property is used to position an element relative ...read more
Q263. What does Marketing CRM include and explain a marketing Campaign scenario.
Marketing CRM includes customer data management, campaign tracking, lead generation, and customer engagement.
Customer data management involves storing and organizing customer information such as contact details, purchase history, and preferences.
Campaign tracking allows marketers to monitor the performance of their marketing campaigns, including metrics like open rates, click-through rates, and conversions.
Lead generation involves identifying and attracting potential customer...read more
Q264. Difference between Canvas App and Model Driven Apps? Have you integrated any with CRM using customisation
Canvas Apps are highly customizable and visually rich, while Model Driven Apps are more structured and data-driven. Both can be integrated with CRM using customizations.
Canvas Apps allow for more flexibility in design and layout, with drag-and-drop functionality for components.
Model Driven Apps are more focused on data and business processes, with a predefined data model and UI components.
Both types of apps can be customized and integrated with CRM to enhance user experience ...read more
Q265. write a batch code to update account rating
Batch code to update account rating
Create a batch class implementing Database.Batchable interface
Query for accounts with specific criteria
Update the rating field for each account
Execute the batch class using Database.executeBatch method
Q266. How will reduce the inflow of High priority incidents?
To reduce the inflow of High priority incidents, implement proactive measures and improve incident management processes.
Implement proactive monitoring and alerting systems to identify potential issues before they become high priority incidents.
Enhance incident categorization and prioritization criteria to accurately identify high priority incidents.
Improve incident management processes by implementing a robust incident escalation and resolution workflow.
Invest in training and...read more
Q267. Difference between partitioning and bucketing in SQL?
Partitioning divides a table into smaller parts while bucketing groups data based on a hash function.
Partitioning is used to improve query performance by reducing the amount of data that needs to be scanned.
Bucketing is used to evenly distribute data across nodes in a cluster.
Partitioning is done based on a column or set of columns, while bucketing is done based on a hash function.
Partitioning is commonly used in databases like Oracle and MySQL, while bucketing is commonly us...read more
Q268. What would would you do if a device (computer is slow), what troubleshooting steps can we perform?
To troubleshoot a slow computer, we can perform various steps.
Check for any running programs or processes that may be causing the slow down
Clear temporary files and cache
Check for malware or viruses
Update drivers and software
Check for available disk space
Restart the computer
Perform a hardware diagnostic test
Q269. Ways of input from jcl to cobol,max steps,override,joblibs,msgclass,disp details on jcl
The question is about ways of input from JCL to COBOL, including MAX STEPS, override, joblibs, msgclass, and disp details.
JCL can pass input to COBOL through parameters or files
MAX STEPS limits the number of steps a job can execute
Override allows for the modification of JCL statements
Joblibs specify the libraries to be searched for program objects
Msgclass specifies the destination for system messages
Disp details control the disposition of output datasets
Q270. Which modules you have worked most? name some t-code related to them and standard table related to their transaction. explain any scenario you have enhanced in any standard transaction with steps.
I have worked most on SAP MM module. Some t-codes are ME21N, ME51N. Standard table is EKKO.
Worked most on SAP MM module
T-codes: ME21N, ME51N
Standard table: EKKO
Enhanced ME21N transaction to include additional fields
Q271. Program to check if string is palindrome or not.
A program to check if a given string is a palindrome or not.
Remove all non-alphanumeric characters from the string
Convert the string to lowercase
Reverse the string and compare it with the original string
If they are the same, the string is a palindrome
Q272. Which new technology did you learn recently?
I recently learned about React Native, a framework for building mobile apps using JavaScript.
React Native allows for cross-platform development, reducing the need for separate codebases for iOS and Android.
It uses a similar syntax to React, making it easy for web developers to transition to mobile development.
Some popular apps built with React Native include Facebook, Instagram, and Airbnb.
Q273. You are a team lead and there two team members doesn't have the same view on the topic. how will you resolve it?
As a team lead, I would facilitate open communication, encourage collaboration, and work towards finding a common ground.
Encourage open communication between team members to understand each other's perspectives
Facilitate a discussion to address differences and find common ground
Encourage collaboration and compromise to reach a consensus
Seek input from other team members or stakeholders to gain different perspectives
Provide guidance and support to help team members work throug...read more
Q274. What is fan trap? How to solve it? Give one example.
Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.
Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.
It can be solved by creating a bridge table or by using aggregate functions.
For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about customers who have ordered a certain product.
To solve this, a bri...read more
Q275. 1. What are different types of exports in react? 2. How to convert arry to object and vice-versa. 3. what is useref,useeffect,usememo,usecallback 4. What are the lifecycle methods that can be utilized in useeff...
read moreQ276. If you want buy a cosmetic product how you can compare it to other products
Compare cosmetic products by considering ingredients, brand reputation, price, and reviews.
Check the ingredients list for any potential allergens or irritants
Research the brand's reputation for quality and ethical practices
Compare prices across different retailers or online stores
Read reviews from other customers to gauge effectiveness and satisfaction
Consider any specific needs or preferences, such as vegan or cruelty-free options
Q277. What are the different kind of filters available in Celonis?
Q278. Difference between Before Test and Before Method, How link happens between feature and step definition in Cucumber
Explaining the difference between Before Test and Before Method and how link happens between feature and step definition in Cucumber.
Before Test runs once before all the tests in a test suite while Before Method runs before each test method
Before Test is used for setting up the environment for the entire test suite while Before Method is used for setting up the environment for each test method
In Cucumber, the link between feature and step definition is established through the...read more
Q279. Guestimates - how many basketball can be fit in a plane
Around 5000 basketballs can fit in a plane.
The size of the plane and basketballs need to be considered.
The packing method can also affect the number of basketballs that can fit.
Assuming a standard commercial plane, around 5000 basketballs can fit.
This is a guestimate and not an exact calculation.
Q280. what is the signification of authorization object in abap. to control the access of object by the assign user only in other way to stop move further into rest of process step.
Authorization objects in ABAP control access to objects for assigned users, preventing unauthorized access.
Authorization objects are used to control access to specific objects in ABAP programs.
They define which users have access to certain objects and what actions they can perform.
Authorization objects are assigned to roles, which are then assigned to users.
Examples of authorization objects include S_PROGRAM for program access and S_TABU_DIS for table maintenance access.
Q281. Business partner and what tables are updated in backend in sap s4 hana, why is the old tables like kna1, knb1 still required?
Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility and historical data purposes.
Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility with existing programs and reports.
Some custom developments may still be using the old tables, requiring them to be maintained.
Historical data stored in the old tables may still be needed for reference or reporting purposes.
Q282. How is primary market diffrent from secondary
Primary market is where new securities are issued and sold for the first time, while secondary market is where already issued securities are traded among investors.
Primary market involves the sale of new securities by companies to raise capital.
Secondary market involves the trading of already issued securities among investors.
Primary market transactions occur between the issuer and the investor, while secondary market transactions occur between investors.
Primary market is als...read more
Q283. What are the ways to pass data to COBOL through JCL?
Data can be passed to COBOL through JCL using SYSIN DD statement, PARM parameter, and environment variables.
Use SYSIN DD statement to pass data to COBOL program
Pass data using PARM parameter in JCL
Set environment variables in JCL to pass data
Q284. Can data be moved from an alphanumeric to a signed numeric variable?
Yes, data can be moved from an alphanumeric to a signed numeric variable in COBOL.
In COBOL, data can be moved from an alphanumeric variable to a signed numeric variable using the MOVE statement.
The alphanumeric data will be converted to numeric format during the move operation.
Make sure the alphanumeric data is compatible with the numeric variable's format to avoid errors.
Q285. If there is a scenario where you are advised not to use user exits for a particular requirement, how do you plan to proceed
I would explore alternative solutions and evaluate their feasibility.
Understand the reasons for not using user exits
Research and analyze alternative solutions
Evaluate the feasibility of each solution
Discuss the findings with the team and stakeholders
Select the best solution based on the evaluation
Q286. what is tags ? full form of html ans css ? what is frontend Developer ? how to design the web pages ? why using the css properties ? how many ways to writen the css attributes ? what is text tag ? what is field...
read moreTags are elements used in HTML to define the structure and content of a web page. CSS stands for Cascading Style Sheets. Frontend Developer focuses on the user-facing aspects of a website. CSS properties are used to style and layout web pages.
Tags in HTML are used to define different elements such as headings, paragraphs, images, links, etc.
CSS stands for Cascading Style Sheets and is used to style the layout of web pages.
Frontend Developers focus on the user-facing aspects o...read more
Q287. What is difference between SQL and my SQL?
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL is a standard language used to manage databases, while MySQL is a specific implementation of SQL.
SQL is an ANSI (American National Standards Institute) standard, while MySQL is an open-source relational database management system.
SQL can be used with various database management systems like Oracle, SQL Server, etc., while MySQL is a specific datab...read more
Q288. What are some accessibility standards that are a must have for a WBT?
Some accessibility standards for a WBT include alt text for images, keyboard navigation, and clear language.
Provide alt text for images to assist visually impaired users
Ensure keyboard navigation is possible for users who cannot use a mouse
Use clear and simple language to make content easily understandable for all users
Q289. Do you have any experience working in cloud environments?
Yes, I have experience working in cloud environments.
I have worked with AWS, Azure, and Google Cloud Platform.
I have experience with cloud-based data storage and processing.
I have used cloud-based tools for data visualization and analysis.
I am familiar with cloud security and compliance measures.
Q290. Cases where you'll build an asset or buy an asset and impact in each scenario
Building or buying assets impact on pricing analysis
Building assets can lead to higher initial costs but lower long-term costs
Buying assets can lead to lower initial costs but higher long-term costs
Building assets can provide more control over the quality and customization of the asset
Buying assets can provide faster access to the asset and potentially better support
Impact on pricing analysis depends on the cost structure and expected lifespan of the asset
Q291. OSPF - what are neighbrship establishment stages in OSPF, what is DR/BDR, what are types of LSAs, is different between type 5 and type 7 LSA, difference between OE1 and OE2, what is virtual link with scenario
Q292. What is your opinion about generative AI?
Generative AI has great potential in various industries, including art, music, and content creation.
Generative AI can be used to create realistic images, videos, and music compositions.
It has the potential to revolutionize content creation by automating the process and generating unique outputs.
Applications of generative AI include deepfakes, style transfer, and text generation.
While generative AI has great potential, ethical considerations and misuse must be carefully monito...read more
Q293. What is good clinical practice in Pharmacovigilianc
Good clinical practice in Pharmacovigilance involves systematic monitoring, evaluation, and reporting of adverse drug reactions.
Adherence to regulatory guidelines and protocols
Timely and accurate reporting of adverse events
Continuous monitoring of drug safety profile
Risk management and mitigation strategies
Collaboration with healthcare professionals and regulatory authorities
Ensuring patient confidentiality and privacy
Proper documentation and record-keeping
Regular training an...read more
Q294. 4. How to change permission for the application
Changing permissions for an application involves modifying access levels for users or groups.
Identify the specific permissions that need to be changed
Determine which users or groups require access to the application
Modify the permissions using the appropriate tools or commands
Test the changes to ensure they are working as expected
Q295. 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
Q296. Compile a 1 minute talk on a word given by the interviewer and list the motivation or learning from the same.
Talk on the word 'Agile'
Agile is a software development methodology that emphasizes flexibility and collaboration
It values customer satisfaction and working software over comprehensive documentation
Agile teams work in short iterations, delivering small increments of functionality
Agile promotes continuous improvement and adaptation to changing requirements
Learning Agile can improve project management skills and increase productivity
Q297. What microsoft certifications you hold? How many are pending renewals
I hold Microsoft certifications in Azure and SQL Server. No pending renewals.
Certifications in Azure and SQL Server
No pending renewals
Q298. What is purpose of finally, final, Dispose keyword in C#?
finally is used in exception handling, final is a keyword for classes, Dispose is used for releasing unmanaged resources.
finally block is used in exception handling to ensure a piece of code is always executed, whether an exception is thrown or not.
final keyword is used in C# to prevent inheritance or overriding of a method, class, or property.
Dispose method is used to release unmanaged resources like file handles or database connections to prevent memory leaks.
Q299. What is SOLID principle? Name or explain one of them
SOLID is a set of five design principles in object-oriented programming. One of them is the Single Responsibility Principle (SRP).
SRP states that a class should have only one reason to change, meaning it should only have one job or responsibility.
For example, a class that handles both user authentication and database operations violates SRP. It should be split into two separate classes.
SRP helps in making code more maintainable, testable, and easier to understand.
Q300. Follow-up Question:- How do you maintain the code for Dev/QA/Production?
Code is maintained using version control systems like Git, with separate branches for Dev, QA, and Production.
Use version control systems like Git to track changes and manage code.
Create separate branches for Dev, QA, and Production to isolate changes and prevent conflicts.
Implement a code review process to ensure quality and consistency across environments.
Automate deployment processes to easily promote code changes from one environment to another.
Regularly update dependenci...read more
More about working at Accenture
Top HR Questions asked in Canibuild
Interview Process at Canibuild
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month