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
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?
When configuring sqlnet on the server what files must be set up?
Why are recursive relationships bad? How do you resolve them?
Which date function is used to find the difference between two dates?
How long does it take to learn database administration?
How does one create a new database?
How many control files should you have? Where should they be located?
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?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
what does the no logging option do? Why would we use it?
What operator tests column for the absence of data?
What are the skills required for oracle dba?