Answer / Anurag Chaudhary

In SAS programming, 'where' is used for filtering data based on conditions, while 'if' is used for conditional execution of statements. Where performs a selection operation and returns a new dataset with only the selected observations. If checks whether a condition is true or false and executes different code blocks accordingly.

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

Oracle 11g new features?

2 Answers  

---

What is replication? : sql server DBA

1 Answers  

---

How do you resize a data file?

2 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 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.

1 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

1 Answers  

---

internal architecture

1 Answers   CSC,

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1 Answers  

---