How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
- 0 Answers
- 855 Views
- I also Faced
- E-Mail Answers
Why do we use trigger?
How to use group functions in the select clause in ms sql server?
Psudo colums
Explain the difference between cross join and full outer join?
What is db stored procedure?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Can you explain the disadvantages/limitation of the cursor?
How do you delete a data source?
What are the advantages of using cte?
What type of locking occurs during the snapshot generation? : sql server replication
Explain syntax for viewing, dropping and disabling triggers?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
