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?
how can you initialize log miner?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
What is the difference between clustered and non-clustered index? : sql server DBA
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you generate profile of pl/sql applications to identify performance bottlenecks?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
deleted of control file how will u recover control file?
what do you understand by flashback feature of oracle?