Oracle DBA Interview Questions and Answers

Oracle DBA Interview Questions and Answers

Top Oracle DBA Interview Questions and Answers: Below, we have covered detailed answers to the Oracle DBA Interview Questions Which will be helpful to freshers and experienced Professionals. All the best for your interview Preparation.

 

What is a database?

What are the different types of storage systems available and which one is used by Oracle?

Explain some examples of join methods

What are the components of logical data model and list some differences between logical and physical data model?

Difference between Logical and Physical data model.

Explain Two Easy Sql Optimizations?

Name Three Sql Operations That Perform a Sort?

Explain the Difference Between a Function, Procedure and Package?

Explain the Use of Table Functions?

Name Three Advisory Statistics You Can Collect?

Where in The Oracle Directory Tree Structure Are Audit Traces Placed?

Explain Materialized Views and How They Are Used?

What Background Process Refreshes Materialized Views?

Describe What Redo Logs Are?

How Would You Force a Log Switch?

What Does Coalescing a Tablespace Do?

What Is the Difference Between a Temporary Tablespace and A Permanent Tablespace?

How Do You Add a Data File to A Tablespace?

How Do You Resize a Data File?

What View Would You Use to Look at The Size of a Data File?

What View Would You Use to Determine Free Space In A Tablespace?

How Would You Determine Who Has Added a Row to A Table?

How Can You Rebuild an Index?

Explain What Partitioning Is and What Its Benefit Is?

How Can You Gather Statistics on A Table?

How Can You Enable a Trace for A Session?

What Is the Difference Between the Sql*loader And Import Utilities?

What Is the Job of Smon And Pmon Processes?

How Do You Control Number Of Datafiles One Can Have In An Oracle Database?

What Is a Tablespace?

What Is the Purpose Of Redo Log Files?

What Is a Shared Pool?

When Should You Rebuilt Indexes?

Can You Built Indexes Online?

What Is Db Buffer Cache Advisor?

What Is Statspack Tool?

What Is Schema?

What Are Schema Objects?

What Is Oracle Table?

What Is an Oracle View?

What Is Partial Backup?

What Is Full Back up?

What Is the Use of Control File?

What Is A Redo Log?

What Are Clusters?

What Is an Integrity Constraint?

What Is an Index?

What Is an Extent?

What Is a View?

What Is Table?

What Is a Synonym?

What Is a Private Synonym?

What Is a Public Synonym?

What Is Index Cluster?