Answer / santo

DDL statements will be recorded in Alert log files?

Answer / monal

IN SQL 2005:

YOU CAN CREATE DDL TRIGGER TO TRACK CHANGES MADE WITH DDL
STATEMENTS.

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

7 Answers   TCS,

---

what is the use of ocr?

0 Answers   Oracle,

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

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.

0 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---