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?
- 0 Answers
- 354 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is your favorite tool for day-to-day oracle operation?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What skills should a dba have?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What is explain plan and how is it used?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are the daily activities of oracle dba?
Which process writes data from data files to database buffer cache?
What does dba stand for database?
You have taken a manual backup of a datafile using os. How rman will know about it?
Discuss row chaining, how does it happen? How can you reduce it?
How do you generate file output from sql?
Oracle General 
