Add office photos
Employer?
Claim Account for FREE

Accenture

3.8
based on 56.4k Reviews
Video summary
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by

3500+ Canibuild Interview Questions and Answers

Updated 28 Feb 2025
Popular Designations

Q201. What is journal entry and tell what is golden rule.

Ans.

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

Add your answer

Q202. How does Power BI help in visualisation? Give me difference between basic and advance dashboards

Ans.

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

Add your answer

Q203. Have you explored any AI features integrating with CRM? What's your thoughts on Copilot capabilities

Ans.

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

Add your answer

Q204. In C# can you write code to a plugin quickly? What are classess in C#

Ans.

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.

Add your answer
Discover Canibuild interview dos and don'ts from real experiences

Q205. How to add a column in dataframe ? How to rename the column in dataframe ?

Ans.

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')

Add your answer

Q206. Write a code for Octal to Decimal Conversion.

Ans.

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

View 1 answer
Are these interview questions helpful?

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 more
Ans.

Interview 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

Add your answer

Q208. Accounting principles application in preparation of financial statements

Ans.

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

View 1 answer
Share interview questions and help millions of jobseekers 🌟

Q209. Please share details of experience related to specific areas (supply chain, packaging, logistics, client management, project and team handling)

Ans.

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

Add your answer

Q210. Normal what I have done in my past experiences. What is P2P cycle. What do you understand by catalogue.

Ans.

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

Add your answer

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 more
Add your answer

Q212. How to scan if new hard is attached to a system

Ans.

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

View 1 answer

Q213. What is the important of accounting

Ans.

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

Add your answer

Q214. Wat do you know about p2p

Ans.

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

View 12 more answers

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?

Ans.

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

Add your answer

Q216. Issues faced during migration of SharePoint 2010 sites to SharePoint online sites using sharegate tool

Ans.

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

Add your answer

Q217. What are the various branching strategies used in the version control system?

Ans.

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

Add your answer

Q218. What are key elements which are there in continuous testing tools?

Ans.

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

Add your answer

Q219. What are the differences between ECC and HANA on depreciation AFAB?

Ans.

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

View 1 answer

Q220. What approach are taken before defining a scenario of the test data?

Ans.

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

Add your answer

Q221. A link layer switch is involved in_____layers of the TCP/IP protocol suite. a.2 b.3 c.4 d.5

Ans.

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.

View 1 answer

Q222. How does cloud computing help to manufacturer industry? And their features?

Ans.

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

Add your answer

Q223. Ind as 115 case study and journal entries of deferred revenue

Ans.

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

Add your answer

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 more
Ans.

The 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

Add your answer

Q225. What is the approach of your WAPT?

Ans.

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

View 1 answer

Q226. what is broadcast and it's type of broadcast and what is the use of broadcast?

Ans.

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

Add your answer

Q227. Do you have any technical ceritificate,how many programming languages do you know?

Ans.

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.

Add your answer

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 more
Ans.

Syncing 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

Add your answer

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' ?

Ans.

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'})

Add your answer

Q230. Journal entry of salary expense with 10% TDS

Ans.

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

View 1 answer

Q231. What is difference between flow and flow action

Ans.

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

View 3 more answers

Q232. Which POR is the one in which you feel you had the maximum impact?

Ans.

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

Add your answer

Q233. What is GC? Can we force GC to run? If yes, how to do it?

Ans.

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

Add your answer

Q234. What is oops? Oops is a object oriented programing system

Ans.

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.

View 2 more answers

Q235. What is abstract class? What is interface? Difference between both and when do we use them?

Ans.

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

Add your answer

Q236. Cursors in SQL, Is trigger really required? In what cases can we use it? Syntax of it

Ans.

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

Add your answer

Q237. How many stages will create from the above code that I have written

Ans.

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.

Add your answer

Q238. What do you mean by Scrum Ceremonies?

Ans.

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

View 4 more answers

Q239. What are the advantages of OOPS?

Ans.

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.

Add your answer

Q240. What is Exceptional Handling in Java?

Ans.

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.

Add your answer

Q241. You have to 200 Petabyte of data to load how you will decide the number of executor required ?out of cache you have

Ans.

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

Add your answer

Q242. What is virtual private cloud or Vnet? What is the use of Vnet and why we use it in DevOps?

Ans.

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

Add your answer

Q243. Cloud security and other experiences and projects worked in the past?

Ans.

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

Add your answer

Q244. What do you know about content management?

Ans.

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

View 3 more answers

Q245. If there is a requirement of doing the invoice before pGI , is it possible without making it an order related billing?

Ans.

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

Add your answer

Q246. How to convert a column into a row?

Ans.

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

Add your answer

Q247. 1.What is Overloading, Overriding, different types of Comstructors . Why do we need it?

Ans.

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

View 1 answer
Q248. Can you explain the internal workings of HashMap in Java?
Ans.

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

Add your answer
Q249. How is the index calculated using hashCode() in a HashMap?
Ans.

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)).

Add your answer

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 more
Ans.

IAM 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

Add your answer

Q251. What ia the difference between Hibernate get() and load()

Ans.

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.

View 1 answer

Q252. Do you know about some recent trending technologies? Tell me about it.

Ans.

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

Add your answer

Q253. What is a Friend Function in C++?

Ans.

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); };

Add your answer

Q254. How to bring data from an excel sheet into databricks?

Ans.

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')

Add your answer

Q255. What is the latest Android OS available in the market?

Ans.

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.

View 1 answer

Q256. What are the risks when dealing with foreign countries and currencies

Ans.

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

Add your answer

Q257. Write a code of prime numbers 1 to 100 and write sql query.

Ans.

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;

View 1 answer

Q258. difference between primary key and unique key

Ans.

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.

View 2 more answers

Q259. which of the following digital notebook application that automatically saves and synchronizes your notes as you work

Add your answer

Q260. What the different types of troubleshooting you have done as a DBA?

Ans.

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

Add your answer

Q261. What are the backend and front end technologies used

Ans.

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

Add your answer

Q262. What is React state and props, what is Redux flow, how can we update state in a component, css flexbox, css position property

Ans.

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

View 2 more answers

Q263. What does Marketing CRM include and explain a marketing Campaign scenario.

Ans.

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

Add your answer

Q264. Difference between Canvas App and Model Driven Apps? Have you integrated any with CRM using customisation

Ans.

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

Add your answer

Q265. write a batch code to update account rating

Ans.

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

Add your answer

Q266. How will reduce the inflow of High priority incidents?

Ans.

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

View 1 answer

Q267. Difference between partitioning and bucketing in SQL?

Ans.

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

Add your answer

Q268. What would would you do if a device (computer is slow), what troubleshooting steps can we perform?

Ans.

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

Add your answer

Q269. Ways of input from jcl to cobol,max steps,override,joblibs,msgclass,disp details on jcl

Ans.

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

View 1 answer

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.

Ans.

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

Add your answer

Q271. Program to check if string is palindrome or not.

Ans.

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

View 1 answer

Q272. Which new technology did you learn recently?

Ans.

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.

Add your answer

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?

Ans.

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

Add your answer

Q274. What is fan trap? How to solve it? Give one example.

Ans.

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

Add your answer

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 more
Add your answer

Q276. If you want buy a cosmetic product how you can compare it to other products

Ans.

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

View 1 answer

Q277. What are the different kind of filters available in Celonis?

Add your answer

Q278. Difference between Before Test and Before Method, How link happens between feature and step definition in Cucumber

Ans.

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

Add your answer

Q279. Guestimates - how many basketball can be fit in a plane

Ans.

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.

View 1 answer

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.

Ans.

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.

Add your answer

Q281. Business partner and what tables are updated in backend in sap s4 hana, why is the old tables like kna1, knb1 still required?

Ans.

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.

Add your answer

Q282. How is primary market diffrent from secondary

Ans.

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

Add your answer

Q283. What are the ways to pass data to COBOL through JCL?

Ans.

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

Add your answer

Q284. Can data be moved from an alphanumeric to a signed numeric variable?

Ans.

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.

Add your answer

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

Ans.

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

Add your answer

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 more
Ans.

Tags 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

Add your answer

Q287. What is difference between SQL and my SQL?

Ans.

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

View 1 answer

Q288. What are some accessibility standards that are a must have for a WBT?

Ans.

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

View 1 answer

Q289. Do you have any experience working in cloud environments?

Ans.

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.

Add your answer

Q290. Cases where you'll build an asset or buy an asset and impact in each scenario

Ans.

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

Add your answer

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

Add your answer

Q292. What is your opinion about generative AI?

Ans.

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

Add your answer

Q293. What is good clinical practice in Pharmacovigilianc

Ans.

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

Add your answer

Q294. 4. How to change permission for the application

Ans.

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

Add your answer

Q295. What is the importance of checking the requirement document before Testing Process starts?

Ans.

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

Add your answer

Q296. Compile a 1 minute talk on a word given by the interviewer and list the motivation or learning from the same.

Ans.

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

Add your answer

Q297. What microsoft certifications you hold? How many are pending renewals

Ans.

I hold Microsoft certifications in Azure and SQL Server. No pending renewals.

  • Certifications in Azure and SQL Server

  • No pending renewals

Add your answer

Q298. What is purpose of finally, final, Dispose keyword in C#?

Ans.

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.

Add your answer

Q299. What is SOLID principle? Name or explain one of them

Ans.

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.

Add your answer

Q300. Follow-up Question:- How do you maintain the code for Dev/QA/Production?

Ans.

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

Add your answer
1
2
3
4
5
6
7

More about working at Accenture

Top Rated Mega Company - 2024
Top Rated Company for Women - 2024
Top Rated IT/ITES Company - 2024
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Canibuild

based on 6.8k interviews
Interview experience
4.1
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.8
 • 3k Interview Questions
4.1
 • 278 Interview Questions
4.1
 • 272 Interview Questions
4.2
 • 223 Interview Questions
3.9
 • 173 Interview Questions
3.8
 • 137 Interview Questions
View all
Top Accenture Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter