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
what is the difference between catalog & nocatalog?
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?
From the database level, how can you tell under which time zone a database is operating?
How would you determine who has added a row to a table?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
What is the default port no on which sql server listens? : sql server DBA
How would you determine the time zone under which a database was operating?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is the default fill factor value? : sql server DBA
how can you process messages in order asynchronously?
deleted of control file how will u recover control file?
What are the recovery models for a database? : sql server DBA