Answer / amrish kumar

The DELETE command is used to remove rows from a table. A
WHERE clause can be used to only remove some rows. If no
WHERE condition is specified, all rows will be removed.
After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change
permanent or to undo it.

TRUNCATE removes all rows from a table. The operation cannot
be rolled back. As such, TRUCATE is faster and doesn't use
as much undo space as a DELETE.



DROP and TRUNCATE are DDL commands, whereas DELETE is a DML
command. Therefore DELETE operations can be rolled back
(undone), while DROP and TRUNCATE operations cannot be
rolled back.


Table is a basic unit of data storage in an oracle database.
It holds all user accessible data.

View is a virtual table
- It can be created on a table or another view.
- It is just like a window through which we can access or
change base table data.
- It does contain data of its own. It always takes data from
its base table.
- It is stored as a query in data dictionary.Whenever you
query a view it gets data from its based table using this query.

Constraints are great at maintaining database integrity for
database fields and relationships between database tables.

Triggers are great for checking past vs. current values and
making decisions based on that data.

What is sql server profiler?

0 Answers  

---

What is an example of a foreign key?

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

Can we write trigger for view?

0 Answers  

---

Why do we use non clustered index?

0 Answers  

---

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  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---