Answer Posted / 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 are the essential components of sql server service broker?

963

---

When is update_statistics command used?

994

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

933

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

973

---

Explain log shipping and mention its advantages.

988

---

List the various tools available for performance tuning?

842

---

What are the database objects? : SQL Server Architecture

981

---

What is table join?

1064

---

What is compression - row-level and page-level compression?

862

---

How do I edit a procedure in sql server?

897

---

What is the name of the Database which IBM mainframe uses?

945

---

Explain raiserror in sql server?

961

---

How do I view views in sql server?

935

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

980

---

How can you list all the columns in a database?

885

---