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.

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What does top operator do?

0 Answers  

---