Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Engaged Employer

i

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

Coforge Verified Tick

Compare button icon Compare button icon Compare
3.3

based on 5k Reviews

Play video Play video Video summary

Filter interviews by

Coforge SQL Database Administrator Interview Questions and Answers for Experienced

Updated 24 Jul 2024

Coforge SQL Database Administrator Interview Experiences for Experienced

1 interview found

SQL Database Administrator Interview Questions & Answers

user image Anonymous

posted on 24 Jul 2024

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

(1 Question)

  • Q1. Sql dmvs used in performance tuning
  • Ans. 

    SQL DMVs are dynamic management views that provide information about the current state of a SQL Server instance for performance tuning.

    • DMVs can be used to identify performance bottlenecks, monitor resource usage, and troubleshoot issues.

    • Examples of commonly used DMVs include sys.dm_exec_query_stats, sys.dm_os_wait_stats, and sys.dm_io_virtual_file_stats.

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Top trending discussions

View All
Career Growth
2w (edited)
littleiv
Verified Icon
·
works at
Capgemini
Tech lead - Tech Mahindra or IBM
I have 2 offers in same location : Need guidance to choose one 1) Tech Mahindra (U4) Fixed 23.9 Variable 2.6=26.5 No joining bonus Project details informed already 2)IBM(7B) Fixed 21.37 + Variable 0-10% Joining bonus is 1 lakh Your Responses and thoughts will be appreciated. Thank you
Got a question about Coforge?
Ask anonymously on communities.

Interview questions from similar companies

SQL Database Administrator Interview Questions & Answers

NTT Data user image Anonymous

posted on 11 Nov 2024

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

(2 Questions)

  • Q1. Architecture of sql
  • Ans. 

    SQL architecture refers to the structure and components of a SQL database system.

    • SQL architecture includes components like storage engine, query processor, and buffer manager.

    • The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

    • The buffer manager handles caching and memory management to optimize performance.

    • Examples of SQL architectures include MySQL, Oracle, and SQL Se

    • Answered by AI
    Add your answer
  • Q2. Recovery models
    • Add your answer

Skills evaluated in this interview

SQL Database Administrator Interview Questions & Answers

Hexaware Technologies user image Anonymous

posted on 12 Aug 2022

Round 1 - Technical 

(1 Question)

  • Q1. Difference between index and statistics
  • Ans. 

    Index is used to speed up data retrieval while statistics are used by the query optimizer to create an efficient query plan.

    • Indexes are created on columns to speed up data retrieval

    • Statistics are used by the query optimizer to create an efficient query plan

    • Indexes are used to enforce uniqueness and primary key constraints

    • Statistics are used to estimate the number of rows returned by a query

    • Indexes can be clustered or n...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Get ready more about sql server Basics and performnace tuning

SQL Database Administrator Interview Questions & Answers

DXC Technology user image

posted on 11 Sep 2021

I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. General questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Went well with the interviewer

Software Engineer Interview Questions & Answers

LTIMindtree user image Anonymous

posted on 15 Sep 2022

I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Prepare normal for aptitude - maths, quant, analytic

Round 2 - Group Discussion 

My GD topic was Is internet good for students or not

Round 3 - Coding Test 

I didn't attempt this as I was noob back in third year Engg

Round 4 - HR 

(1 Question)

  • Q1. Basic questions can you relocate, tell me about ur GD and composition
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy peasy give ur best. Prepare well. Hope u get the job. Phir tho google ka hi dream rhe gaya he mera.

Software Engineer Interview Questions & Answers

Optum Global Solutions user image Anonymous

posted on 5 Feb 2021

Interview Questionnaire 

1 Question

  • Q1. Mainframe questions, some direct and some scenario based.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience. Interview process was smoothly. There were 3 rounds.
1. Technical ( lasted for 1 hour)
2. Techno manageria( 30 mins)
3. HR(30 mins)

Project based questions and scenario based questions were asked.
Hike was also good.

Software Engineer Interview Questions & Answers

DXC Technology user image Anonymous

posted on 24 Nov 2020

I applied via Campus Placement and was interviewed in May 2020. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. 1.In frst round they gave two programs like palindrome,leap year which is quite easy only, aptitude consists of 60qns .
    • Add your answer
  • Q2. 2.In second round which is technical round, again they gave one pgm which is lightly complicated and also questions will be asked based on our resume and branch.
    • Add your answer
  • Q3. 3.HR round based on your personal skill.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to be perfect in basic coding and also aptitude,it is not much tough and also be bold while answering in technical round,try to do more projects......

Software Engineer Interview Questions & Answers

Persistent Systems user image Anonymous

posted on 22 Sep 2021

I applied via Campus Placement and was interviewed before Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Find the second largest element from an integer array in a single traversal
  • Ans. 

    Find the second largest element from an integer array in a single traversal

    • Initialize two variables to store the largest and second largest elements

    • Traverse the array and update the variables accordingly

    • Return the second largest element

    • Answered by AI
    Add your answer
  • Q2. This can be done using Hashtables.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident with your answers.

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

Persistent Systems user image Anonymous

posted on 22 Jan 2022

I applied via Company Website and was interviewed before Jan 2021. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. This is an online test consists of questions from OS, DBMS, Networking. Couple of coding question was also there. Language specific section also there.
    • Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. Here also I was asked to write the code two coding question difficulty varies from easy to medium. More than that I was asked questions from OS, DBMS, SDLC and basic level question from C and JAVA.
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. This one is kind of advanced technical round. I was asked about C and Java in more depth. Asked to write couple of SQL queries. There are some more conceptual question in SQL.
    • Add your answer
Round 4 - HR 

(4 Questions)

  • Q1. Why should we hire you?
    • Add your answer
  • Q2. What are your strengths and weaknesses?
    • Add your answer
  • Q3. Tell me about yourself.
    • Add your answer
  • Q4. Some basic questions and then I was informed that I am selected. There was around 54000 students applied for that role and among them 150 was selected. I got offer letter in the said day and employment sta...
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Persistent is a company that is really good for fresher from training and culture point of view. But their salary structure especially for the freshers are below average. 30000 is the in-hand salary for 451000 CTC. I was selected in off campus, so didn't need to go through internships. I was provided with Full time opportunity and got the full salary from the first month itself. It was totally a WFH as it was during covid. I will highly recommend to plan for other companies after 2 years. For interview question, stick to the subjects that are mentioned in resume. DBMS, Java, C, SDLC, SQL this are some topics that will be asked irrespective of being mentioned in resume. So prepare well for that. All the best.

Software Engineer Interview Questions & Answers

Mphasis user image Anonymous

posted on 28 Nov 2021

I applied via Campus Placement and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic project description and data base design
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic level interview question
More about working at Coforge

Coforge Interview FAQs

How many rounds are there in Coforge SQL Database Administrator interview for experienced candidates?
Coforge interview process for experienced candidates usually has 1 rounds. The most common rounds in the Coforge interview process for experienced candidates are Technical.
How to prepare for Coforge SQL Database Administrator interview for experienced candidates?
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 Coforge. The most common topics and skills that interviewers at Coforge expect are Application Support, Database Administration, Monitoring, Performance Tuning and Production Support.
What are the top questions asked in Coforge SQL Database Administrator interview for experienced candidates?

Some of the top questions asked at the Coforge SQL Database Administrator interview for experienced candidates -

  1. Sql dmvs used in performance tun...read more
  2. SQL restore meth...read more

Tell us how to improve this page.

Coforge Interviews By Designations

Interview Questions for Popular Designations

Coforge SQL Database Administrator Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more

SQL Database Administrator Interview Questions from Similar Companies

DXC Technology SQL Database Administrator Interview Questions
3.7
 • 1 Interview
Hexaware Technologies SQL Database Administrator Interview Questions
3.5
 • 1 Interview
NTT Data SQL Database Administrator Interview Questions
3.8
 • 1 Interview
UST SQL Database Administrator Interview Questions
3.8
 • 1 Interview
FIS SQL Database Administrator Interview Questions
3.9
 • 1 Interview
Kyndryl SQL Database Administrator Interview Questions
4.0
 • 1 Interview
View all

Fast track your campus placements

KIIT University, Bhuvaneshwar Placement Questions
2 Interviews
TRS College, Rewa Placement Questions
1 Interview
Visveswaraiah Technological University (VTU) Placement Questions
1 Interview
Jagan Institute of Management Studies (JIMS) Placement Questions
1 Interview
SRM university (SRMU) Placement Questions
1 Interview
Babu Banarasi Das National Institute of Technology and Management, Lucknow Placement Questions
1 Interview
East West Institute of Technology, Bangalore Placement Questions
1 Interview
View all
Coforge SQL Database Administrator Salary
based on 42 salaries
₹3 L/yr - ₹7.2 L/yr
38% less than the average SQL Database Administrator Salary in India
View more details

Coforge SQL Database Administrator Reviews and Ratings

based on 3 reviews

4.4/5

Rating in categories

4.4

Skill development

4.4

Work-life balance

4.0

Salary

4.2

Job security

4.4

Company culture

4.2

Promotions

4.4

Work satisfaction

Explore 3 Reviews and Ratings
Coforge Salaries in India
Senior Software Engineer
4.9k salaries
unlock blur

₹6.5 L/yr - ₹23.6 L/yr

Technical Analyst
2.6k salaries
unlock blur

₹9.5 L/yr - ₹38.4 L/yr

Software Engineer
2k salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Test Engineer
1.8k salaries
unlock blur

₹4.7 L/yr - ₹19.5 L/yr

Technology Specialist
1.1k salaries
unlock blur

₹12 L/yr - ₹42 L/yr

Explore more salaries
Compare Coforge with

Capgemini

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare

Infosys

3.6
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview