Answer / kittu_chintu2005

In LMT: A tablespace that manages its own extents maintains a bitmap in each datafile to keep track of the free or used status of blocks in that datafile. Each bit in the bitmap corresponds to a group of blocks. When an extent is allocated or freed for reuse, Oracle changes the bitmap values to show the new status of the blocks. These changes do not generate rollback information because they do not update tables (like sys.uet$, sys.fet$) in the data dictionary (except for special cases such as tablespace quota information).

When you create a locally managed tablespace, header bitmaps are created for each datafile. If more datafiles are added, new header bitmaps are created for each added file.

In DMT:In DMT, to keep track of the free or used status of blocks, oracle uses data dictionary tables. When an extent is allocated or freed for reuse, free space is recorded in the SYS.FET$ table, and used space in the SYS.UET$ table. Whenever space is required in one of these tablespaces, the ST (space transaction) enqueue latch must be obtained to do insert and deletes against these tables. As only one process can acquire the ST enque at a given time, this often lead to contention. These changes generate rollback information because they update tables (like sys.uet$, sys.fet$) in the data dictionary.

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1 Answers  

---

which background process invoke at the time of upgradation tell me???

1 Answers   iGate,

---

How can you enable a trace for a session?

1 Answers  

---

How would you force a log switch?

4 Answers  

---

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

1 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1 Answers   Infosys,

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1 Answers  

---

what is the diffrence between core dba and apps dba?

1 Answers   Cap Gemini,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---