Add office photos
Filter interviews by
Triunity Group Database Developer Interview Questions, Process, and Tips
Triunity Group Database Developer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Walk-in and was interviewed before Oct 2022. There were 2 interview rounds.
Java pattern and some basic sql
(5 Questions)
- Q1. Rapid fire mcq about oops and sql
- Q2. What is abstract
- Ans.
Abstract is a concept or idea that is not concrete or tangible.
Abstract refers to something that is theoretical or conceptual rather than physical.
It is often used in programming to define classes or methods that cannot be instantiated.
Abstract art does not attempt to represent an accurate depiction of visual reality.
- Q3. What is inheritance
- Ans.
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
Allows for code reusability and promotes a hierarchical structure
Derived classes can access and modify the properties and behaviors of the base class
Types of inheritance include single, multiple, multilevel, and hierarchical inheritance
- Q4. Constraints in sql
- Ans.
Constraints in SQL are rules that are enforced on data in a table to maintain data integrity.
Constraints ensure data accuracy and consistency in a database.
Common constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK constraints.
Example: CREATE TABLE Students (ID INT PRIMARY KEY, Name VARCHAR(50) NOT NULL, Age INT CHECK (Age >= 18));
- Q5. What are different joins?
- Ans.
Different types of joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is at least one match in both tables.
Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.
Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.
Full Join (o...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. DDL DML DCL TCL
(2 Questions)
- Q1. How to run parallel queries for multiple databases ??
- Ans.
To run parallel queries for multiple databases, use parallel processing techniques and tools.
Use parallel processing techniques such as multi-threading or distributed computing to run queries simultaneously on multiple databases.
Consider using tools like Apache Hadoop or Apache Spark for parallel processing of queries across multiple databases.
Ensure proper resource allocation and optimization to prevent performance is...
- Q2. What is normalisation technique used for database??
- Ans.
Normalization technique is used to organize data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy by storing data in a structured and organized manner.
Normalization ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.
There...
Interview Preparation Tips
Selected
(2 Questions)
- Q1. What is database architecture?
- Ans.
Database architecture refers to the design and structure of a database system.
Database architecture includes the organization of data, storage, retrieval, and security mechanisms.
It involves defining the relationships between data elements and how they are stored and accessed.
Examples of database architectures include hierarchical, network, relational, and object-oriented.
Database architecture also includes the choice ...
- Q2. Difference between delete and truncate
- Ans.
Delete removes rows one by one, while truncate removes all rows at once.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Example: DELETE FROM table_name WHERE condi
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2022. There were 3 interview rounds.
Problem solving skills
Decision making
Information exchange
Generating ideas
Instructions
(2 Questions)
- Q1. Describe your self in 3 words Why should I hire you Why are you leaving your current job Do you have any questions for me What is your hobbies Describe your management style
- Q2. What is your hobbies Describe your management style
Interview Preparation Tips
- C#.Net
Work experience for before working place
I applied via Recruitment Consulltant and was interviewed in Feb 2022. There were 3 interview rounds.
In it they trying to get the information about basic knowledge about related to database and also they are give to write some queries
Related queries which you did in your past projects and also some queries to write
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. About previous project experience
- Q2. SQL concepts
- Q3. Non-sql concepts
- Q4. Devops
Interview Preparation Tips
I applied via Walk-in and was interviewed in Feb 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL server advanced interview questions and answers
- Q2. This is best usually used
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Prepare basic
Interview Preparation Tips
akshaya maisa
Selected
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
I have agreep on python basic
Interview Preparation Tips
- Python
Triunity Group Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Mysql Database Administrator Interview Questions
- SQL Server Database Administrator Interview Questions
- Data Architect Interview Questions
- Show more
People are getting interviews through
Database Developer Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- Triunity Group Interview Questions >
- Triunity Group Database Developer Interview Questions
