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 the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
Which files are vital that should be backed up?
You have taken a manual backup of a datafile using os. How rman will know about it?
Do you need a commit after ddl statements?
What is the difference between a database and instance? What is the relation between them?
What is a production dba?
You see multiple fragments in the system tablespace, what should you check first?
What are the different types of backup available in the oracle?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What are elements of administration?
What is difference between logical standby database and physical standby database?
What is dba and functionalities of dba?