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 |
What's the difference between a primary key and a unique key?
Can we store videos inside the sql server table?
How do I find the size of a sql server database?
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
What do you understand by a view? What does the with check option clause for a view do?
what's the maximum size of a row? : Sql server database administration
Explain how to send email from sql database?
What is the difference between varchar and varchar(max) datatypes?
What is the difference between Stored Procedures and triggers?
What is a cube? : sql server analysis services, ssas
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the difference between a stored procedure and a user defined function in sql server?
Oracle (3253)
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)