Answer / koti khammam

Doing a certain job with in a scheduled time is known as a
task.

Answer / b

Doing a cerain job with in a scheduled time. Sample tasks
in sql server are import data, export data, backup, restore
etc..

Answer / surya

Tasks are used in DTS packages to perform the specific
operation like
1. ActiveX Script Task
2. Transform Data task
etc.

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

What is data modification?

0 Answers  

---

Explain database normalization?

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

what is maximum size of temp db?

4 Answers   iSoft,

---

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,

---

What does the INSTEAD OF trigger do?

3 Answers  

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---