What is explain plan and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
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?
What are the different types of database users?
What are the goals of dba?
Which database is best to learn?
What is the difference between internal & external schema?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What happens if a tablespace clause is left off of a primary key constraint clause?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
How many control files should you have? Where should they be located?
What are dba privileges?
How can you find all the processes on your system?