Upload Button Icon Add office photos

Filter interviews by

Trigyn Technologies SQL Developer Interview Questions and Answers

Updated 6 May 2024

Trigyn Technologies SQL Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before May 2023.

Round 1 - Technical 

(2 Questions)

  • Q1. Table partitioning
  • Q2. Write a procedure to find and delete duplicates
  • Ans. 

    Procedure to find and delete duplicates in SQL

    • Use a SELECT statement with GROUP BY to identify duplicates

    • Use a DELETE statement with a subquery to remove duplicates

    • Consider using a temporary table to store the duplicates before deletion

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - study and give interview elsewhere

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Ruby On Rails technical questions and culture and fitness

I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basics of Java ,MySQL
  • Q2. For java do all object oriented programming (oops) concept very deeply
  • Q3. For mysql do all basics commands and query

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong basic theoretical and practical knowledge required

I applied via Campus Placement and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Basics of java, Pattern, Loop
  • Q2. All answerd
  • Q3. Basics of c programming
  • Q4. I answered all

Interview Preparation Tips

Interview preparation tips for other job seekers - If u are selected for 3 moths unpaid
Never accept offer letter
Because the never onboard you

I applied via Campus Placement and was interviewed in Jan 2022. There were 2 interview rounds.

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 - Coding Test 

C , data structure,java,dbms,computer network etc

Interview Preparation Tips

Topics to prepare for Mobiloitte Technologies Software Developer interview:
  • C,data structure and java etc
Interview preparation tips for other job seekers - I'm Ravindra kumar from buxar bihar and my educational qualification is MCA perusing from bhabha engineering Research institute bhopal
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
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 - Aptitude Test 

Box problems. You'll find it on youtube

Round 3 - Technical 

(1 Question)

  • Q1. Basic concepts of OS, CN, OOPS and about Projects you have done

Interview Preparation Tips

Interview preparation tips for other job seekers - check youtube for "Box problems" aptitude questions. All questions are similar
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Apr 2023. There were 2 interview rounds.

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 - HR 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. So before going to answer you should know about your goals about your passion etc
  • Answered Anonymously
  • Q2. Tell me something about the company
  • Ans. So before going to interview you should know everything about these companies
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep motivated ,and enhance your skills , keep searching jobs in realiabe site like naukri.com
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Pattern printing
Round 2 - HR 

(1 Question)

  • Q1. Basic front end questions

I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.

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 - Technical 

(2 Questions)

  • Q1. Oops concept and the basic programming language knowledge
  • Q2. Database queries and the database types
  • Ans. 

    Database queries are used to retrieve data from databases. There are different types of databases such as relational, NoSQL, and graph databases.

    • Relational databases use SQL for querying data

    • NoSQL databases use different query languages such as MongoDB's query language

    • Graph databases use graph traversal languages such as Cypher

    • Queries can be used to retrieve specific data or perform complex operations such as joins and

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Tell me about the project
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and dreams

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well and basic knowledge is necessary . resume should be proper
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - Group Discussion 

Group discussion was the first round on avg there were 15 people in a group discussion at last everyone was given a minute to speak

Round 2 - HR 

(4 Questions)

  • Q1. Tell me about yourself?
  • Q2. Where do you see yourself in five years?
  • Q3. Tell me about your family?
  • Q4. Do you plan on Higher education?
Round 3 - Technical 

(6 Questions)

  • Q1. Questions on OOPs concept
  • Q2. Sort the array by parity
  • Q3. Write SQL queries
  • Q4. Who wrote the book discovery of the nation
  • Q5. What is the official language of kashmir
  • Q6. Which city is called city of lakes
Round 4 - Technical 

(6 Questions)

  • Q1. Find the length of the longest word in the length
  • Q2. Push the zeroes in the arrays to the end
  • Q3. When was python launched
  • Q4. What is name of ai from meta/google/amazon
  • Q5. What do you do in your free time
  • Q6. Tell me your pros and cons

Interview Preparation Tips

Topics to prepare for Winjit Technologies Software Developer interview:
  • OOPS
  • C++
  • SQL
Interview preparation tips for other job seekers - The Recruitment process is extremely slow and even weird like asking non-technical questions in technical rounds. The interviews were often rescheduled and mismanaged. The last round was in their office we reached before time and they had no clue that they had an interview scheduled. It began after two hours. Lastly they picked those candidates who had 0 technical knowledge in fact most of them had pretty bad interview experience since then could not answer any technical questions yet they were selected on the other hand those who could answer technical questions and had good interview experience were left out also the results came after a month leading me to believe there was something fishy

Trigyn Technologies Interview FAQs

How many rounds are there in Trigyn Technologies SQL Developer interview?
Trigyn Technologies interview process usually has 1 rounds. The most common rounds in the Trigyn Technologies interview process are Technical.
How to prepare for Trigyn Technologies SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Trigyn Technologies. The most common topics and skills that interviewers at Trigyn Technologies expect are Data Warehousing, MS SQL Server DBA, PLSQL, Performance Tuning and Power BI.
What are the top questions asked in Trigyn Technologies SQL Developer interview?

Some of the top questions asked at the Trigyn Technologies SQL Developer interview -

  1. write a procedure to find and delete duplica...read more
  2. table partition...read more

Tell us how to improve this page.

Trigyn Technologies SQL Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Senior Software Engineer
141 salaries
unlock blur

₹5.4 L/yr - ₹17.5 L/yr

Software Engineer
113 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Technical Analyst
105 salaries
unlock blur

₹8 L/yr - ₹24 L/yr

Senior Technical Analyst
96 salaries
unlock blur

₹10 L/yr - ₹28 L/yr

Technical Lead
45 salaries
unlock blur

₹13.5 L/yr - ₹25 L/yr

Explore more salaries
Compare Trigyn Technologies with

Softenger

4.1
Compare

Capital Numbers Infotech

4.5
Compare

DesignTech Systems

3.3
Compare

Espire Infolabs

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