Oracle DBA Interview Question

Get course
5.0
5 reviews

I have seen many people struggling to crack the dba interview. I have created the course by looking to there problem.

This course will not only will help you to crack the interview but also increase your knowledge.

I will be updating many new question with explained practically.

Following are the interview questions are covered along with practical solution. All the questions are frequently asked in interview.

1) Core DBA

2) Shell Scripting

3) Dataguard

4) ASM(Automatic Storage management)

5) Oracle 12C Administration

6) RMAN Backups

7) Logical Backups

8) Monitoring Tools

9) Basic understanding of ITIL Process

Course Feature

===========================

1)All videos contain the real time scenario which you will face in daily DBA routine. We create the problem and then provide the way to get the solution.

2)New Videos will be added to course on Daily or Weekly basis.

3)All the interview questions are frequently asked in interview.

4)Answers are provided in with practical presentation.

5)On Demand Videos will be added.

4)you can reach directly vie mail or message for any technical query.

5)Queries will be responded vie email.

 

Introduction

1
Introduction

Core DBA Interview Question Answer

1
1. What is use of Password File ?
1
2
2. Do we have separate set of processes & files for the pluggable database ?
3
3. How tablespaces works for container database or pluggable database ?
4
4. What are major changes you see in Oracle 12C ?
5
5.What will happen if the system tablespace is full ?
6
6. Why system tablespace is getting full frequently ?
7
7.Oracle Binary Relink ?
8
8. What will Happen if archieve log destination is full ?
9
9. What is archive log mode ?
10
10. What action need to take when archive destination get full ?
11
11. Control File lost.
12
12. What is multiplexing control files ?
13
13. How to check database status ?
14
14. How to put Database in Archieve/ No Archieve log mode ?
15
15. How to change sys, system password in Oracle 12c ?
16
16. When to relink Oracle Binaries ?
17
17. What to do if we add datafile with wrong name ?
18
18. When dirty blocks writes to disk?
19
19. What wouldbe impact on database if we delete alert log file ?
20
20. What action will you take when you get tablespace issue ?
21
21. What to do , if table already exists while importing ?
22
22. Can we create Oracle 19c & 21c non CDB Database

Backup and Recovery Interview Question Answer

1
1. What is difference between crash recovery and media recovery ?
2
2. Recover lost datafile.
3
3. Difference and Utilities to backup physical and logical component.
4
4. How to recover deleted table without backup ?
5
5. How to increase Incremental backup performance ?
6
6. Which files can RMAN backup ?
7
7. Explain the reason why RMAN need catalogue option ?
8
8. How to start a database when both parameter files lost and no backup file available ?
9
9. How to recover missing /corrupted Oracle inventory
10
10. How can you check data dump file is taken by exp or expdp ?

Patching Interview Question Answer

1
1. How to connect to PDB directly in oracle 12c ?
2
2. Patching downtime
3
3. How much time will require to apply a patch on 100 GB data and 1 TB Data ?
4
4. How many types of patches are there ?
5
5. Types of Patching conflicts ?
6
6. Patching process ?

Upgradation Interview Question Answer

1
1. Upgradation methods
2
2. How to restore to previous version if DB upgrade is failed ?
3
3. If your database upgrade is going on and suddenly you stopped database , then what will happen ?

Dataguard Interview Question Answer

1
1. Lag in primary to standby.
2
2. How to resolve huge gap in primary to standby database ?
3
3. Standby file management tips in dataguard.
4
4. Can Oracle’s dataguard be used on standard edition and if so how ? How can you test that the standby database is in sync ?
5
5. If you dont have access to the standby database and you wanted to findout what error has occured in a dataguard configuration , which view would you check in the primary database to check the error message ?
6
6. What is the use of active dataguard ?
7
7. If you have low bandwidth WAN network what can you do to improve the oracle 11g dataguard configuration in a GAP detection situation ?
8
8. Do we need additional software to configure dataguard ?
9
9. What type of Dataguard you worked
10
10. What is FAL_Client and FAL_Server parameter in dataguard ?

ASM Interview Question Answer

1
1. When should we use RMAN and when should we use ASMCMD copy ?
2
2. If we add a new disk to ASM Disk group , how long will this rebalance take ?
3
3. Start and stop ASM Instance with database.
4
4. What will happen if you missed to put ‘+’ symbol while adding datafile in tablespace for ASM ?
5
5. Can we shutdown the ASM before shutdown database ?

Performance Tuning

1
1. Why to rebuild the Indexes ?
2
2. What are the different tools and utilities used to fix performance related issues ?
3
3. How to improve SQL query performance ?
5.0
5 out of 5
5 Ratings

Detailed Rating

Stars 5
5
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review