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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the goals of dba?
What are the requirements of simple database?
What command is used to type files to the screen?
What are the five main functions of a database administrator?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What happens if a tablespace clause is left off of a primary key constraint clause?
What database block size should I use?
Which rman command is used to create an exact replica of a database innew host?
What are the steps involved in instance recovery in oracle?
Why are recursive relationships bad? How do you resolve them?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.