Answer / hari krishna

A segment is a part of relational data base and consists of
one or more extents. Each extent is further divided into
blocks. Every segment has an index for holding all of its
data for quick data retrieval. Index segments can be created
explicitly by using the CREATE INDEX command. Storage
parameters for the extents of the index segment can be
specified along with this command.

How do you create a clustered index?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

How do I run sql server 2014?

0 Answers  

---

Explain error handling in ssis?

0 Answers  

---

What is a field in a table?

0 Answers  

---

---

What stored procedure can you use to display the current processes?

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

What is the most common type of join?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is forward - only cursors / read only cursor?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---