Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Oracle DBA Consultant Interview Questions and Answers

Updated 8 Aug 2023

Oracle DBA Consultant Interview Experiences

1 interview found

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

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

(2 Questions)

  • Q1. Rdms architecture & dataguard concept
  • Q2. Rac implementation & exadata exposure

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare very well in core rdms. Architecture level to get in to oracle

Interview questions from similar companies

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

(5 Questions)

  • Q1. Question about dba
  • Q2. Difference Between SQL And nosql
  • Ans. 

    SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.

    • SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

    • SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

    • SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...

  • Answered by AI
  • Q3. How to restore the database using rman
  • Ans. 

    Restoring a database using RMAN involves connecting to the target database, restoring the control file, and recovering the database.

    • Connect to the target database using RMAN

    • Restore the control file from a backup

    • Restore the datafiles and tablespaces

    • Recover the database to bring it to a consistent state

    • Perform necessary checks and validations after restoration

  • Answered by AI
  • Q4. How to change column in table
  • Ans. 

    You can change a column in a table using the ALTER TABLE statement in SQL.

    • Use the ALTER TABLE statement followed by the MODIFY keyword to change the data type or size of a column.

    • Use the ALTER TABLE statement followed by the ADD or DROP keyword to add or remove a column.

    • Make sure to specify the table name, column name, and the new data type or size when making changes.

  • Answered by AI
  • Q5. What are different types of objects in database
  • Ans. 

    Different types of objects in a database include tables, views, indexes, sequences, and stored procedures.

    • Tables: Used to store data in rows and columns.

    • Views: Virtual tables created by a query.

    • Indexes: Improve the performance of queries by allowing quick access to specific rows.

    • Sequences: Generate unique numbers.

    • Stored Procedures: Precompiled SQL code that can be executed with parameters.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice company with good management and work environment.

Skills evaluated in this interview

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

I applied via Company Website and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Assignment 

The assignment was given to check overall knowledge in the BI domain with questions on EDA & data modelling & visualisation.

Round 2 - Technical 

(1 Question)

  • Q1. The interview was based on the assignment provided

Interview Preparation Tips

Interview preparation tips for other job seekers - Thorough preparation on data science topics
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:
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. Basics architecture, rman, datapump, upgrade, asm
Round 3 - Technical 

(1 Question)

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

(1 Question)

  • Q1. Basics..... Speaking skills.. Salary discussion
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. What is view synonym mview Explain datapump Oracle goldengate in detail
  • Ans. 

    A materialized view (mview) is a database object that contains the results of a query. Datapump is a tool for moving data between Oracle databases. Oracle GoldenGate is a real-time data integration and replication tool.

    • Materialized views (mviews) store the results of a query for faster access.

    • Datapump is a tool used for exporting and importing data between Oracle databases.

    • Oracle GoldenGate is a real-time data integrat...

  • Answered by AI
Round 2 - Behavioral 

(1 Question)

  • Q1. What is your goal

I applied via Naukri.com and was interviewed in Jun 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. How to configure RAC in detail? Shell scripting SQL scripting
  • Ans. 

    Configuring RAC involves setting up shared storage, network, and database components on multiple nodes.

    • Configure shared storage using ASM or NFS

    • Configure network components such as VIP, SCAN, and listener

    • Install Oracle Grid Infrastructure and Oracle Database software on all nodes

    • Create a RAC database using DBCA or manually

    • Configure load balancing and failover using services

    • Use shell scripting and SQL scripting to autom...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are preparing for amdocs make sure that you posses additional knowledge of the domain you are giving interview for.
If you are giving interview as 3+ years, they will expect that you should posses the expertise 5+ years of experience.

Skills evaluated in this interview

Oracle Interview FAQs

How many rounds are there in Oracle DBA Consultant interview?
Oracle interview process usually has 2 rounds. The most common rounds in the Oracle interview process are Resume Shortlist and Technical.
What are the top questions asked in Oracle DBA Consultant interview?

Some of the top questions asked at the Oracle DBA Consultant interview -

  1. Rdms architecture & dataguard conc...read more
  2. Rac implementation & exadata expos...read more

Tell us how to improve this page.

Oracle DBA Consultant Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
Google Interview Questions
4.4
 • 871 Interviews
Amdocs Interview Questions
3.7
 • 531 Interviews
Zoho Interview Questions
4.3
 • 514 Interviews
Cisco Interview Questions
4.1
 • 396 Interviews
View all
Senior Software Engineer
2.4k salaries
unlock blur

₹10.2 L/yr - ₹40 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹6.5 L/yr - ₹25 L/yr

Principal Consultant
2k salaries
unlock blur

₹10.9 L/yr - ₹36 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹12 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹9.5 L/yr - ₹34 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.1
Compare

IBM

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview