Top 50 Oracle Core Dba Interview Questions
Top 50 Oracle Core Dba Interview Questions You Must Prepare 26.Jul.2022
Q1. What Is Data Block?
Oracle database's statistics is saved in information blocks. One information block corresponds to a specific wide variety of bytes of bodily database area on disk.
Q2. What Is Index Cluster?
A cluster with an index at the cluster key.
Q3. What Are The Advantages Of Views?
Provide an additional level of desk safety, by way of limiting access to a predetermined set of rows and columns of a desk.
Hide data complexity.
Simplify instructions for the user.
Present the records in a distinct attitude from that of the base table.
Store complex queries.
Q4. What Is The Use Of Control File?
When an instance of an Oracle database is began, its control document is used to identify the database and redo log files that should be opened for database operation to proceed. It is also utilized in database healing.
Q5. What Is A Private Synonym?
Only its owner can get entry to a personal synonym.
Q6. How Are The Index Updated?
Indexes are routinely maintained and used by Oracle. Changes to table data are mechanically integrated into all applicable indexes.
Q7. What Is A Redo Log?
The set of redo log files for a database is together called the database redo log.
Q8. Can A Tablespace Hold Objects From Different Schemes?
Yes
Q9. What Is Cluster Key?
The related columns of the tables in a cluster are referred to as the cluster key.
Q10. What Is An Index Segment?
Each index has an index phase that stores all of its data.
Q11. What Are The Types Of Database Links?
Private database hyperlink, public database hyperlink & community database hyperlink.
Q12. What Are Schema Objects?
Schema gadgets are the logical systems that at once check with the database's records. Schema gadgets include tables, perspectives, sequences, synonyms, indexes, clusters, database triggers, approaches, functions programs and database hyperlinks.
Q13. What Is An Oracle Sequence?
A series generates a serial listing of specific numbers for numerical columns of a database's tables.
Q14. What Is The Function Of Redo Log?
The primary feature of the redo log is to file all changes made to data.
Q15. Explain The Relationship Among Database, Tablespace And Data File?
Each databases logically divided into one or greater tablespaces one or greater statistics documents are explicitly created for every tablespace.
Q16. What Is An Oracle View?
A view is a digital desk. Every view has a query attached to it. (The question is a SELECT assertion that identifies the columns and rows of the desk(s) the view uses.)
Q17. What Is System Tablespace And When Is It Created?
Every Oracle database consists of a tablespace named SYSTEM, that is mechanically created when the database is created. The SYSTEM tablespace usually incorporates the information dictionary tables for the whole database.
Q18. What Are Clu
