Technical Interview Questions & Answers

What is the purpose of the product order option in the column property sheet? To specify the order of individual group evaluation in a cross...

What is mean by Program Global Area (PGA)? It is area in memory that is used by a single Oracle user process. What is a data segment? Data s...

Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? (for DBA) Tempfiles, unlike normal datafiles, are not listed in...

What is a deadlock ? Explain . Two processes wating to update the rows of a table which are locked by the other process then deadlock arises...

What is an Oracle sequence? A sequence generates a serial list of unique numbers for numerical columns of a database's tables. What is a...