Scribd
Upload
61 views6 pages

Interview Questions Checklist 1-2 Years: Area of Skill Covered Topics

The document outlines interview questions for Oracle database administrators with 1-2 years, 3-5 years, and 5+ years of experience. It lists common areas of skill and topics that should be covered for each experience level, including SQL, database objects, architecture, administration, ASM, RAC, Data Guard, backup/recovery, and performance monitoring/tuning. For more experienced candidates, it indicates more advanced topics within these areas, such as ASM disk groups, RAC configurations, Data Guard protection modes, and SQL tuning.

Uploaded by

Khawar Baig
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views6 pages

Interview Questions Checklist 1-2 Years: Area of Skill Covered Topics

The document outlines interview questions for Oracle database administrators with 1-2 years, 3-5 years, and 5+ years of experience. It lists common areas of skill and topics that should be covered for each experience level, including SQL, database objects, architecture, administration, ASM, RAC, Data Guard, backup/recovery, and performance monitoring/tuning. For more experienced candidates, it indicates more advanced topics within these areas, such as ASM disk groups, RAC configurations, Data Guard protection modes, and SQL tuning.

Uploaded by

Khawar Baig
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Interview Questions Checklist

1-2 years
Area of skill
1. Sql/PLSQL

2. Database objects

3. Database Architecture

4. Database Administration

5.
6.
7.
8.

Oracle ASM
Oracle RAC
Oracle data guard
Backup and Recovery

Covered topics

Conditions ,clauses and operators


Common SQL syntax errors
Dynamic SQL
Cursors
PL/SQL blocks
Functions IN OUT parameters.
Procedures
Types.
Tables
Views and materialized views
Triggers
Sequences
Jobs
Indexes- BTree and Bitmap
Integrity constraints
Instance and database
Data files
Extent, segments and blocks
Spfile
Control files
SGA and PGA
Background processes
Logfiles
Archive and no archive modes
Flash recovery area
Sessions
Data dictionary
Installation on linux
Starting and shutting down the
databases
Managing data files.
Managing log files
Managing users
Process management
Basic knowledge
Basic knowledge
Basic knowledge
Flashback recovery concepts
RMAN backups and recovery

9. Performance monitoring

Hot vs cold backups

Enterprise manager

Conditions ,clauses and operators


Common SQL syntax errors
Dynamic SQL
Cursors
PL/SQL blocks
Functions IN OUT parameters.
Procedures
Types.
Tables
Views and materialized views
Triggers
Sequences
Jobs
Indexes- BTree and Bitmap
Integrity constraints
Instance and database
Data files
Extent, segments and blocks
Spfile
Control files
SGA and PGA
Background processes
Logfiles
Archive and no archive modes
Flash recovery area
Sessions
Data dictionary
Installation on linux
Listener management
Net services
Starting and shutting down the
databases
Managing data files.
Managing log files
Managing users
Managing resources

3-5 Years
Area of skill
10.Sql/PLSQL

11.Database objects

12.Database Architecture

13.Database Administration

Covered topics

14.Oracle ASM

15.Oracle RAC

16.Oracle data guard

17.Backup and Recovery

18.Performance monitoring

Managing roles and privileges


Managing alerts, alert log and
trace files
Managing instances
Memory management
Process management
Managing logs
ASM configuration
Managing disk groups
ASM alert log
ASMCMD
ASM troubleshooting
ASM rebalance
RAC installation
RAC configurations
OCR management
CRS and CSS management
Load balancing
SRVCTL
RAC Listener
Global performance view
Physical and logical stand by
Remote log groups
Redo transport service
Protection modes
Initialization parameters
Flashback recovery concepts
RMAN backups and recovery
Hot vs cold backups
DBID
Full vs incremental backups
Level 0 vs level 1 backups
Archive logs
Complete vs incomplete recovery
Open database reset logs
Dynamic performance views
Performance monitoring with
Enterprise manager
SQL plan
SQL access path
ADDM and AWR reports
Common alerts in alert log
Common ora- errors and solution

19.Performance tuning

Undo and redo management


Wait events
Enqueuer locks
Blocking sessions
Indexing for performance
Redefinition and reorganization of
database objects
High water mark
Avoiding row lock conflicts
Avoiding buffer busy waits
SQL rewrite
Index and table partitioning

5+ Years
Area of skill
20.Sql/PLSQL

21.Database objects

22.Database Architecture

Covered topics

Conditions ,clauses and operators


Common SQL syntax errors
Dynamic SQL
Cursors
PL/SQL blocks
Functions IN OUT parameters.
Procedures
Types.
Tables
Views and materialized views
Triggers
Sequences
Jobs
Indexes- BTree and Bitmap
Integrity constraints
Instance and database
Data files
Extent, segments and blocks
Spfile
Control files
SGA and PGA
Background processes
Logfiles
Archive and no archive modes
Flash recovery area
Sessions
Data dictionary

23.Database Administration

24.Oracle ASM

25.Oracle RAC

26.Oracle data guard

27.Backup and Recovery

Installation on linux
Listener management
Net services
Starting and shutting down the
databases
Managing data files.
Managing log files
Managing users
Managing resources
Managing roles and privileges
Managing alerts, alert log and
trace files
Managing instances
Memory management
Process management
Managing logs
ASM configuration
Managing disk groups
ASM alert log
ASMCMD
ASM troubleshooting
ASM rebalance
RAC installation
RAC configurations
OCR management
CRS and CSS management
Load balancing
SRVCTL
RAC Listener
Global performance view
Physical and logical stand by
Remote log groups
Redo transport service
Protection modes
Initialization parameters
Flashback recovery concepts
RMAN backups and recovery
Hot vs cold backups
DBID
Full vs incremental backups
Level 0 vs level 1 backups
Archive logs
Complete vs incomplete recovery
Open database reset logs

28.Performance monitoring

29.Performance tuning

Dynamic performance views


Performance monitoring with
Enterprise manager
SQL plan
SQL access path
ADDM and AWR reports
Common alerts in alert log
Common ora- errors and solution
Undo and redo management
Wait events
Enqueuer locks
Blocking sessions
Indexing for performance
Redefinition and reorganization of
database objects
High water mark
Avoiding row lock conflicts
Avoiding buffer busy waits
SQL rewrite
Index and table partitioning

You might also like