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?

1996

What is using clause and give example?

1001

what systems can odi extract and load data into?

538

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

589

What is a system tablespace and why do we need it?

1

material view and view disadvantages?

1023

Explain oracle’s system global area (sga).

1087

How to omit columns with default values in insert statement in oracle?

1008

What is the importance of batch source set up in ar? : oracle accounts receivable

1203

how the indexes are stored in the Oracle Database?

2222

What is the difference between instance recovery and crash recovery?

1

Which profile required to access solution in Designer tool?

551

When using oracle export/import what character set concerns might come up? How do you handle them?

544

How to convert characters to numbers in oracle?

1011

How to create a server parameter file?

1089