Answer Posted / selvaraj.v

SQL Server 2000 BackUp Database,
Query:
------
backup database selvaa to disk = 'c:\selvaa.bak'

Answer:
-------
Processed 160 pages for database 'selvaa',
file 'selvaa_Data' on file 1.
Processed 1 pages for database 'selvaa', file 'selvaa_Log'
on file 1.
BACKUP DATABASE successfully processed 161 pages in 0.151
seconds (8.687 MB/sec).

Difference between DELETE and TRUNCATE?

1093

---

Explain data warehousing in sql server?

1085

---

How can I know what locks are running on which resource?

992

---

Can you pass expressions to function parameters?

1149

---

Explain the use of containers in ssis?

1011

---

What are Spatial data types in SQL Server 2008

1065

---

Mention the different authentication modes in sql server.

1099

---

what are candidate key, alternate key and composite key? : Sql server database administration

959

---

What is the language structure to add a record to a table?

1073

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1055

---

Explain four layers of abstraction microsoft architectured?

147

---

What are entities and relationships?

1020

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1042

---

What is the command used to recompile the stored procedure at run time?

1117

---

What is the difference between dropping a database and taking a database offline?

1216

---