What is mean by Program Global Area (PGA) ?
Answer Posted / rashid ansari
if oracle user dedicated server then only oracle create PGA
for each user.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is literal?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Explain drop constraint oracle?
What is transport network substrate (tns) in oracle?
What are the differences between date and timestamp in oracle?
What are the predefined tablespaces in a database?
What are the limitations of check constraint?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Give syntax for SQL and ORACLE joins.
How is it different from a normal table?
What is backup in Oracle?
How many file formats are supported to export data?
What is a initialization parameter file in oracle?
What is a directory object?
Briefly explain what is literal? Give an example where it can be used?