Upload Button Icon Add office photos

Filter interviews by

Capital Trust SQL Developer Interview Questions and Answers

Updated 28 Feb 2022

Capital Trust SQL Developer Interview Experiences

1 interview found

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. How to delete duplicate data
  • Ans. 

    To delete duplicate data in SQL, use the DISTINCT keyword or GROUP BY clause.

    • Use the DISTINCT keyword to select unique values from a table.

    • Use the GROUP BY clause to group rows with the same values together and then select the unique groups.

    • Use the HAVING clause to filter out groups with more than one row.

    • Use the DELETE statement with a subquery to delete duplicate rows.

    • Example: SELECT DISTINCT column_name FROM table_n...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confidence and focus on questions

Interview questions from similar companies

I appeared for an interview before Sep 2019.

Interview Questionnaire 

8 Questions

  • Q1. 1 tell me about your self?
  • Q2. Why you want work at this company?
  • Q3. Why should I hire you?
  • Q4. If you are experience person----why are you looking for a job company change?
  • Q5. What are your salary requirements?
  • Q6. What is your ambition?
  • Q7. How could be you contribute to our company if you're selected?
  • Q8. Finally do you have any questions to ask me

Interview Preparation Tips

Interview preparation tips for other job seekers - * Research the industry and company
* Clarify your are selling points ex:-(good
communication skills)
* And reason you the job
* Prepare for common interview questions
* Practice---practice---practice and be confident
At the time of interview time.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Numerical logical round with market related questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Call put strategies

Interview Preparation Tips

Interview preparation tips for other job seekers - Tough mathematical understanding of market is required

Interview Questionnaire 

1 Question

  • Q1. Short cut key's and Excel Working
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

1)Buy and sell stock
2)2 sum
3) system design
4) Elastic search
5) deployment

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. LRU cache design
  • Ans. 

    LRU cache design involves maintaining a cache with limited capacity and removing the least recently used item when the cache is full.

    • Use a doubly linked list to maintain the order of items based on their usage.

    • Implement a hash map for fast access to items in the cache.

    • When a new item is accessed, move it to the front of the linked list to mark it as the most recently used.

    • When the cache is full, remove the item at the ...

  • Answered by AI
  • Q2. Current project

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Multiple Choice Questions

Round 2 - HR 

(1 Question)

  • Q1. Why do you want to join us

Interview Preparation Tips

Interview preparation tips for other job seekers - Very good company
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself
  • Q2. Tell about the recent project that you have worked upon
Round 3 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Why are you looking fir change

Interview Preparation Tips

Interview preparation tips for other job seekers - Read JD well & do research on the company
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Naaaghuuiii hgdtyhb uii7yfghh uyddbkiydd
  • Q2. NAahjuutyijhg guihhftu dfyikhh fujgx
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. 1)Project related,
  • Q2. What is the Polymorphism?
  • Ans. 

    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.

    • There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

    • Example: Inheritance in object-oriented programming languages like Java allows for polymorphism.

  • Answered by AI
  • Q3. What is RestController?
  • Ans. 

    RestController is a class in Spring framework used to handle HTTP requests and return responses as JSON or XML.

    • Handles HTTP requests in Spring framework

    • Returns responses as JSON or XML

    • Annotate a class with @RestController to define it as a RestController

    • Example: @RestController public class UserController {}

  • Answered by AI
Round 2 - Coding Test 

Find the number of occurrences of each element in the given ArrayList

Round 3 - HR 

(1 Question)

  • Q1. Discussion with hr like reason to switch.

Interview Preparation Tips

Interview preparation tips for other job seekers - be good with basics

Skills evaluated in this interview

Capital Trust Interview FAQs

How many rounds are there in Capital Trust SQL Developer interview?
Capital Trust interview process usually has 2 rounds. The most common rounds in the Capital Trust interview process are Resume Shortlist and One-on-one Round.

Tell us how to improve this page.

Interview Questions from Similar Companies

Shriram Finance Interview Questions
4.1
 • 345 Interviews
L&T Finance Interview Questions
3.9
 • 152 Interviews
Mahindra Finance Interview Questions
4.1
 • 151 Interviews
BA Continuum Interview Questions
4.1
 • 100 Interviews
Hero FinCorp Interview Questions
4.0
 • 89 Interviews
View all

Capital Trust SQL Developer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Branch Head
69 salaries
unlock blur

₹2 L/yr - ₹4.8 L/yr

Relationship Officer
36 salaries
unlock blur

₹1.3 L/yr - ₹2.5 L/yr

District Manager
23 salaries
unlock blur

₹3.2 L/yr - ₹7.2 L/yr

Cluster Head
23 salaries
unlock blur

₹5 L/yr - ₹10 L/yr

Branch Manager
22 salaries
unlock blur

₹1.8 L/yr - ₹3.8 L/yr

Explore more salaries
Compare Capital Trust with

Bajaj Capital

3.8
Compare

L&T Finance

3.9
Compare

HDFC Asset Management Company

4.0
Compare

ICICI Prudential Mutual Fund

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview