What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

what is the difference between catalog & nocatalog?

3 Answers   CSC,


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  


From the database level, how can you tell under which time zone a database is operating?

1 Answers  


How would you determine who has added a row to a table?

4 Answers  


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,






What is the default port no on which sql server listens? : sql server DBA

0 Answers  


How would you determine the time zone under which a database was operating?

2 Answers  


As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,


What is the default fill factor value? : sql server DBA

0 Answers  


how can you process messages in order asynchronously?

0 Answers   Oracle,


deleted of control file how will u recover control file?

4 Answers   CTS,


What are the recovery models for a database? : sql server DBA

0 Answers  


Categories