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

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

What are the goals of dba?

0 Answers  


What are the requirements of simple database?

0 Answers  


What command is used to type files to the screen?

0 Answers  


What are the five main functions of a database administrator?

0 Answers  


Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

0 Answers  






How can you find out how many users are currently logged into the database? How can you find their operating system id?

0 Answers  


What happens if a tablespace clause is left off of a primary key constraint clause?

0 Answers  


What database block size should I use?

0 Answers  


Which rman command is used to create an exact replica of a database innew host?

0 Answers  


What are the steps involved in instance recovery in oracle?

0 Answers  


Why are recursive relationships bad? How do you resolve them?

0 Answers  


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.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)