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?

2410

What are the operating modes in which database mirroring runs? : sql server DBA

857

What is dcl? : sql server DBA

890

how can you enable flashback feature?

715

what is a crs resource?

855

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

759

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2057

what is the diffrence between core dba and apps dba?

2313

what is the use of ocr?

788

Why does Oracle not permit the use of PCTUSED with indexes?

2584

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

784

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1777

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

762

how can you process messages in order asynchronously?

745

What are the different sql server versions you have worked on? : sql server DBA

765