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?
652You 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?
572If you have an example table, what is the best way to get sizing data for the production table implementation?
510Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
498Explain 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?
532If you see the value for reloads is high in the estat library cache report is this a matter for concern?
580Post New Oracle DBA (Database Administration) Questions
What operator tests column for the absence of data?
What are the types of schemas?
What is dba and functionalities of dba?
How does one coalesce free space?
What is dump destination? What are bdump, cdump and udump?
What is a production dba?
How can you tell if an index on particular table is used or not used in 9i?
What is the main function of database?
Which date function is used to find the difference between two dates?
What are bind variables and why are they important?
You see multiple fragments in the system tablespace, what should you check first?
What degree do database administrators need?
How can you find your id on a system?
What do you mean by oracle dba and what is its role?
How do I become an administrator?
