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 is the command used to recompile the stored procedure at run time?

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

---

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

What is lock escalation and what is its purpose?

0 Answers  

---

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---