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?
No Answer is Posted For this Question
Be the First to Post Answer
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?
What is a dba certification?
How can you tell if an index on particular table is used or not used in 9i?
What is the easiest method to create a file on unix?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
When should an artificial (or derived) primary key be used?
What do you understand by the term 'system change number (scn)'?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What are some indications that you need to increase the shared_pool_size parameter?
What is the difference between raid 5 and raid 10? Which is better for oracle?