Answer Posted / 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

How to provide values to user defined function parameters?

970

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

906

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

936

---

What is msdb database? : SQL Server Architecture

1062

---

How to list all triggers in the database with sys.triggers in ms sql server?

1016

---

What is model database in sql server?

1004

---

What does REVERT do in SQL Server 2005?

919

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

853

---

How to find table changes in sql server?

1053

---

what is a self join? Explain it with an example? : Sql server database administration

885

---

How is SQL Azure different than SQL server?

223

---

What do you mean by normalisation?

965

---

Can we create clustered index on composite key?

982

---

What is an example of a foreign key?

930

---

What is a raid and what are different types of raid configurations?

1206

---