What do you understand by the term 'normalization'? Explain the various modes of normalization?
No Answer is Posted For this Question
Be the First to Post Answer
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
When configuring sqlnet on the client what files need to be set up?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What are functions of dba?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
What do you understand by the term 'normalization'?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
How many types of dba are there?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?