interview questions with answer for cts

2092

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

1926

How to create a new tablespace in oracle?

561

What is autocashrule set? : oracle accounts receivable

745

Which environment variables are absolutely critical in order to run the OUI?

1664

In the oracle version 9.3.0.5.0, what does each number shows?

753

What happens if you use a wrong connect identifier?

505

What is using clause and give example?

591

in the package one interface got failed how to know which interface got failed if we no access to operator?

329

What is the difference between a database and instance?

354

How to write numeric literals in oracle?

620

How can we generate report output in excel format?

555

Which function is used to find the largest integer less than or equal to aspecific value?

303

Explain view?

584

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

1958