create index a on employee(dno)
In this,which index was created?
Answers were Sorted based on User's Feedback
Answer / yousaf khan
First the Control will check if there clustred index exist
if there then it will create a nonclustred Index a on
Employee(dno), other case there is condition diffine like
clustred or nonclustred so it create Defualt type.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to see existing views in ms sql server?
What number aggregate functions are accessible there in sql?
What is the importance of a recovery model?
how to rename the table
How to get nth highest salary from employee table.
what is bit datatype? : Sql server database administration
Where the sql logs gets stored? : sql server database administration
can we call functions from stored procedure in SQL Server 2005 ? How?
What is triggers and its types?
How will you know when statistics on a table are obsolete?
What is the sql case statement used for? Explain with an example?
What is the server name for sql management studio?
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)