When should you increase copy latches? What parameters control copy latches?

292

What is oracle archived redo log?

279

Explain oracle’s server parameter file.

559

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

303

Explain prerequisites and post activities of oracle database installation

1608

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1648

how can we store any pdf file in oracle

1630

from where do u receive the information to develop report

1521

What do you mean by a deadlock?

507

What is the usage of merge statement?

663

What is format trigger?

1610

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1634

In what script is snap$ created? In what script is the scott/tiger schema created?

2232

Where are the settings stored for each instance in oracle?

617

How to create a new oracle data file?

547