How many types of database software are there?
No Answer is Posted For this Question
Be the First to Post Answer
What are the goals of dba?
How many control files should you have?
What is explain plan and how is it used?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What is the difference between cold backup and hot backup?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Which rman command is used to create an exact replica of a database innew host?
What is oracle archived redo log?