You see multiple fragments in the system tablespace, what should you check first?
What is dba training?
Explain the term 'oracle grid architecture'?
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?
Which function is used to find the largest integer less than or equal to aspecific value?
Who is a database user?
How do you prevent output from coming to the screen?
While taking hot backup (begin end backup) what will happens back end?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How can you find out how many users are currently logged into the database?
What is different type of rman backup?
What is difference between logical standby database and physical standby database?
What should a dba know?
What do you mean by oracle dba and what is its role?