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

What is a virtual table in sql?

996

---

Explain system views?

1086

---

How to modify the underlying query of an existing view?

989

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

991

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1052

---

Tell me the phases a transaction has to undergo?

962

---

Can I delete event logs?

924

---

How do I get to sql server configuration manager?

1009

---

What are the different authentication modes in sql server? How can it be changed?

1089

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1029

---

What is the difference between left and right outer join?

1060

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1083

---

What are the purpose of Normalisation?

1050

---

How do I find the size of a sql server database?

928

---

Tell me what is difference between clustered and non clustered index?

944

---