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

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

In first round, they ask a dynamic pattern question.

Round 2 - Technical 

(2 Questions)

  • Q1. What is attribute in HTML
  • Ans. 

    An attribute in HTML provides additional information about an element and is used to modify the element's behavior or appearance.

    • Attributes are added to HTML elements using the syntax attribute="value".

    • Attributes can be used to specify things like the size, color, or alignment of an element.

    • Examples of attributes include 'href' in Example and 'src' in .

  • Answered by AI
  • Q2. Constructor in php and use of constructor
  • Ans. 

    Constructor in PHP is a special method used to initialize objects of a class.

    • Constructor is a special method with the same name as the class.

    • It is automatically called when an object is created.

    • Constructors can be used to initialize object properties or perform any necessary setup.

    • Example: class Car { public function __construct() { echo 'Car object created'; }}

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Round 1 - One-on-one 

(2 Questions)

  • Q1. Introduce yourself
  • Q2. Python and it's concepts
Round 2 - HR 

(2 Questions)

  • Q1. Telling about myself which is not on cv
  • Q2. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and display exceptional interpersonal skills
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. What is Association and composition?
  • Ans. 

    Association and composition are two types of relationships between classes in object-oriented programming.

    • Association is a relationship where two classes are related in some way, but can exist independently. For example, a teacher and a student are associated as a teacher can teach multiple students.

    • Composition is a stronger form of association where one class is composed of one or more other classes. For example, a ca...

  • Answered by AI
  • Q2. What is thready safety in java ?
  • Ans. 

    Thread safety in Java refers to the ability of a piece of code to function correctly during simultaneous execution by multiple threads.

    • Thread safety is important in multi-threaded environments to prevent race conditions and ensure data consistency.

    • Synchronization mechanisms like synchronized blocks, locks, and atomic variables can be used to achieve thread safety.

    • Example: Using synchronized keyword to ensure only one t...

  • Answered by AI
  • Q3. What is difference between runnable and callable?
  • Ans. 

    Runnable is a functional interface used for running a task, while Callable is a functional interface used for returning a result.

    • Runnable does not return a result and cannot throw checked exceptions, while Callable can return a result and throw checked exceptions.

    • Callable interface is a generic interface that returns a result, while Runnable interface does not return a result.

    • Example: Runnable interface is commonly use...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Coding Test 

Pseudocode problems and 2 coding questions

Round 2 - HR 

(1 Question)

  • Q1. Introduction, family background, logical question of English alphabet
Round 3 - Technical 

(3 Questions)

  • Q1. AI/ML trends, bitcoin info
  • Q2. Java code for finding even number
  • Ans. 

    Java code to find even numbers in an array

    • Iterate through the array and check if each element is divisible by 2

    • Use the modulus operator (%) to check for even numbers

    • Store the even numbers in a separate array or print them out

  • Answered by AI
  • Q3. Basic questions about technologies mentioned in the resume
Round 4 - BU Head 

(4 Questions)

  • Q1. Intro, family background
  • Q2. HTML, CSS, JAVA, CPP code
  • Q3. Logical Questions
  • Q4. Speaking Communication

Interview Preparation Tips

Interview preparation tips for other job seekers - To succeed as a junior software developer at Winjit Technology, focus on continuous learning and adapting to emerging technologies. Demonstrate a strong work ethic, collaborate effectively with your team, and showcase your problem-solving skills. Prioritize communication, both verbal and written, and actively seek feedback to enhance your skills. Stay proactive, show enthusiasm for innovation, and leverage internships or personal projects to bolster your practical experience. Remember, a positive attitude and a willingness to learn will set you apart in your career journey with Winjit Technology.

Skills evaluated in this interview

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

Very easy coding test just like class 2 standard

Round 2 - Aptitude Test 

Moderate
Moderate level of questions are come

Round 3 - HR 

(4 Questions)

  • Q1. About yourself? Basics coding question
  • Q2. Project related question?
  • Q3. Coding question?
  • Q4. Technical knowledge!
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

20 Question each of 20 marks for 1 hrs

Round 2 - Technical 

(1 Question)

  • Q1. Basic Question on the Fundamental of what langauge you know..and some basic of blockchain and metaverse
Round 3 - HR 

(1 Question)

  • Q1. Basic generic Question and bond details

I applied via Approached by Company and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Coding Test 

They shared an online assessment link.
It had 6 questions (4 mcq, 2 React coding question)
MCQs were related to javascript output questions.
In the react coding questions, I was asked to implement a counter using useReducer and a minor bug fixing question

Round 2 - HR 

(4 Questions)

  • Q1. Tell me about yourself?
  • Q2. What are your hobbies?
  • Q3. What is your current and expected salary?
  • Q4. Why do you want to join our company?

Interview Preparation Tips

Topics to prepare for Capital Numbers Infotech Junior Software Developer interview:
  • Javascript
  • React.Js
Interview preparation tips for other job seekers - Very simple and easy interview. Can easily crack with minimal Javascript practice

I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Hing

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview mode in Remote access is a suited for long distance travelling Interviewers
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Pattern question has been provided to me

Round 2 - Technical 

(2 Questions)

  • Q1. Write html code for form
  • Ans. 

    HTML code for a basic form

    • Use the <form> tag to create a form

    • Include <input> tags for user input fields

    • Use <button> tag for submit button

  • Answered by AI
  • Q2. Difference between candidate key and foreign key
  • Ans. 

    Candidate key uniquely identifies a record in a table, while foreign key establishes a relationship between two tables.

    • Candidate key is a unique key that can be used to uniquely identify a record in a table.

    • Foreign key is a key that establishes a relationship between two tables.

    • Candidate key can be a primary key or a unique key, while foreign key references a primary key in another table.

    • Example: In a 'students' table,...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Webkul Software PHP Developer interview:
  • PHP
  • Laravel
Interview preparation tips for other job seekers - Good

Skills evaluated in this interview

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, ETL, Interpersonal Skills, MS SQL Server and MSBI.
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.

SQL Developer Interview Questions from Similar Companies

View all
Senior Software Engineer
128 salaries
unlock blur

₹5.2 L/yr - ₹17.5 L/yr

Software Engineer
113 salaries
unlock blur

₹3 L/yr - ₹8.2 L/yr

Technical Analyst
98 salaries
unlock blur

₹8 L/yr - ₹24 L/yr

Senior Technical Analyst
95 salaries
unlock blur

₹10 L/yr - ₹28 L/yr

Technical Lead
45 salaries
unlock blur

₹11.9 L/yr - ₹25 L/yr

Explore more salaries
Compare Trigyn Technologies with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview