Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Explain procedure to change characterset of a database.
What is the use of the drop option in the alter table command?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Tell me about standby database? What should we watch out for?
How does one coalesce free space?
How many databases should a dba manage?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
Does a dba have to file taxes?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
What is difference between co-related sub query and nested sub query?