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?
689You 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?
609If you have an example table, what is the best way to get sizing data for the production table implementation?
554Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
534Explain 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?
575If 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
Tell me about standby database? What are some of the configurations of it?
Which database is best to learn?
What is dba in sound level?
What is the difference between truncate and delete? How would a full table scan behave after?
What are the roles and responsibilities of oracle dba?
What happens when the default and temp tablespace clauses are left out from create user statements?
What skills does a dba need?
What do you mean by oracle dba and what is its role?
Discuss row chaining, how does it happen? How can you reduce it?
What does a senior database administrator do?
What is pga_aggregate_target?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
What does dba stand for in technology?
Give one method for transferring a table from one schema to another?
