How do you prevent oracle from giving you informational messages during and after a sql statement execution?
How can you find all the processes on your system?
What happens when the default and temp tablespace clauses are left out from create user statements?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is pct free/pct used/pct increase parameter in segment?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What happens if a tablespace clause is left off of a primary key constraint clause?
Discuss row chaining, how does it happen?
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?
How can you find dead processes?
I am getting error "no communication channel" after changing the domain name? What is the solution?
Discuss row chaining, how does it happen? How do you correct it?
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?