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 AVASOFT Team. If you also belong to the team, you can get access from here

AVASOFT Verified Tick

Compare button icon Compare button icon Compare
2.9

based on 256 Reviews

Play video Play video Video summary

Filter interviews by

AVASOFT Trainee Database Administrator Interview Questions and Answers

Updated 31 May 2021

AVASOFT Trainee Database Administrator Interview Experiences

1 interview found

Trainee Database Administrator Interview Questions & Answers

user image Anonymous

posted on 31 May 2021

I applied via Company Website and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions on Keys, table elements, Joins, DDL, DML Commands
    • Add your answer
  • Q2. What is a DB, Rdbms, Normalization, users and roles
  • Ans. 

    DB is a collection of data stored in an organized manner. RDBMS is a software used to manage relational databases. Normalization is a process of organizing data to minimize redundancy. Users and roles are used to manage access to the database.

    • DB - collection of data stored in an organized manner

    • RDBMS - software used to manage relational databases (e.g. MySQL, Oracle)

    • Normalization - process of organizing data to minimiz...

    • Answered by AI
    Add your answer
  • Q3. 3 types of relationship between datasets in DB ?
  • Ans. 

    There are three types of relationships between datasets in a database: one-to-one, one-to-many, and many-to-many.

    • One-to-one: each record in one dataset is related to only one record in another dataset.

    • One-to-many: each record in one dataset is related to one or more records in another dataset.

    • Many-to-many: multiple records in one dataset are related to multiple records in another dataset.

    • Examples: one-to-one - employee...

    • Answered by AI
    View 1 more answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Round 1 - Group Discussion (Topic - Social media)
Round 2 - Basic questions on rdbms, sql and relational databases and small sql query using joins
Round 3 - SQL queries to get required results using joins and other functions
Round 4 - HR and Manager interview (general)

English communication is required to clear 1st round,
Basic knowledge in Sql, relational database and rdbms.. and ability to write simple small sql queries is enough to clear round 2 and 3
Final round is common, so just show your interest.

Skills evaluated in this interview

Top trending discussions

View All
News
2w (edited)
a deputy manager
Zero Tax on Salary Up to 12 Lakh !! 😍😍😍
#NoIncomeTax 4-8 lakhs: 5% 8-12 lakhs: 10% 12 -16 Lakhs– 15% 16-20 Lakhs- 20% 20-24 Lakhs- 25% ABOVE 24 lakhs 30% Important to note no income tax payable up to 12 lakhs #Budget2025 Comment down below your thoughts 👇
FeedCard Image
Got a question about AVASOFT?
Ask anonymously on communities.

Interview questions from similar companies

Senior Database Administrator Interview Questions & Answers

UKG user image Anonymous

posted on 25 Oct 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via LinkedIn and was interviewed in Sep 2023. 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 tips
Round 2 - Technical 

(3 Questions)

  • Q1. Database architecture
    • Add your answer
  • Q2. High availability for database
  • Ans. 

    High availability for database ensures minimal downtime and continuous access to data.

    • Implementing clustering and replication to distribute workload and provide failover

    • Setting up automated backups and monitoring systems to quickly identify and resolve issues

    • Utilizing load balancers to evenly distribute traffic and prevent overload

    • Implementing disaster recovery plans to quickly recover from unexpected outages

    • Answered by AI
    Add your answer
  • Q3. PostgreSQL streaming replication
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - should have fluently in knowing database architecture and how to set database performance parameters

Database Developer Interview Questions & Answers

Globant user image Anonymous

posted on 8 Feb 2023

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Q.About SQL Server T-SQL
    • Add your answer
  • Q2. Q.Normal scenario based questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - HR is too busy. HR called to schedule the interview but forgot to schedule interview. After reminding HR, HR scheduled the interview but did not give any feedback after the interview. sending messages and emails, but HR didn't respond.waste of time.

Oracle Database Administrator Interview Questions & Answers

Oracle Cerner user image Raj Kishore Shaw

posted on 22 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basics architecture, rman, datapump, upgrade, asm
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. Block corruption, upgrade, rman datapump, asm, patching
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Basics..... Speaking skills.. Salary discussion
    • Add your answer
More about working at AVASOFT

AVASOFT Interview FAQs

What are the top questions asked in AVASOFT Trainee Database Administrator interview?

Some of the top questions asked at the AVASOFT Trainee Database Administrator interview -

  1. What is a DB, Rdbms, Normalization, users and ro...read more
  2. 3 types of relationship between datasets in D...read more
  3. Questions on Keys, table elements, Joins, DDL, DML Comma...read more

Tell us how to improve this page.

AVASOFT Interviews By Designations

Interview Questions for Popular Designations

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
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 806 Interviews
Hexaware Technologies Interview Questions
3.6
 • 722 Interviews
Persistent Systems Interview Questions
3.5
 • 611 Interviews
Globant Interview Questions
3.8
 • 171 Interviews
View all

Fast track your campus placements

St Josephs College of Engineering, Chennai Placement Questions
2 Interviews
Coimbatore Institute of Technology, Coimbatore Placement Questions
2 Interviews
Panimalar Engineering College, Chennai Placement Questions
2 Interviews
Sri Ramakrishna Engineering College, Coimbatore Placement Questions
1 Interview
Tagore Engineering College, Chennai Placement Questions
1 Interview
PSG, Coimbatore Placement Questions
1 Interview
Karunya University Placement Questions
1 Interview
View all
AVASOFT Salaries in India
Software Engineer
230 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Data Engineer
90 salaries
unlock blur

₹3.4 L/yr - ₹8 L/yr

Software Developer
61 salaries
unlock blur

₹3 L/yr - ₹9.4 L/yr

Servicenow Developer
51 salaries
unlock blur

₹4 L/yr - ₹7 L/yr

QA Engineer
48 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Explore more salaries
Compare AVASOFT with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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