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?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? Why is one faster?
Explain the wait events in statspack report 'db scattered read'?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
Tell me about standby database? What should we watch out for?
What are functions of dba?
When should the default values for oracle initialization parameters be used as is?
When should an artificial (or derived) primary key be used?
What is the easiest method to create a file on unix?
What is oracle partial backup?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What are the goals of dba?
What is the difference between cold backup and hot backup?