Why are recursive relationships bad? How do you resolve them?
No Answer is Posted For this Question
Be the First to Post Answer
When should an artificial (or derived) primary key be used?
Which process writes data from data files to database buffer cache?
How many types of database software are there?
How do you use automatic pga memory management with oracle 9i and above?
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 bind variables and why are they important?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What is the easiest method to create a file on unix?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What does database administrator do?
You see multiple fragments in the system tablespace, what should you check first?
What is the purpose of the grep command?