20+ Canam Consultants Interview Questions and Answers

Design a LinkedIn list with medium low level complexity

• Identify the key features and functionalities of the list

• Determine the data structure to be used for storing the list items

• Consider the sorting and filtering options for the list

• Design the UI/UX for the list display

• Ensure scalability and performance of the list

Data dictionary tables store metadata about database objects. History data is stored in audit tables or separate history tables.

• Data dictionary tables contain information about database objects such as tables, columns, indexes, and constraints.

• History data can be stored in audit tables that track changes to data over time.

• Separate history tables can also be used to store historical data.

• Examples of data dictionary tables include SYSOBJECTS and SYSCOLUMNS in Microsoft SQL Serv...read more

Project internals and its flow

• The project's internal flow refers to the sequence of events that occur within the project.

• It includes the various stages of development, testing, and deployment.

• The flow can be visualized using diagrams such as flowcharts or UML diagrams.

• Understanding the project's flow is crucial for effective project management and troubleshooting.

• Examples of project flow include the Waterfall model, Agile methodology, and DevOps.

Using Go routines to send and receive data between two concurrent processes.

• Create two Go routines, one for sending data and one for receiving data

• Use channels to communicate between the two Go routines

• Example: sender Go routine sends data to a channel, receiver Go routine receives data from the same channel

Accounts payable is the amount owed by a company to its suppliers for goods or services received.

• Accounts payable is a liability account that tracks the amount a company owes to its suppliers.

• The universal purpose of accounts payable is to keep track of the money owed to suppliers and ensure timely payment.

• Examples of accounts payable include invoices for raw materials, utilities, and services like legal or accounting.

• Accounts payable is an important part of a company's cash ...read more

Various methods to solve spool space issue

• Optimize queries to reduce spool space usage

• Increase spool space allocation for the user

• Use temporary tables to reduce spool space usage

• Use compression techniques to reduce spool space usage

• Avoid Cartesian joins to reduce spool space usage

Hop Amp CPU is a performance issue caused by excessive CPU usage in a database server.

• Hop Amp CPU occurs when a database server is overloaded with too many queries or transactions.

• It can also be caused by poorly optimized queries or inefficient database design.

• Hop Amp CPU can lead to slow response times, system crashes, and other performance issues.

• To prevent Hop Amp CPU, database administrators should monitor server performance, optimize queries, and ensure efficient databas...read more

Datadog and Grafana are popular monitoring tools used in DevOps for tracking and visualizing metrics.

• Datadog is a cloud-based monitoring service that provides infrastructure monitoring, application performance monitoring, and log management.

• Grafana is an open-source platform for creating dashboards and graphs for visualizing time series data.

• Datadog can be used to collect metrics and logs from various sources, while Grafana can be used to create custom dashboards for visualiz...read more

GR/IR reconciliation is the process of matching goods received with invoices received and resolving any discrepancies.

• GR stands for Goods Received and IR stands for Invoice Received

• The reconciliation process involves comparing the quantity and price of goods received with the corresponding invoice

• Any discrepancies are identified and resolved through communication with the vendor or supplier

• The ultimate goal is to ensure accurate accounting and payment for goods received

• Exampl...read more

Data protection techniques are essential for safeguarding sensitive information from unauthorized access or theft.

• Encryption of data at rest and in transit

• Access controls and authentication mechanisms

• Regular backups and disaster recovery plans

• Data masking and anonymization

• Monitoring and auditing of database activity

Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.

• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to be used for different data types or objects.

• Examples include method overloading and method overriding in object-oriented programming languages like Java.

OOP principles are the fundamental concepts of object-oriented programming that help in designing and implementing software solutions.

• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Allowing a class to inherit properties and behavior from another class.

• Polymorphism: The ability of objects to take on multiple forms or have multiple behaviors.

• Abstraction: Hiding the complex implementation details and showing only the nec...read more

LRU Cache is a data structure that stores recently used items in a limited size cache.

• LRU stands for Least Recently Used

• It has a fixed size and when the cache is full, the least recently used item is removed to make space for new items

• It uses a combination of a doubly linked list and a hash map to achieve O(1) time complexity for both insertion and deletion

• When an item is accessed, it is moved to the front of the list to indicate that it is the most recently used item

Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

• Allows a class to reuse code from another class

• Creates a parent-child relationship between classes

• Derived class inherits attributes and methods from base class

Union combines and removes duplicates, Union all combines all rows including duplicates.

• Union removes duplicates while Union all includes duplicates

• Union is slower than Union all as it involves removing duplicates

• Union all is used when duplicates are desired in the result set

3 way matching is a process used in accounting to ensure that the purchase order, invoice, and receiving report all match before payment is made.

• Involves comparing the purchase order with the invoice and the receiving report

• Helps to prevent errors and fraud in the accounts payable process

• Ensures that the company is only paying for goods or services that were actually received

• Example: A company orders 100 units of a product, receives 100 units, and is invoiced for 100 units - ...read more