Upload Button Icon Add office photos

Filter interviews by

Pearl Global Solutions Senior Database Administrator Interview Questions and Answers

Updated 21 May 2020

Pearl Global Solutions Senior Database Administrator Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. Regarding DB optimization and performance tuning

Interview Preparation Tips

Interview preparation tips for other job seekers - Never loose your confidence

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2020. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Day to Day task
  • Q2. About all technical
Round 2 - HR 

(1 Question)

  • Q1. Location and salary discussion
Round 3 - One-on-one 

(1 Question)

  • Q1. Offer discussion

I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Database architecture
  • Q2. Database backups wal files

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic architecture and backups maintenance activities user roles would be better

Interview Questionnaire 

1 Question

  • Q1. Sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and apply for this role.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. OEM services-related Questions
  • Q2. What is Oracle Block Change
  • Ans. 

    Oracle Block Change is a feature that tracks and records changes made to database blocks.

    • Oracle Block Change is used for efficient data replication and synchronization.

    • It helps in identifying and transferring only the changed data blocks instead of the entire database.

    • Oracle GoldenGate utilizes Oracle Block Change technology for real-time data integration.

    • Block Change Tracking (BCT) is a feature in Oracle Database that...

  • Answered by AI
  • Q3. In RAC database 2 nodes are there how you will re-direct users to 2nd node only?
  • Ans. 

    To redirect users to the 2nd node in a RAC database, you can use services and connection load balancing.

    • Create a service for the 2nd node in the RAC database.

    • Configure connection load balancing to distribute connections evenly between the nodes.

    • Update the connection string in the application to point to the service for the 2nd node.

    • Test the connection to ensure users are redirected to the 2nd node.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was based on my experience which I have mentioned in resume.
some were situation based Questions and some were direct questions like
What is BCT, how to make DB available for max? etc etc

Skills evaluated in this interview

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

(2 Questions)

  • Q1. What is dba, explain the architecture of dba
  • Ans. 

    DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.

    • DBA is responsible for installing, configuring, and upgrading database software.

    • They monitor database performance and troubleshoot issues.

    • DBA designs and implements backup and recovery strategies to prevent data loss.

    • They also manage user access and security permissions within...

  • Answered by AI
  • Q2. How you will maintain the database and what are the types of backup
  • Ans. 

    Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.

    • Regularly monitor database performance and usage

    • Perform routine maintenance tasks such as applying patches and updates

    • Take regular backups to ensure data integrity and disaster recovery

    • Implement security measures to protect the database from unauthorized access

    • Optimize database performanc

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to sync primary and standby?
  • Ans. 

    Primary and standby databases can be synced using Data Guard in Oracle.

    • Configure Data Guard on primary and standby databases

    • Enable redo transport services

    • Monitor and resolve any synchronization issues

    • Perform switchover or failover when necessary

  • Answered by AI
  • Q2. Performance tuning?
Round 2 - HR 

(2 Questions)

  • Q1. Why you want to change the job?
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for new challenges to enhance my skills and knowledge

    • Seeking growth opportunities for career advancement

    • Interested in working in a more dynamic and innovative environment

  • Answered by AI
  • Q2. Expected salary.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Static and dynamic polymorphism
  • Q2. Code snipts related to prefix and postfix

Interview Preparation Tips

Interview preparation tips for other job seekers - language basics and intermediate level
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. What is database architecture?
  • Ans. 

    Database architecture refers to the design and structure of a database system.

    • Database architecture includes the organization of data, storage, retrieval, and security mechanisms.

    • It involves defining the relationships between data elements and how they are stored and accessed.

    • Examples of database architectures include hierarchical, network, relational, and object-oriented.

    • Database architecture also includes the choice ...

  • Answered by AI
  • Q2. Difference between delete and truncate
  • Ans. 

    Delete removes rows one by one, while truncate removes all rows at once.

    • Delete is a DML command, while truncate is a DDL command.

    • Delete can be rolled back, while truncate cannot be rolled back.

    • Delete fires triggers, while truncate does not fire triggers.

    • Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.

    • Example: DELETE FROM table_name WHERE condi

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Architecture of sql
  • Ans. 

    SQL architecture refers to the structure and components of a SQL database system.

    • SQL architecture includes components like storage engine, query processor, and buffer manager.

    • The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

    • The buffer manager handles caching and memory management to optimize performance.

    • Examples of SQL architectures include MySQL, Oracle, and SQL Se

  • Answered by AI
  • Q2. Recovery models

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
LTIMindtree Interview Questions
3.9
 • 2.7k Interviews
View all
Software Engineer
6 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Senior Data Analyst
5 salaries
unlock blur

₹4.3 L/yr - ₹5.7 L/yr

Data Analyst
4 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

HR Executive
4 salaries
unlock blur

₹1.6 L/yr - ₹3 L/yr

Merchandiser
4 salaries
unlock blur

₹3.6 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Pearl Global Solutions with

TCS

3.7
Compare

Accenture

3.9
Compare

Cognizant

3.8
Compare

Infosys

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