Upload Button Icon Add office photos

Filter interviews by

Microland MS SQL DBA Interview Questions and Answers for Experienced

Updated 19 Dec 2022

Microland MS SQL DBA Interview Experiences for Experienced

1 interview found

MS SQL DBA Interview Questions & Answers

user image shaik abdul rahiman

posted on 19 Dec 2022

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - One-on-one 

(3 Questions)

  • Q1. New SQL Server installation and configuration
  • Ans. 

    New SQL Server installation and configuration

    • Determine hardware and software requirements

    • Install SQL Server software

    • Configure server settings and security

    • Create and configure databases

    • Set up backup and recovery procedures

  • Answered by AI
  • Q2. Maintaining high availability like log shipping mirroring transactional replication always on and clustering
  • Q3. Database migration from lower version to higher version
  • Ans. 

    Database migration involves upgrading a lower version of a database to a higher version.

    • Ensure compatibility between the source and target database versions

    • Backup the source database before migration

    • Use a migration tool or script to transfer data and schema

    • Test the migrated database thoroughly before deploying to production

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Worked as a Database Administrator with microland Bangalore

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Jan 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Db model, Db role & Server role, SQL server architecture,
  • Ans. Log shipping, migration, HA, Always on, clustering, mirroring
  • Answered Anonymously
  • Q2. Sql server database administrator structure
  • Ans. 

    The SQL Server DBA structure includes roles such as junior DBA, senior DBA, and lead DBA.

    • Junior DBA: responsible for basic tasks such as backups and restores

    • Senior DBA: responsible for performance tuning and troubleshooting

    • Lead DBA: responsible for managing the team and making strategic decisions

    • Other roles may include database architect and database developer

    • The structure may vary depending on the organization's size

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good plateform for finding a new job.....
Best practices & good knowledge

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

16 Questions

  • Q1. What is oracle application database administrator?
  • Ans. 

    An Oracle Application Database Administrator is responsible for managing and maintaining the Oracle database used by Oracle Applications.

    • Responsible for installation, configuration, and upgrading of Oracle database

    • Ensures database security and performance optimization

    • Manages backup and recovery processes

    • Performs database monitoring and troubleshooting

    • Responsible for user management and access control

    • Works closely with ...

  • Answered by AI
  • Q2. Cloning process. Single/multinode
  • Q3. Issue faced on client side and resolution for that.
  • Ans. 

    Client faced issue with concurrent request and resolved by increasing the number of processes.

    • Client reported slow performance while running concurrent requests.

    • Checked the number of processes and found it to be less than required.

    • Increased the number of processes and tested the concurrent request again.

    • Performance improved and issue resolved.

  • Answered by AI
  • Q4. Difference between R12.1 and R12.2
  • Ans. 

    R12.2 has more features and improvements than R12.1

    • R12.2 has a new online patching feature

    • R12.2 has a new user interface

    • R12.2 has improved security features

    • R12.2 has enhanced mobile support

    • R12.2 has a new tool for managing concurrent programs

  • Answered by AI
  • Q5. Did you know about oracle secure backup
  • Ans. 

    Yes, Oracle Secure Backup is a tape backup management software for Oracle databases.

    • Oracle Secure Backup provides centralized management of tape backup and recovery operations for Oracle databases.

    • It supports various tape devices and media types.

    • It offers encryption and compression options for backup data.

    • It can be integrated with Oracle Recovery Manager (RMAN) for seamless backup and recovery.

    • It also provides reportin

  • Answered by AI
  • Q6. Why form taking time to load.
  • Ans. 

    Forms may take time to load due to various reasons.

    • Network latency

    • Heavy database queries

    • Large number of concurrent users

    • Inefficient coding

    • Insufficient hardware resources

  • Answered by AI
  • Q7. Why report is running slow.
  • Ans. 

    Reports can run slow due to various reasons.

    • Inefficient SQL queries

    • Large data sets

    • Inadequate hardware resources

    • Poorly designed report layout

    • Network latency

    • Lack of indexing

    • Database contention

    • Insufficient memory allocation

    • Outdated software versions

  • Answered by AI
  • Q8. Why index rebuild is so important.
  • Ans. 

    Index rebuild is important for improving database performance.

    • Rebuilding indexes helps to remove fragmentation and improve query performance.

    • It also helps to reduce disk I/O and improve overall database efficiency.

    • Regular index rebuilds can prevent index corruption and improve database stability.

    • Index rebuilds can be scheduled during off-peak hours to minimize impact on users.

    • Examples of tools for index rebuilds includ

  • Answered by AI
  • Q9. Benifits of dr drill.
  • Q10. If input/output error encountered.
  • Ans. 

    Input/output error indicates a problem with reading or writing data to a storage device.

    • Check if the storage device is properly connected and functioning.

    • Check if the file system is corrupted.

    • Check if there is enough space on the storage device.

    • Check if there are any hardware issues with the storage device.

    • Check if there are any software issues with the operating system or application.

    • Try to recover the data from backu

  • Answered by AI
  • Q11. How to add DMZ node.
  • Ans. 

    To add DMZ node, we need to configure the DMZ server and add it to the existing Oracle E-Business Suite environment.

    • Configure the DMZ server with the required software and patches.

    • Create a new context file for the DMZ node.

    • Update the DMZ context file with the required parameters.

    • Run the AutoConfig on the DMZ node.

    • Add the DMZ node to the existing Oracle E-Business Suite environment.

    • Configure the firewall to allow traffi...

  • Answered by AI
  • Q12. What is load balancer? Use of it!
  • Ans. 

    A load balancer is a device that distributes network traffic across multiple servers to improve performance and availability.

    • Load balancers can improve website or application performance by distributing traffic evenly across multiple servers.

    • They can also improve availability by redirecting traffic to healthy servers in case of server failure.

    • Load balancers can be hardware or software-based and can be configured to use...

  • Answered by AI
  • Q13. Log file locations
  • Q14. Start stop sequence of erp application and database. Impact if sequence get wrong
  • Ans. 

    Start stop sequence of ERP app and DB. Impact if sequence gets wrong.

    • Start DB first, then ERP app

    • Stop ERP app first, then DB

    • Wrong sequence can cause data corruption or loss

    • May result in incomplete transactions or errors during startup

  • Answered by AI
  • Q15. If one of the application top get deleted how to restore?
  • Ans. 

    To restore a deleted application top, use adadmin utility to recreate the application top.

    • Use adadmin utility to recreate the application top

    • Select option 2 (Maintain Applications Files menu)

    • Select option 1 (Maintain Applications Files)

    • Select option 2 (Copy Oracle Applications Files to the File System)

    • Enter the application short name and version to recreate the application top

  • Answered by AI
  • Q16. Oacore issue encountered?
  • Ans. 

    Oacore issue refers to problems encountered in the Oracle Application Framework (OAF) layer of Oracle E-Business Suite.

    • Oacore issues can cause application performance problems, such as slow page load times or unresponsive pages.

    • Common causes of Oacore issues include memory leaks, database connectivity problems, and configuration errors.

    • To troubleshoot Oacore issues, DBAs can use tools like Oracle Enterprise Manager (OE...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - We can asked employees regarding his past experience & from printed resume.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Interview with KGISL..?

Interview Preparation Tips

Interview preparation tips for other job seekers - Only one round of interview that is only technical, can be crack easily

Microland Interview FAQs

How many rounds are there in Microland MS SQL DBA interview for experienced candidates?
Microland interview process for experienced candidates usually has 2 rounds. The most common rounds in the Microland interview process for experienced candidates are Resume Shortlist and One-on-one Round.
What are the top questions asked in Microland MS SQL DBA interview for experienced candidates?

Some of the top questions asked at the Microland MS SQL DBA interview for experienced candidates -

  1. Database migration from lower version to higher vers...read more
  2. New SQL Server installation and configurat...read more
  3. Maintaining high availability like log shipping mirroring transactional replica...read more

Tell us how to improve this page.

MS SQL DBA Interview Questions from Similar Companies

View all
Microland MS SQL DBA Salary
based on 14 salaries
₹3.6 L/yr - ₹8.2 L/yr
27% less than the average MS SQL DBA Salary in India
View more details

Microland MS SQL DBA Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

1.0

Skill development

3.0

Work-Life balance

3.0

Salary & Benefits

2.0

Job Security

3.0

Company culture

3.0

Promotions/Appraisal

2.0

Work Satisfaction

Explore 1 Review and Rating
Senior Engineer
390 salaries
unlock blur

₹2.3 L/yr - ₹5.2 L/yr

Senior Administrator
263 salaries
unlock blur

₹3.7 L/yr - ₹14.2 L/yr

System Administrator
215 salaries
unlock blur

₹2 L/yr - ₹7.6 L/yr

Sme Associate
212 salaries
unlock blur

₹6 L/yr - ₹19 L/yr

Senior Analyst
185 salaries
unlock blur

₹3.8 L/yr - ₹12.5 L/yr

Explore more salaries
Compare Microland with

Wipro

3.7
Compare

HCLTech

3.6
Compare

Tech Mahindra

3.6
Compare

TCS

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