4 3i Infotech Mysql Database Administrator Interview Questions & Answers | Complete Prep Guide 2025

3i Infotech Mysql Database Administrator Interview Experiences

1 interview found

Mysql Database Administrator Interview Questions & Answers

Anonymous

posted on 17 Sep 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Add your answer

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

Add your answer

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

Add your answer

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

Add your answer

Skills evaluated in this interview

Top trending discussions

View All

Salary Discussions, Hike & Promotions

I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the s... read more

Got a question about 3i Infotech?

Ask anonymously on communities.

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Wipro

Anonymous

posted on 16 Sep 2021

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

Add your answer

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

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 10 Feb 2021

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

Interview Questionnaire

1 Question

Q1. Hr

Add your answer

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 .

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 31 Jan 2021

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

Add your answer

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.

Software Engineer Interview Questions & Answers

TCS

Anonymous

posted on 23 Jun 2021

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

Add your answer

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.

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 12 Jan 2022

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

Add your answer

Interview Preparation Tips

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

Software Engineer Interview Questions & Answers

HCLTech

Anonymous

posted on 20 Aug 2022

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

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 9 Sep 2020

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

Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

HCLTech

Anonymous

posted on 16 Aug 2022

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

Add your answer

Interview Preparation Tips

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

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 15 Apr 2021

Interview Questionnaire

1 Question

Q1. Drupal data migration

Add your answer

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 -

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

Software Engineer 549 salaries	₹0 L/yr - ₹0 L/yr
Senior Software Engineer 418 salaries	₹0 L/yr - ₹0 L/yr
Software Developer 319 salaries	₹0 L/yr - ₹0 L/yr
System Engineer 278 salaries	₹0 L/yr - ₹0 L/yr
Softwaretest Engineer 261 salaries	₹0 L/yr - ₹0 L/yr

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

3i Infotech Mysql Database Administrator Interview Experiences

1 interview found

(4 Questions)

Skills evaluated in this interview

Interview questions from similar companies

(1 Question)

Sum of Two Numbers Represented as Arrays

Interview Preparation Tips

Skills evaluated in this interview

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Skills evaluated in this interview

(1 Question)

Interview Preparation Tips

Interview Questionnaire

1 Question

3i Infotech Interview FAQs

Recently Viewed

HCLTech

Landis+Gyr

Dolat Capital Market

Dolat Capital Market

Diaspark Infotech

Kp Energy

Diaspark Infotech

HCLTech

3 Minds Digital

Aloha Technology

Tell us how to improve this page.

3i Infotech Interviews By Designations

Interview Questions for Popular Designations

3i Infotech Mysql Database Administrator Interview Process

Interview Questions from Similar Companies

Fast track your campus placements