When should an artificial (or derived) primary key be used?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by oracle dba?
How can you tell if a tablespace has excessive fragmentation?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
When configuring sqlnet on the server what files must be set up?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
Discuss row chaining, how does it happen? How do you correct it?
What is a database instance?
How do you set up tablespaces during an oracle installation?
When configuring sqlnet on the client what files need to be set up?
What is the easiest method to create a file on unix?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
What is the advantage of using rman?