What is an artificial (derived) primary key? 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 understand by the term 'normalization'? Explain the various modes of normalization?
How many control files should you have?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What are the main benefits of using spfile over pfile?
What is dba training?
What are dba privileges?
How does one coalesce free space?
What are the daily activities of oracle dba?
What is end user in database?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What are the different types of backup available in the oracle?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.