Answer / mathan r

It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

How do you drop an index?

0 Answers  

---

What is a derived table?

0 Answers  

---

What is failover clustering overview?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

Explain important index characteristics?

0 Answers  

---