Top 20 Oracle DBA Interview Questions and Answers
Q1. What Is Row Migration And Row Chaining?
Column Migration:
Column Migration alludes to lines that were moved to one more blocks because of an update making them too enormous to even consider squeezing into their unique blocks.
Prophet will leave a sending pointer in the first block so records can in any case "find" the column. Note that Oracle doesn't segregate among affixed and relocated lines, despite the fact that they have various causes. A binded line is a column that is too huge to even think about squeezing into a solitary data set information block.
For instance, in the event that you utilize a 4KB blocksize for your data set, and you want to embed a line of 8KB into it, Oracle will involve 3 blocks and store the column in pieces.
A few circumstances that will cause line fastening are:
Tables whose line size surpasses the blocksize.
Tables with long and long crude segments are inclined to having anchored lines.
ables with additional then 255 sections will have affixed lines as Oracle split wide tables up into pieces.
Identifying line fastening:
This question will show the number of binded (and moved) pushes each table has:
SQL>SELECT proprietor, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0;
To see which lines are tied:
SQL>ANALYZE TABLE tablename LIST CHAINED ROWS;
This will place the lines into the INVALID_ROWS table which is made by the utlvalid.sql script (situated in $ORACLE_HOME/rdbms/administrator).
Q2. What Are The Major Components Of Warehouse Builder?
Prophet Warehouse Builder(OWB) is made out of Design focus, Control focus chief, target composition, Warehouse developer archive, Repository program, control focus administration.
Q3. What Is The Use Of Ocr?
Prophet clusterware oversees CRS assets in view of the design data of CRS assets put away in OCR(Oracle Cluster Registry).
Q4. What Is Database Security?
The objective of information base security is to forestall unapproved utilization of data set or its components.Database security relies upon framework and organization security.
Q5. How Do You Start Or Stop An Instance On Rac?
Following explanations can be utilized to begin or stop a case on RAC:
Q6. What Are The Built-in's Used For Finding Object Id Functions?
Find_group(function),
Find_column(function).
Q7. What Is A Latch? How Could It be Used In Oracle?
A lock is a semaphore or an on/off switch in Oracle data set that a cycle should access to lead specific kind of exercises. Locks oversee the utilization of Oracle's inward assets by its cycles. They implement sequential admittance to the assets and cutoff how much time for which a solitary interaction can utilize an asset.
There are more than 80 hooks accessible in Oracle.
Q8. What Are The Performance Views In An Oracle Rac Environment?
We have v$ sees that are case explicit. Furthermore we have GV$ sees called as worldwide perspectives that has an INST_ID section of numeric information type. GV$ sees get data from individual V$ sees.
Q9. What Are Most Common Types Of Complex Master-detail Relationships?
There are three most normal kinds of mind boggling ace detail connections:
ace with subordinate subtleties
ace with autonomous subtleties
detail with two bosses
Q10. Which Components Are Shared In Rac?
A RAC arrangement shares datafiles, control records, SP Files, re-try log documents; consequently, these documents should be put away in the group mindful shared stockpiling.
Q11. How Are The Index Updates?
Lists are consequently kept up with and utilized by Oracle. Changes to table information are naturally integrated into every applicable record.
Q12. What Is Distributed Database ?
A conveyed information base is an organization of data sets oversaw by different data set servers that appears to a client as single legitimate data set. The information of all data sets in the appropriated data set can be all the while gotten to and adjusted.
Q13. In A Client Server Environment, What Would Be The Major Work That The Client Deals With?
The client manages the UI part of the framework.
Q14. How You Will Avoid Your Query From Using Indexes?
By changing the request for the sections that are utilized in the list, in the Where condition, or by linking the segments for certain steady qualities.
Q15. What Is Data Guard?
Information watch is an arrangement where you can have at least one reserve data set accessible for a creation data set.
Q16. What Is A Database Trigger?
An information base trigger is occasion driven program. You don't have to conjure a trigger. It is terminated while setting off occasion occurs.
Q17. What Are The Vbx Controls?
Vbx control give a basic strategy for building and upgrading UIs. The controls can use to get client sources of info and show program yields. vbx control where initially create as expansions for the ms visual essential conditions and incorporate such things as sliders, rides and handles.
Q18. What Is Parallel Degree Limit?
Equal degree limit is a portion technique for level of parallelism. It determines the greatest level of parallelism for an activity. It tends to be set utilizing the PARALLEL_DEGREE_LIMIT_P1 boundary.
The default worth of this boundary is invalid which shows no restriction is forced.
Q19. Which System Tables Contain Information On Privileges Granted And Privileges Obtained?
USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD.
Q20. What Is Relation Between The Window And Canvas Views?
Material perspectives are the back ground objects on which you place the connection point things (Text things), check boxes, radio gatherings and so forth, and standard articles (boxes, lines, pictures and so on,) that administrators cooperate with us they run your structure . Each material perspectives showed in a window.
