i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
LLAMA models are used for large language model adaptation.
LLAMA models are used for adapting large language models to specific tasks or domains.
They are commonly used in natural language processing tasks such as text generation, translation, and sentiment analysis.
Examples of LLAMA models include GPT-3, BERT, and RoBERTa.
Precision is the ratio of correctly predicted positive observations to the total predicted positive observations, while Recall is the ratio of correctly predicted positive observations to the all observations in actual class.
Precision focuses on the accuracy of positive predictions, while Recall focuses on the proportion of actual positives that were correctly identified.
Precision = TP / (TP + FP)
Recall = TP / (TP + FN...
Hyperparameters of Random Forest include number of trees, max depth of trees, minimum samples per leaf, and maximum features.
Number of trees: Determines the number of decision trees in the forest.
Max depth of trees: Controls the maximum depth of each decision tree.
Minimum samples per leaf: Specifies the minimum number of samples required to be at a leaf node.
Maximum features: Determines the maximum number of features t
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
SQL joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
F...
Delete removes a record entirely, while update modifies an existing record.
Delete removes the entire record from the database
Update modifies specific fields of an existing record
Delete is irreversible, while update can be undone by another update
Example: Deleting a user account vs updating the user's email address
A pointer to pointer is a variable that stores the memory address of another pointer variable.
It is used to create dynamic data structures like linked lists and trees.
It allows multiple levels of indirection.
It is denoted by ** in C and C++.
Example: int **ptr;
Example: ptr = &p; where p is a pointer variable.
I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.
I applied via Walk-in and was interviewed before Oct 2020. There were 5 interview rounds.
posted on 11 Nov 2019
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
Answering types of JOINS for two given tables.
INNER JOIN: returns only matching rows from both tables
LEFT JOIN: returns all rows from left table and matching rows from right table
RIGHT JOIN: returns all rows from right table and matching rows from left table
FULL OUTER JOIN: returns all rows from both tables and NULL values where there is no match
CROSS JOIN: returns all possible combinations of rows from both tables
Java with DB is better than PL/SQL as it offers more flexibility and scalability.
Java with DB allows for easier integration with other technologies
Java offers more advanced programming features than PL/SQL
Java with DB can handle larger and more complex data sets
PL/SQL is limited to Oracle databases only
Java with DB is more widely used and has a larger community for support
Dynamic SQL is a technique to generate SQL statements at runtime based on user input or other conditions.
Dynamic SQL is used to create flexible and customizable queries.
It allows for the creation of complex queries with multiple conditions.
Dynamic SQL can be executed using prepared statements or by concatenating strings.
It is important to properly sanitize user input to prevent SQL injection attacks.
Overriding in PL/SQL is the ability to define a subprogram in a child package that has the same name and signature as a subprogram in a parent package.
Overriding allows a child package to provide its own implementation of a subprogram that is already defined in a parent package.
The child subprogram must have the same name and signature as the parent subprogram.
The child subprogram can have a different implementation th...
Triggers are database objects that are used to automatically execute a response when a certain event occurs.
DML Triggers
DDL Triggers
Logon Triggers
CLR Triggers
INSTEAD OF Triggers
Identifying type of join for given outputs of two tables.
Inner join: returns only the matching rows from both tables.
Left join: returns all rows from left table and matching rows from right table.
Right join: returns all rows from right table and matching rows from left table.
Full outer join: returns all rows from both tables and matching rows from both tables.
based on 1 interview
Interview experience
Consultant
55.2k
salaries
| ₹5.2 L/yr - ₹17.5 L/yr |
Associate Consultant
50.8k
salaries
| ₹3 L/yr - ₹10 L/yr |
Senior Consultant
46.1k
salaries
| ₹7.5 L/yr - ₹24.5 L/yr |
Senior Analyst
20.6k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
Senior Software Engineer
20.2k
salaries
| ₹3.5 L/yr - ₹12.1 L/yr |
Wipro
Accenture
Cognizant
TCS