Answer Posted / seema

Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk

Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

976

---

What Is Rdbms?

1082

---

Explain the relational database management system (rdbms)?

1018

---

How do you create an execution plan?

885

---

how to invoke a trigger on demand? : Sql server database administration

1000

---

Does a server store data?

864

---

Can the query output be sorted by multiple columns in ms sql server?

935

---

What command do we use to rename a db, a table and a column?

873

---

What happens if date-only values are provided as date and time literals?

975

---

What will be query used to get the list of triggers in a database?

953

---

How to get all stored procedures in sql server?

936

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2262

---

What is Lock table in SQL?

1410

---

Differentiate between a local and a global temporary table?

897

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1901

---