Interested to Buy Any Domain ? << Click Here >> for more details...
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
693You 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?
612If you have an example table, what is the best way to get sizing data for the production table implementation?
560Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
537Explain 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?
579If you see the value for reloads is high in the estat library cache report is this a matter for concern?
631Post New Oracle DBA (Database Administration) Questions
What does an oracle dba do?
What is the difference between truncate and delete? How would a full table scan behave after?
Can you remove an open file under unix?
Tell me about standby database? What are some of the configurations of it?
Explain the wait events in statspack report 'db sequential real'?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How can I learn oracle dba?
What is the difference between a database and instance?
What are the types of locks in database?
If you are not sure what command does a particular unix function what is the best way to determine the command?
What does dba stand for in technology?
What is the difference between sga and pga?
What do you mean by oracle database?
What is oracle log switch?
What are types of data model?
