Answer / Arun Dwivedi

An index is a database object that improves the speed of data retrieval operations on a table by organizing the data in such a way that it can be found more quickly. The index contains keys that reference the location of the rows where the specific data resides, allowing SQL Server to avoid scanning every row in a table during a search.

What is clr ddl trigger?

1 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

What is a self join in sql server?

1 Answers  

---

Do you know what are acid properties?

1 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How to insert stored procedure result into temporary table?

1 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1 Answers  

---

how to determine the service pack currently installed on sql server? : Sql server database administration

1 Answers  

---

How to create new databases with "create database" statements?

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1 Answers  

---

What is collation sensitivity? Explain different types.

1 Answers  

---