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
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
What happens when the default and temp tablespace clauses are left out from create user statements?
What are database skills?
What do you understand by the term 'system change number (scn)'?
What do you understand by the term 'normalization'?
What are the different types of database users?
What is the purpose of the import option ignore? What is its default setting?
You see a wait on lms process in statspack, what does that mean?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
Does a dba have to file taxes?
What is dba training?
What is a production dba?