Answer Posted / rajendra

Cold Backup and Hot Backup terms are used by Oracle. These
terms are not available In MS SQL Server.

Cold Backup: - Takes the Database offline and copy database
files to different loction is called cold backup in Oracle.

Hot Backup:- Taking the Database backup when the Database
is online.

How to create an multi-statement table-valued function?

942

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1036

---

List out some of the requirements to set up a sql server failover cluster?

981

---

What happens if null values are involved in bitwise operations?

967

---

What do you understand by recursive stored procedure?

875

---

How to use group functions in the select clause in ms sql server?

996

---

Explain few examples of stored procedure over triggers?

964

---

When we should use @@error?

914

---

what are the different ways to return the rowcount of a table?

945

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

---

How to how to convert numeric expression data types using the convert() function??

991

---

What is the exact numeric data type in sql?

962

---

What are the new features of sql server 2012 reporting service?

123

---

Can sql servers linked to other servers?

976

---

Tell me what are the essential components of sql server service broker?

887

---