Capco Technologies Plsql Developer Interview Questions and Answers

Q1. Explain random forest
Ans. 
Random forest is an ensemble learning method that builds multiple decision trees and merges them to improve accuracy and prevent overfitting.
• Random forest is a type of ensemble learning method.

• It builds multiple decision trees during training.

• Each tree is built using a subset of the training data and a random subset of features.

• The final prediction is made by averaging the predictions of all the individual trees.

• Random...read more
Answered by AI
Add your answer
Q2. What is boosting
Ans. 
Boosting is a machine learning ensemble technique where multiple weak learners are combined to create a strong learner.
• Boosting is an iterative process where each weak learner is trained based on the errors of the previous learners.

• Examples of boosting algorithms include AdaBoost, Gradient Boosting, and XGBoost.

• Boosting is used to improve the accuracy of models and reduce bias and variance.
Answered by AI
Add your answer

Some mcq questions and coding question. Both where easy to medium level. Prepare combination/permutation/Time complexity etc

A question related to Binary search and some other follow ups.

Q1. Code pairing round - you will be given story where you need to add one API to the share repository. It is a simple problem but needs good understanding of the shared code. You should follow clean code pri...read more
Add your answer
Q2. Add one API to the existing repository
Ans. 
The API allows users to retrieve weather data based on location.
• Create a new endpoint that accepts a location parameter

• Use a weather API service to fetch weather data based on the location

• Return the weather data in a standardized format, such as JSON
Answered by AI
Add your answer

Q1. Project you are working on, do some changes to the project, how well you understand the project
Add your answer
Q2. Add some feature to the project
Ans. 
The feature added to the project is a user authentication system.
• Implement a login page with username and password fields.

• Create a database table to store user credentials.

• Hash and salt passwords for secure storage.

• Implement password reset functionality.

• Add user roles and permissions for access control.
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Mcq + Data structures questions

Q1. 
Maximum Sum Subarray Problem Statement
Given an array of integers, find the maximum sum of any contiguous subarray within the array.
Example:
Input:
array = [34, -50, 42, 14, -5, 86]
Output:
137
Exp...read more
Ans. 
Find the maximum sum of any contiguous subarray within an array in O(N) time complexity.
• Use Kadane's algorithm to find the maximum sum subarray in O(N) time complexity

• Initialize two variables: max_sum and current_sum to keep track of the maximum sum subarray

• Iterate through the array and update current_sum by adding the current element or starting a new subarray

• Update max_sum if current_sum is greater than max_sum

• Return...read more
Answered by AI
View 1 more answer

Round duration - 70 minutes
Round difficulty - Medium

Standard System Design round

Q1. Design a Doctor Appointment System and provide some test cases.
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Interview of DSA + OOPS + Databse(SQL query) + Operating System

Q1. 
Left View of a Binary Tree
Given a binary tree, your task is to print the left view of the tree. The left view of a binary tree contains the nodes visible when the tree is viewed from the left side.
Inpu...read more
Ans. 
The task is to print the left view of a binary tree, which contains the nodes visible when the tree is viewed from the left side.
• Traverse the tree in a level order manner and keep track of the leftmost node at each level.

• Use a queue to perform level order traversal.

• Print the leftmost node at each level to get the left view of the binary tree.
Answered by AI
Add your answer
Q2. What is the difference between CHAR and VARCHAR2 data types in SQL?
Ans. 
CHAR is fixed length while VARCHAR2 is variable length in SQL.
• CHAR stores fixed length strings, padding with spaces if necessary.

• VARCHAR2 stores variable length strings, not padding with spaces.

• CHAR is faster for fixed length data, VARCHAR2 is more flexible for varying length data.
Answered by AI
View 1 more answer
Q3. What are the various types of constructors in C++?
Ans. 
There are three types of constructors in C++: default constructor, parameterized constructor, and copy constructor.
• Default constructor: Constructor with no parameters.

• Parameterized constructor: Constructor with parameters.

• Copy constructor: Constructor that initializes an object using another object of the same class.

• Example: // Default constructor ClassName() {} // Parameterized constructor ClassName(int x, int y) :...read more
Answered by AI
Add your answer
Q4. What is the difference between overloading and overriding?
Ans. 
Overloading is having multiple methods in the same class with the same name but different parameters, while overriding is implementing a method in a subclass that is already defined in the superclass.
• Overloading involves multiple methods with the same name but different parameters.

• Overriding involves implementing a method in a subclass that is already defined in the superclass.

• Overloading is resolved at compile time ba...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Hr round - normal hr questions + situational 

Thoughtworks community discussion

Q1. Why should we hire you?
Add your answer

Q1. 1. what is ITSM 2. business rule, client script 3. recent task 4. integration
Add your answer

General appitute question

Q1. What is pointer what is array
Ans. 
A pointer is a variable that stores the memory address of another variable. An array is a collection of similar data types.
• Pointers allow for dynamic memory allocation and manipulation.

• Arrays can be one-dimensional or multi-dimensional.

• Example of pointer: int *ptr = # where num is an integer variable.

• Example of array: char str[10] = {'H', 'e', 'l', 'l', 'o', ' ', 'W', 'o', 'r', 'l', 'd'};
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer

Q1. All logical situation based questions Basic concepts Coding in between interview
Add your answer

Q1. Ai test on node database and git
Add your answer
Q2. Javascript question on clauser
Add your answer