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
why we use cursors
What is RAID and what are different types of RAID configurations?
What questions might be they ask in managerial round in capgemini.
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
Explain the difference between a data block, an extent and a segment.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What the different types of replication and why are they used? : sql server DBA
What is the default fill factor value? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what is the use of ocr?
How to determine the service pack currently installed on SQL Server?
Which autogrowth database setting is good? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)