Answer / ashok

1.If we create a table it will save in database but a view is a virtual image there is no physical existance.
2. We can use order by clause in tables but views does not support order by clause.
3.In a view we can specify only a select statement inside a view but in tables we use all dml,ddl statements.
4.If we updating a base table using view which contains joins may not update correctly,but in tables we can update using joins.

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1 Answers  

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1 Answers  

---

where the connection string store in the database

1 Answers   HCL, Wipro,

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1 Answers  

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

What is order of B+tree?

1 Answers   HCL,

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

What do you mean by cardinality?

1 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1 Answers   TCS,

---

Explain the truncate command?

1 Answers  

---