Answer / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

Explain materialized views and how they are used.

0 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

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

0 Answers  

---