Interested to Buy Any Domain ? << Click Here >> for more details...
What is Database Buffers ?
- 1 Answers
- 4962 Views
- I also Faced
- E-Mail Answers
Answer / sawant
Database buffers are cache in the SGA used to hold the data
blocks that are read from the data segments in the
database such as tables, indexes and clusters
DB_BLOCK_BUFFERS parameter in INIT.ORA decides the size.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a user account in oracle?
Can we create more than one constraint to column ?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What do you mean by merge in oracle and how can we merge two tables?
What does ROLLBACK do ?
List the various oracle database objects?
What is clustered table in Oracle?
Define 'view' advantage ?
What are the Characteristics of Data Files ?
What is a select query statement in oracle?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Explain what are the different type of segments?
Oracle General 
