Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11739 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What are data types in pl sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is a scalar value in sql?
What is the syntax to add a record to a table?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Why stored procedures are faster than query?
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
Is sql better than access?
what is the main difference between join and subqurey?
Does inner join remove duplicates?
what are the authentication modes in sql server? : Sql dba
Can you skip header records while loading? : aql loader
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
