What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answers were Sorted based on User's Feedback
Answer / rajkumar
please don't give oracle answers in sqlserver
Is This Answer Correct ? | 12 Yes | 8 No |
Answer / leena
clustered index physically store data orderly in a
table,but non-clustered index store data logically not
physically.
primary key is by default clustered index,and unique key is
by default non-clustered index.
A table can contain only one cluster index.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amit
A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.
and as many as indexes can be created on table but it will
reduces the performance of the database.
Is This Answer Correct ? | 1 Yes | 10 No |
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
What is t-sql? : Transact sql
Give which cursor is better for better performance means type of cursors?
Is sqlexception checked or unchecked?
Explain foreign key in sql?
Does asenumerable execute the query?
What is program debugging?
What is rollback?
How do I view a procedure in sql?
Which nosql database is best?
Explain how can you save or place your msg in a table?