Upload Button Icon Add office photos

Filter interviews by

Altera Digital Health Database Admin Interview Questions and Answers

Updated 16 Feb 2024

Altera Digital Health Database Admin Interview Experiences

1 interview found

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

I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Detailed sql questions. Query writing basic joins and the difference between ddl, dml
  • Q2. Difference between sp and triggers, details on joins. Basics about IIS. Basics about ports. Good to have knowledge about azure.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

There was a group discussion

Round 2 - Coding Test 

Question on basic sql queries

Interview Preparation Tips

Interview preparation tips for other job seekers - It was an internship
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. How do you resolve gap on a Physical Standby in Dataguard ?
  • Ans. 

    Resolve gap on a Physical Standby in Dataguard by identifying the missing archived redo log files and manually copying them over.

    • Check the alert log for errors related to missing archived redo log files

    • Identify the sequence number of the missing redo log files

    • Manually copy the missing archived redo log files from the primary database to the standby database location

    • Register the missing redo log files using the ALTER DA

  • Answered by AI
  • Q2. What do you do when client complains about poor performance of Database ?
  • Ans. 

    Investigate the issue, analyze performance metrics, identify bottlenecks, optimize queries, and implement performance tuning.

    • Investigate the issue by analyzing logs, monitoring tools, and gathering information from the client.

    • Analyze performance metrics such as CPU usage, memory usage, disk I/O, and query execution times.

    • Identify bottlenecks in the database system such as slow queries, inefficient indexing, or hardware...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Do you have knowldge on cloud ?
  • Ans. 

    Yes, I have knowledge on cloud computing.

    • I have experience working with cloud databases like Oracle Cloud Database

    • I am familiar with cloud storage solutions like Amazon S3 and Google Cloud Storage

    • I have implemented cloud backup and disaster recovery strategies in previous roles

  • Answered by AI
  • Q2. Do you have knowledge on other RDBMS ?
  • Ans. 

    Yes, I have knowledge on other RDBMS such as MySQL, SQL Server, and PostgreSQL.

    • I have experience working with MySQL, including database design and optimization.

    • I am familiar with SQL Server and have performed tasks such as backup and recovery.

    • I have worked with PostgreSQL and have knowledge of advanced features like partitioning and replication.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions will be based on your real-time experiences and activities done on your previous organization.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jun 2023. 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 

(1 Question)

  • Q1. They have asked all Questions wrt SQL from basic joins to procedures, views, etc..
Round 3 - One-on-one 

(1 Question)

  • Q1. Managerial round where behavioral aspects are covered.

Interview Preparation Tips

Interview preparation tips for other job seekers - This is a good company but the leaders at the medium level hierarchy are sick, biased judgements, no employee security. will never understand the employee problems
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Coding Test 

About technical development

Round 2 - One-on-one 

(3 Questions)

  • Q1. About project experience
  • Q2. About technology
  • Q3. About old experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare on job role

Altera Digital Health Interview FAQs

How many rounds are there in Altera Digital Health Database Admin interview?
Altera Digital Health interview process usually has 2 rounds. The most common rounds in the Altera Digital Health interview process are Aptitude Test and One-on-one Round.
How to prepare for Altera Digital Health Database Admin 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 Altera Digital Health. The most common topics and skills that interviewers at Altera Digital Health expect are Healthcare, MS SQL, Database, Database Maintenance and Incident management.
What are the top questions asked in Altera Digital Health Database Admin interview?

Some of the top questions asked at the Altera Digital Health Database Admin interview -

  1. Difference between sp and triggers, details on joins. Basics about IIS. Basics ...read more
  2. Detailed sql questions. Query writing basic joins and the difference between dd...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Altera Digital Health interview
Company Website
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Tata 1mg Interview Questions
3.7
 • 139 Interviews
PharmEasy Interview Questions
3.7
 • 78 Interviews
Innovaccer Interview Questions
3.5
 • 77 Interviews
Practo Interview Questions
3.2
 • 72 Interviews
Cult.fit Interview Questions
3.7
 • 68 Interviews
NoBrokerHOOD Interview Questions
3.3
 • 54 Interviews
Fynd Interview Questions
3.5
 • 54 Interviews
View all
Altera Digital Health Database Admin Salary
based on 6 salaries
₹6.6 L/yr - ₹12 L/yr
22% more than the average Database Admin Salary in India
View more details

Altera Digital Health Database Admin Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

2.0

Skill development

1.0

Work-Life balance

1.0

Salary & Benefits

2.0

Job Security

2.0

Company culture

2.0

Promotions/Appraisal

2.0

Work Satisfaction

Explore 1 Review and Rating
Expert Software Engineer
46 salaries
unlock blur

₹15.5 L/yr - ₹29 L/yr

Software Engineer
37 salaries
unlock blur

₹5.4 L/yr - ₹13 L/yr

Associate Software Engineer
29 salaries
unlock blur

₹4.6 L/yr - ₹8 L/yr

Senior Software Engineer
26 salaries
unlock blur

₹10.1 L/yr - ₹22.3 L/yr

Technical Support Consultant
21 salaries
unlock blur

₹7 L/yr - ₹11.5 L/yr

Explore more salaries
Compare Altera Digital Health with

Practo

3.2
Compare

Lybrate

3.5
Compare

Portea Medical

4.3
Compare

PharmEasy

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview