|
INTERVIEW QUESTIONS
DATABASE
DBA
DETAILS
Question: What are the components of SGA?
Answer: SGA is used to store shared information across all database users. It mainly includes Library cache, Data Dictionary cache, Database Buffer Cache, Redo log Buffer cache, Shared Pool.
Library cache - It is used to store Oracle statements.
Data Dictionary Cache - It contains the definition of Database objects and privileges granted to users.
Data Base buffer cache - It holds copies of data blocks which are frequently accessed, so that they can be retrieved faster for any future requests.
Redo log buffer cache - It records all changes made to the data files.
|
|
|
Category |
DBA Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8849 users |
Added on |
5/18/2016 |
Views |
66764 |
Rate it! |
|
|
Question:
What are the components of SGA?
Answer:
SGA is used to store shared information across all database users. It mainly includes Library cache, Data Dictionary cache, Database Buffer Cache, Redo log Buffer cache, Shared Pool.
Library cache - It is used to store Oracle statements.
Data Dictionary Cache - It contains the definition of Database objects and privileges granted to users.
Data Base buffer cache - It holds copies of data blocks which are frequently accessed, so that they can be retrieved faster for any future requests.
Redo log buffer cache - It records all changes made to the data files. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How can you determine if an index needs to be dropped and rebuilt?
|
View Answer
|
|
A user selects from a sequence and gets back two values, his select is?
|
View Answer
|
|
How can you find out how many users are currently logged into the database? How can you find their operating system id?
|
View Answer
|
|
If you have an example table, what is the best way to get sizing data for the production table implementation?
|
View Answer
|
|
A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
|
View Answer
|
|
How can you tell if a database object is invalid?
|
View Answer
|
|
What causes the "snapshot too old" error? How can this be prevented or mitigated?
|
View Answer
|
|
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
|
View Answer
|
|
When should more than one DB writer process be used? How many should be used?
|
View Answer
|
|
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
|
View Answer
|
|
What is the proper method for disabling and re-enabling a primary key constraint?
|
View Answer
|
|
What happens if a tablespace clause is left off of a primary key constraint clause?
|
View Answer
|
|
What happens if the constraint name is left out of a constraint clause?
|
View Answer
|
|
What are some of the Oracle provided packages that DBAs should be aware of?
|
View Answer
|
|
If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?
|
View Answer
|
|
You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
|
View Answer
|
|
What is the purpose of the IMPORT option IGNORE? What is it's default setting?
|
View Answer
|
|
Give one method for transferring a table from one schema to another?
|
View Answer
|
|
What are the different modals of windows?
|
View Answer
|
|
What is system.coordination_operation?
|
View Answer
|