Oracle DBA Interview Question

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%20DBA%20Interview%20Question%20Answer

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
23
23. What happens when we open the database with resetlog?
24
24. What is multitenant architecture in oracle database?
25
25. What are the different stages of your oracle database whenever you are starting your oracle database?
26
26. How to put pdb in restricted mode ?
27
#shorts If Password file gets corrupted or lost , What will be impact on database?
28
28. Responsibilities as Oracle DBA
29
29. When the Database goes down what will do?
30
30. What is the size of datafile?
31
How to generate AWR Reports ?
32
How to create BigFile Tablespace ?
33
How to check database version?

Backup%20and%20Recovery%20Interview%20Question%20Answer

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 ?
11
11. What type of backup you are taking in Real time production environment?
12
12. How to restore spfile, when backup is not available ?

Patching%20Interview%20Question%20Answer

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 ?
7
7. How to apply a patch on your oracle database?
8
8. How to check the patches applied to oracle database?

Upgradation%20Interview%20Question%20Answer

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%20Interview%20Question%20Answer

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 ?
11
11. Why we enable force login option in the dataguard environment?
12
12. How many standby logs need to be created ? What should be the size?
13
13. What is mean by switchover in oracle dataguard environment?
14
14. How to upgrade the oracle database when you have a dataguard environment ?
15
15. How to perform patching activity in the oracle dataguard environment ?
16
16. Explain different protection modes in dataguard?

ASM%20Interview%20Question%20Answer

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 ?
6
6. What are all files can be stored under oracle ASM ?
7
7. Why should you use different ASM home & Oracle home?
8
8. What is ASM Disk group?
9
9. What is ASM ?
10
10. What are the benefits of oracle ASM?
11
11. Is it possible to unplug ASM disk from one platform & plugin to another platform?
12
12. How to move a file from ASM filesystem?
13
13. How to take the backup of oracle ASM?
14
14. How to get the location of your SPfile stored in ASM?
15
15. How to add a disk to ASM Disk Group?
16
16. How to start Oracle database which is having ASM?
17
How to add a datafile into ASM ?

Performance%20Tuning

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 ?

RAC%20Interview%20Question%20Answer

1
1. What is SCAN ?
2
2. What is the purpose of OLR file?
3
3. In RAC, How can you flush shared pool or buffer cache of all the nodes in one command?
4
4. What are the files that you can store in oracle RAC shared storage?
5
5. How to findout Master Node in RAC Database?
6
6. How to know whether all the nodes in the cluster are up & running ?
7
7. How to check which services are currently up and running on the cluster?
8
8. How to check voting disk location?
9
9. How to enable archive log mode in RAC?
10
10. What is Voting Disk in RAC ?
11
11. How to know , whether it is Single Database or Cluster (RAC) Database ?
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