Upload Button Icon Add office photos

Filter interviews by

Clear (1)

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 was interviewed 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

SQL Developer Jobs at Trigyn Technologies

View all

Interview questions from similar companies

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

I was interviewed in Sep 2016.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills and ability to work in a team

    • Completed multiple projects including a web-based inventory management system

  • Answered by AI
  • Q2. Simple coding questions..Basically pattern.
  • Q3. And also they will ask about your projects.

Interview Preparation Tips

Round: Test
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.

Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida

I was interviewed in May 2017.

Interview Preparation Tips

Round: Test
Total Questions: 20

Round: Group Discussion
Duration: 1 hour

Skills: Coding Skills And Knowledge On Data Structures

I was interviewed in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I was interviewed in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

I was interviewed in Aug 2017.

Interview Preparation Tips

Round: Test
Tips: Practice e litmus questions and also give mock tests on placement season
Duration: 2 hours

Round: Technical + HR Interview
Experience: The interviewer asked me questions from the subjects I mentioned in my CV and also asked so many situational questions like what will you do in this situation etc.

Skills: Presence Of Mind, Technical Skill
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

INTERVIEWS

Streebo

No Interviews

SALARIES

Lloyds Metals And Energy

INTERVIEWS

IDZ Digital

No Interviews

INTERVIEWS

F5 Networks

No Interviews

INTERVIEWS

ExcelSoft Technologies

No Interviews

INTERVIEWS

SoftTech Engineers Limited

No Interviews

INTERVIEWS

Aristocrat

No Interviews

REVIEWS

TSS Consultancy

No Reviews

INTERVIEWS

CS Tech AI

No Interviews

INTERVIEWS

Dana Anand

No Interviews

Tell us how to improve this page.

Trigyn Technologies SQL Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

SQL Developer Interview Questions from Similar Companies

View all
SQL Developer

New Delhi

4-5 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
137 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
116 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Analyst
102 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Analyst
100 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
45 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Trigyn Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent