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

Filter interviews by

Coforge SQL Database Administrator Interview Questions and Answers

Updated 24 Jul 2024

Coforge SQL Database Administrator Interview Experiences

2 interviews found

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

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL restore methods

SQL Database Administrator Interview Questions Asked at Other Companies

asked in TCS
Q1. What is a database management System and what is concept of prima ... read more
asked in TCS
Q2. Diff composite and non composite key and then to create primary k ... read more
asked in TechnoGen
Q3. how to create new users/ login, how to create new job, what are t ... read more
asked in TCS
Q4. Which programming language do you prefer and why?
asked in TCS
Q5. What is Maps, Hash maps, Skeleton class OOPS concepts?

Interview questions from similar companies

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
  • Q2. Recovery models

Skills evaluated in this interview

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

Interview Preparation Tips

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

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

Interview Questionnaire 

1 Question

  • Q1. General questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Went well with the interviewer
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.

Round 1 - Assignment 

Database Management system SQL and PlSQL

Round 2 - Assignment 

Database Base Management system SQL and PlSQL

Round 3 - Aptitude Test 

Database Management system

Round 4 - Aptitude Test 

Database Management system

Round 5 - Group Discussion 

Database Management system

Round 6 - Assignment 

Database Management system

Round 7 - Case Study 

Database Base Management system

Round 8 - HR 

(5 Questions)

  • Q1. Database Management system
  • Q2. SQL and PlSQL Mango Data And Manu Database Management system
  • Q3. C Language and C++Language and Java
  • Q4. Data Analysis and Data entry
  • Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP

Interview Preparation Tips

Interview preparation tips for other job seekers - Database Management system SQL and PlSQL and C Language and C++Language and Java And Web design and Web Developer
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Static and dynamic polymorphism
  • Q2. Code snipts related to prefix and postfix

Interview Preparation Tips

Interview preparation tips for other job seekers - language basics and intermediate level
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(4 Questions)

  • Q1. Start up parameters of sql server
  • Ans. 

    Start up parameters are used to configure the behavior of SQL Server when it starts up.

    • Start up parameters are specified in the SQL Server Configuration Manager.

    • Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

    • Start up parameters can be modified to customize the behavior of SQL Server during startup.

    • Example: -dC:\Program Files\Microso...

  • Answered by AI
  • Q2. Differential backup query
  • Q3. Sql server statics
  • Q4. Log file architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - kindly prepare all the topics about sql server.

Skills evaluated in this interview

I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Expert level SQL knowledge,questions on SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know the answer asked in interview do not panic
Just assure the interviewer that ur ready to learn anything given an opportunity
Do not fake or do not show the desperation for the job
Never tell yes to everything
Provide a stipulated time for you to learn the process
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
  • Q2. Recovery models

Skills evaluated in this interview

Coforge Interview FAQs

How many rounds are there in Coforge SQL Database Administrator interview?
Coforge interview process usually has 1 rounds. The most common rounds in the Coforge interview process are Technical.
How to prepare for Coforge SQL Database Administrator 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 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?

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

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

Tell us how to improve this page.

Coforge SQL Database Administrator Interview Process

based on 3 interviews

Interview experience

4.7
  
Excellent
View more
Coforge SQL Database Administrator Salary
based on 42 salaries
₹3 L/yr - ₹7.2 L/yr
37% 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
Senior Software Engineer
4.8k salaries
unlock blur

₹6.2 L/yr - ₹26 L/yr

Technical Analyst
2.6k salaries
unlock blur

₹10.6 L/yr - ₹38.4 L/yr

Software Engineer
2k salaries
unlock blur

₹2.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.8
Compare

Accenture

3.8
Compare

Infosys

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview