Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Premium Employer

i

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

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare
3.5

based on 1.2k Reviews

Filter interviews by

Clover Infotech SQL Database Administrator Interview Questions and Answers for Freshers

Updated 26 Feb 2023

Clover Infotech SQL Database Administrator Interview Experiences for Freshers

1 interview found

SQL Database Administrator Interview Questions & Answers

user image Anonymous

posted on 26 Feb 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2022. There were 4 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 

Easy aptitude test. Nothing difficult.

Round 3 - Technical 

(1 Question)

  • Q1. Technical round involves your basic understanding of Database management systems. How it works ? What is the role of a DBA ?
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Very normal HR round
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are a fresher joining as a DBA.
Only con is 3.5 years but you will learn a lot in those years. There will be lot of work.
If you join a MNC as a fresher trust me you won't learn a thing.

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 Clover Infotech?
Ask anonymously on communities.

Interview questions from similar companies

SQL Database Administrator Interview Questions & Answers

Mastek user image Jessica Gonsalves

posted on 16 Oct 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement 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
    • Add your answer

Interview Preparation Tips

Topics to prepare for Mastek SQL Database Administrator interview:
  • SQL
  • Logic

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

(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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and shift acceptance
    • Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

NeoSOFT user image Anonymous

posted on 11 Sep 2021

I applied via Naukri.com and was interviewed before Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. IOS Basics , iPhone programming
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - When you tried a lot to get good company if you have no option then go for it ,Make this to last of your joining preferences.You will be deadlocked in the bond think twice before Join.

Software Engineer Interview Questions & Answers

Maveric Systems user image Anonymous

posted on 15 Nov 2019

I applied via Recruitment Consultant and was interviewed in Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic Java questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Had appeared for Java developer role, basic Java questions were asked.

Software Engineer Interview Questions & Answers

ITC Infotech user image Anonymous

posted on 14 May 2018

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
    • Add your answer
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
    • Add your answer
  • Q3. Problem based on oops and SQL queries outputs
    • Add your answer
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up
    • Add your answer

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Brijesh Mishra

posted on 3 Sep 2017

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

    • Answered by AI
    Add your answer
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

    • Answered by AI
    Add your answer
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

    • Answered by AI
    Add your answer

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Anonymous

posted on 3 Mar 2022

I applied via Campus Placement and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

It was easy with basic ques and then pymetrics tesy

Round 2 - Coding Test 

Coding test had basic questions on Java core

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare theoritical concept of SQL and Java well

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Anonymous

posted on 20 Apr 2021

I applied via Walk-in and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions on Java. Spring MVC flow, collections, projects that you've worked on
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - This is a easy discussion. Just portray your strong points and just indirectly force them to ask you're question related to the same.

Software Engineer Interview Questions & Answers

Test Yantra Software Solutions user image Anonymous

posted on 14 Sep 2021

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on SDLC & STLC , system testing, regression testing, diff between functional and non functional testing, Smoke testing, Adhoc testing. Some simple SQL questions .
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer each amd every question correctly.
More about working at Clover Infotech

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech SQL Database Administrator interview for freshers?
Clover Infotech interview process for freshers usually has 4 rounds. The most common rounds in the Clover Infotech interview process for freshers are Resume Shortlist, Aptitude Test and Technical.
How to prepare for Clover Infotech SQL Database Administrator interview for freshers?
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 Clover Infotech. The most common topics and skills that interviewers at Clover Infotech expect are Database Administration, French, Postgresql, SAN and SQL DBA.
What are the top questions asked in Clover Infotech SQL Database Administrator interview for freshers?

Some of the top questions asked at the Clover Infotech SQL Database Administrator interview for freshers -

  1. Technical round involves your basic understanding of Database management system...read more
  2. Very normal HR ro...read more

Tell us how to improve this page.

Clover Infotech Interviews By Designations

Interview Questions for Popular Designations

Clover Infotech SQL Database Administrator Interview Process for Freshers

based on 1 interview

Interview experience

3
  
Average
View more
Join Clover Infotech Digital Solutions for the New-Age Enterprise

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 350 Interviews
NeoSOFT Interview Questions
3.6
 • 270 Interviews
Newgen Software Technologies Interview Questions
3.7
 • 187 Interviews
3i Infotech Interview Questions
3.5
 • 145 Interviews
Happiest Minds Technologies Interview Questions
3.6
 • 135 Interviews
Microland Interview Questions
3.5
 • 135 Interviews
Test Yantra Software Solutions Interview Questions
3.2
 • 126 Interviews
Sify Technologies Interview Questions
3.8
 • 125 Interviews
Mastek Interview Questions
3.5
 • 120 Interviews
Maveric Systems Interview Questions
3.5
 • 118 Interviews
View all
Clover Infotech SQL Database Administrator Salary
based on 68 salaries
₹2.8 L/yr - ₹9.5 L/yr
28% less than the average SQL Database Administrator Salary in India
View more details

Clover Infotech SQL Database Administrator Reviews and Ratings

based on 15 reviews

4.1/5

Rating in categories

4.2

Skill development

3.5

Work-life balance

3.4

Salary

4.2

Job security

3.9

Company culture

3.5

Promotions

4.1

Work satisfaction

Explore 15 Reviews and Ratings
Clover Infotech Salaries in India
Software Engineer
1.3k salaries
unlock blur

₹1.8 L/yr - ₹9.8 L/yr

Senior Software Engineer
830 salaries
unlock blur

₹4.2 L/yr - ₹16 L/yr

Application Support Engineer
582 salaries
unlock blur

₹2 L/yr - ₹8.3 L/yr

Technical Support Engineer
561 salaries
unlock blur

₹2 L/yr - ₹7.2 L/yr

Oracle Database Administrator
480 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Explore more salaries
Compare Clover Infotech with

ITC Infotech

3.6
Compare

3i Infotech

3.5
Compare

Sify Technologies

3.8
Compare

Microland

3.5
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