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
how does an oracle clusterware manage crs resources?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the role of dip user in our database?
Explain what partitioning is and what its benefit is.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
1)how to Take Backup in sql server 2005 from Flash Drive
What the different topologies in which replication can be configured? : sql server DBA
What command would you use to create a backup control file?