Upload Button Icon Add office photos
Engaged Employer

i

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

3i Infotech Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

3i Infotech Mysql Database Administrator Interview Questions, Process, and Tips

Updated 17 Sep 2024

3i Infotech Mysql Database Administrator Interview Experiences

1 interview found

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 questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

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

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

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

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts,JAVA 8

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 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 Resume tips
Round 2 - Coding Test 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. C language and Java questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with good technical skills to face the interview

Interview Questionnaire 

1 Question

  • Q1. Drupal data migration
Contribute & help others!
anonymous
You can choose to be anonymous

3i Infotech Interview FAQs

How many rounds are there in 3i Infotech Mysql Database Administrator interview?
3i Infotech interview process usually has 1 rounds. The most common rounds in the 3i Infotech interview process are One-on-one Round.
How to prepare for 3i Infotech Mysql 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 3i Infotech. The most common topics and skills that interviewers at 3i Infotech expect are Data Modeling, Database Administration, Migration, MongoDB and MySQL Database Administration.
What are the top questions asked in 3i Infotech Mysql Database Administrator interview?

Some of the top questions asked at the 3i Infotech Mysql Database Administrator interview -

  1. how to retrieve set of data in a databa...read more
  2. how to know the disk utilization in lin...read more
  3. what is MySQL? why it is popul...read more

Recently Viewed

INTERVIEWS

HCLTech

No Interviews

INTERVIEWS

Landis+Gyr

No Interviews

JOBS

Dolat Capital Market

No Jobs

LIST OF COMPANIES

Dolat Capital Market

Overview

SALARIES

Diaspark Infotech

INTERVIEWS

Kp Energy

No Interviews

SALARIES

Diaspark Infotech

INTERVIEWS

HCLTech

No Interviews

INTERVIEWS

3 Minds Digital

No Interviews

INTERVIEWS

Aloha Technology

No Interviews

Tell us how to improve this page.

3i Infotech Mysql Database Administrator Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 791 Interviews
ITC Infotech Interview Questions
3.6
 • 335 Interviews
KPIT Technologies Interview Questions
3.4
 • 281 Interviews
View all
3i Infotech Mysql Database Administrator Salary
based on 4 salaries
₹2.2 L/yr - ₹8 L/yr
53% less than the average Mysql Database Administrator Salary in India
View more details
Software Engineer
549 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
418 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
319 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Engineer
278 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Softwaretest Engineer
261 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare 3i Infotech 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent