Interested to Buy Any Domain ? << Click Here >> for more details...
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
576using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1017What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
563What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
588Post New Oracle DBA (Database Administration) Questions
What parameters control copy latches?
Does dba need to know programming?
What does a dba do all day?
How can you find all the processes on your system?
How many types of database software are there?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What is the meaning of database backup?
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?
Discuss row chaining, how does it happen? How do you correct it?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
If you see statistics that deal with "undo" what are they really talking about?
What are the different types of backup available in the oracle?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
I have applied the following commands: now what will happen, will the database will give an error / it will work?
