What command is used to type files to the screen?
No Answer is Posted For this Question
Be the First to Post Answer
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
Discuss row chaining, how does it happen? How can you reduce it?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What is the difference between cold backup and hot backup?
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?
Explain the various modes of normalization?
How can you find your id on a system?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
How many types of database software are there?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
How can you determine the number of sqlnet users logged in to the unix system?
Explain the wait events in statspack report 'enqueue'?