Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by KGISL Team. If you also belong to the team, you can get access from here

KGISL Verified Tick

Compare button icon Compare button icon Compare
3.0

based on 667 Reviews

Filter interviews by

KGISL Database Developer Interview Questions and Answers

Updated 7 Sep 2023

KGISL Database Developer Interview Experiences

1 interview found

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

I was interviewed before Sep 2022.

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 

(1 Question)

  • Q1. Basic questions like CTE, Recursive cte, stored procedure, index fragmentation
Round 3 - HR 

(1 Question)

  • Q1. General questions

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Tell us about yourself
Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. DBA related questions
  • Q2. Golden Gate architecture, RAC, Data guard
Round 2 - Technical 

(2 Questions)

  • Q1. Partition tables
  • Q2. RAC-startup, export/import
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Describe your daily activity
  • Q2. Errors you have faced

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at St Francis Institute of Technology, Mumbai and was interviewed in Apr 2023. There were 5 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 - Aptitude Test 

Basic Apptitude. SQL & logic in

Round 3 - Group Discussion 

Very easy topic. You just need to have fluent English.

Round 4 - Group Discussion 

They took two GD as many people were selected

Round 5 - One-on-one 

(1 Question)

  • Q1. They asked basic and advanced SQL queries

Interview Preparation Tips

Topics to prepare for Mastek SQL Database Administrator interview:
  • SQL
  • Logic
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. What is database?
  • Ans. 

    A database is a structured collection of data that is organized in a way that allows for easy access, management, and retrieval.

    • A database is used to store and organize data in a structured format.

    • It allows for efficient retrieval and manipulation of data.

    • Examples of databases include MySQL, Oracle, SQL Server, and MongoDB.

  • Answered by AI
  • Q2. What is MySQL? why it is popular?
  • Ans. 

    MySQL is an open-source relational database management system that is popular for its ease of use, flexibility, and scalability.

    • MySQL is an open-source RDBMS, allowing users to freely use, modify, and distribute the software.

    • It is known for its ease of use, making it accessible for beginners and experts alike.

    • MySQL is highly flexible, supporting various data types and storage engines.

    • It is popular for its scalability, ...

  • Answered by AI
  • Q3. How to retrieve set of data in a database?
  • Ans. 

    To retrieve a set of data in a database, you can use SQL queries to specify the data you want to retrieve.

    • Use SELECT statement to specify the columns you want to retrieve

    • Use FROM clause to specify the table where the data is stored

    • Use WHERE clause to specify any conditions for filtering the data

    • Use ORDER BY clause to specify the order in which the data should be returned

    • Use LIMIT clause to specify the maximum number of

  • Answered by AI
  • Q4. How to know the disk utilization in linux?
  • Ans. 

    To know disk utilization in Linux, use commands like df, du, and iostat.

    • Use 'df' command to display disk space usage on Linux filesystems.

    • Use 'du' command to estimate file space usage.

    • Use 'iostat' command to monitor system input/output device loading.

    • Check disk utilization with tools like 'iotop' and 'atop'.

  • Answered by AI

Skills evaluated in this interview

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

I applied via Referral and was interviewed before Jun 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. SQL server architecture
  • Q2. Backup Types and PITR
  • Q3. High availability and Disaster Recovery
Round 3 - Technical 

(2 Questions)

  • Q1. Asked for everything that I mentioned in my resume
  • Q2. Azure services and features
Round 4 - HR 

(1 Question)

  • Q1. Management Process
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Oracle architecture
  • Q2. Data guard and backup
Round 1 - Technical 

(1 Question)

  • Q1. Needs to aware of troubleshooting skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to aware of troubleshooting skills and knowledge

SQL Database Administrator Interview Questions & Answers

Microland user image Mahesh Kumar Babu Kummara

posted on 20 Jul 2023

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

I applied via Referral and was interviewed before Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. The Architecture of SQL Server
  • Ans. 

    The architecture of SQL Server involves components like storage engine, query processor, and buffer manager.

    • SQL Server architecture consists of multiple components such as storage engine, query processor, and buffer manager.

    • The storage engine manages data storage, retrieval, and modification.

    • The query processor processes SQL queries and generates execution plans.

    • The buffer manager is responsible for managing data cache...

  • Answered by AI
  • Q2. How to troubleshoot high CPU and Memory
  • Ans. 

    To troubleshoot high CPU and Memory, monitor performance metrics, identify resource-intensive queries, optimize queries and indexes, check for memory leaks.

    • Monitor performance metrics using tools like SQL Server Profiler, Performance Monitor, or DMVs.

    • Identify resource-intensive queries using tools like SQL Server Management Studio or query execution plans.

    • Optimize queries and indexes by rewriting queries, adding missin...

  • Answered by AI
  • Q3. Recent issues and resolution
  • Ans. 

    Resolved recent issues related to database performance by optimizing queries and increasing server resources.

    • Identified slow performing queries and optimized them by adding indexes or rewriting them

    • Increased server resources such as CPU, memory, or storage to improve performance

    • Implemented query caching or stored procedures to reduce load on the database server

  • Answered by AI
  • Q4. What is DAG, DNN and VNN
  • Ans. 

    DAG stands for Directed Acyclic Graph, DNN stands for Deep Neural Network, and VNN stands for Virtual Neural Network.

    • DAG is a graph with directed edges and no cycles, commonly used in data processing.

    • DNN is a type of artificial neural network with multiple hidden layers, used in deep learning.

    • VNN is a virtual neural network, a concept that may refer to a neural network implemented in a virtual environment.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and shift acceptance

Interview Preparation Tips

Interview preparation tips for other job seekers - Intermediate knowledge of SQL server is required.

Skills evaluated in this interview

KGISL Interview FAQs

How many rounds are there in KGISL Database Developer interview?
KGISL interview process usually has 3 rounds. The most common rounds in the KGISL interview process are Technical, HR and Resume Shortlist.
How to prepare for KGISL Database 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 KGISL. The most common topics and skills that interviewers at KGISL expect are Database Design, ETL, NoSQL, ODI and Oracle Data Integrator.

Tell us how to improve this page.

KGISL Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Associate
396 salaries
unlock blur

₹1.6 L/yr - ₹9.2 L/yr

Senior Associate
323 salaries
unlock blur

₹4.8 L/yr - ₹15 L/yr

Process Associate
272 salaries
unlock blur

₹1 L/yr - ₹4.1 L/yr

Junior Associate
190 salaries
unlock blur

₹1.3 L/yr - ₹5.4 L/yr

Senior Process Associate
177 salaries
unlock blur

₹1 L/yr - ₹6 L/yr

Explore more salaries
Compare KGISL 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