What is difference between co-related sub query and nested sub query?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a database and instance? What is the relation between them?
What is dba software?
What is the most common database language that a db administrator needs to know?
Which rman command is used to create an exact replica of a database innew host?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
Who is a database user?
What are the five functions of a database?
As an oracle dba what are the entire unix file you should be familiar with?
What are the steps involved in instance recovery in oracle?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is oracle log switch?