Top 20 Oracle 10g Interview Questions and Answers
Q11. Which Date Function Returns Number Value?
months_between
Q12. How Might You Enforce Security Using Stored Procedures?
Try not to concede client access straightforwardly to tables inside the application.
Rather award the capacity to get to the methods that entrance the tables.
At the point when methodology executed it will execute the honor of techniques proprietor. Clients can't get to tables with the exception of by means of the system.
Q13. What Is A Shared Pool?
Shared pool in prophet contains store data that gathers, parses, deciphers and executes SQL explanations that conflicts with data set. This common pool behaves like a cradle for these SQL explanations.
Q14. What Are Disadvantages Of Having Raw Devices?
We ought to rely upon send out/import utility for reinforcement/recuperation (completely solid)
The tar order can't be utilized for actual document reinforcement, rather we can utilize dd order, which is less adaptable and has restricted recuperations.
Q15. What Is A Database Instance? Make sense of.
A data set occasion (Server) is a bunch of memory construction and foundation processes that entrance a bunch of data set records. The cycles can be shared by the clients in general.
The memory structure that is utilized to store the most questioned information from data set. This ups to further develop data set execution by diminishing how much I/O performed against information document.
Q16. What Are Some Advantages To Using Oracle's Create Database Statement To Create A New Database Manually?
You can prearrange the cycle to remember it for a bunch of introduce scripts you convey with an item.
You can put your make data set script in CVS for rendition control, so as you make changes or acclimations to it, you can follow them as you do changes to programming code.
You can log the result and survey it for blunders. You study the course of information base creation, for example, what choices are accessible and why.
Q17. What Is Use Of Rollback Segments In Oracle Database?
They permit the information base to keep up with read consistency between various footings.
Q18. Show Odd/Even Number Of Records
Odd number of records:
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);
1
3
5
Much number of records:
select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp)
2
4
6
Q19. What Is Hit Ratio?
It is a proportion of well the information store support is taking care of solicitations for information.
Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/Logical Reads.
Q10. What Is A Database Link?
Data set interface is a named way through which a far off information base can be gotten to.
Q11. Will A View Based On Another View?
Indeed.
Q12. Do A View Contain Data?
Sees don't contain or store information.
Q13. What Is A Data Segment?
Information portion are the actual regions inside a data set block in which the information related with tables and groups are put away.
Q14. What Are The Characteristics Of Data Files?
An information record can be related with just a single data set. When made an information document can't change size. At least one information documents structure an intelligent unit of data set capacity called a tablespace.
Q15. What Is A Redo Log?
The arrangement of re-try log documents for a data set is by and large known as the data set re-try log.
Q16. How To Implement The Multiple Control Files For An Existing Database?
Closure the information base
Duplicate one of the current controlfile to new area
Alter Config ora document by adding new control filename
Restart the data set.
Q17. What Is The Use Of Control File?
At the point when a case of an Oracle information base is begun, its control document is utilized to recognize the data set and re-try log documents that should be opened for data set activity to continue. It is likewise utilized in data set recuperation.
Q18. What Is A Join? Make sense of The Different Types Of Joins?
Join is an inquiry, which recovers related segments or columns from numerous tables.
Self Join - Joining the table with itself.
Equi Join - Joining two tables by comparing two normal sections.
Non-Equi Join - Joining two tables by comparing two normal segments.
External Join - Joining two tables so that question can likewise recover columns that don't have comparing join esteem in the other table.
Q19. What Are The Components Of Logical Database Structure Of Oracle Database?
There are tablespaces and information base's composition objects.
Q20. It Is Possible To Use Raw Devices As Data Files And What Are The Advantages Over File System Files?
The benefits over document framework records are that I/O will be improved in light of the fact that Oracle is bye-passing the portion which composing into plate. Circle debasement will be exceptionally less.
