CAMS SQL Programmer Interview Questions and Answers

Aptitude test with 2 t 3 tests

Q1. One on one discussion roles and responsibilities
Add your answer

Q1. Your fundamental should be clear
Add your answer
Q2. Basic oops and azure questions
Add your answer
Q3. Basic c# questions vvc cdd
Add your answer
Q4. Basic sql questions cc ccc ccc
Add your answer
Q5. Basic questions hjhjh shjs
Add your answer
Q6. Bsic c c c c
Add your answer

Q1. 1.writing a complex query in sql?
Ans. 
A complex SQL query involves multiple tables, joins, subqueries, and functions to retrieve specific data.
• Identify the tables and columns needed for the query

• Use JOIN statements to combine data from multiple tables

• Use subqueries to retrieve data from a subset of the main query

• Use aggregate functions like COUNT, SUM, AVG, etc. to perform calculations on data

• Use GROUP BY to group data based on a specific column

• Use HAVING ...read more
Answered by AI
Add your answer
Q2. Program for a target number by sum of n numbers
Ans. 
Program to find n numbers that sum up to a target number.
• Take input of target number and n

• Use a loop to take input of n numbers

• Check if sum of n numbers is equal to target number

• If yes, print the n numbers

• If no, try again with different n numbers
Answered by AI
Add your answer

They asked about the voice process
Like what is in bound and what is out bound and prepare well by 3 to 4 questions

Q1. * Self Introduction * Roles and Responsibilities * Challenges faced and how did you we overcome
Ans. 
I have experience as a Team Lead with a focus on roles and responsibilities, overcoming challenges, and self-introduction.
• Self Introduction: I have been working as a Team Lead for the past three years, leading a team of 10 members.

• Roles and Responsibilities: My main responsibilities include managing team performance, setting goals, and ensuring timely project delivery.

• Challenges faced and how did you overcome: One of t...read more
Answered by AI
Add your answer

Q1. Self Intro Roles and Responsibilities KPI Parameters Challenges faced. Values you would add to the company if hired. 5 qualities you carry
Ans. 
I am an experienced professional with strong leadership skills and a track record of achieving KPIs. I am confident in my ability to add value to the company and overcome challenges.
• Experienced professional with strong leadership skills

• Track record of achieving KPIs

• Confident in ability to add value to the company

• Skilled in overcoming challenges

• Strong communication and problem-solving abilities
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What was your previous job?
Add your answer

Q1. English aptitude online
Add your answer

Panel Interview with higher management

Q1. Base on the profile which was shortlisted
Add your answer

Q1. Online assessment which includes analytical grammes and calculation
Add your answer

Q1. Discussion about the package details and other joining process
Add your answer

Exhaustive group discussion make sure you are confident

Q1. Study basics, risk concepts
Add your answer
Q2. What is Var! And what are different methods
Ans. 
Var! is a keyword used in VBA to declare a variable with a specific data type.
• Var! is used to declare a variable as Single data type.

• It is a shorthand notation for declaring a variable with a specific data type.

• Other shorthand notations include Var%, Var&, and Var$ for Integer, Long, and String data types respectively.
Answered by AI
Add your answer