What is Online Index Rebuild Operation?
Answer / saravakumar
Online operation means when online operations are happening
the database are in normal operational condition, the
processes which are participating in online operations does
not require exclusive access to database.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the concept of optimization?
How many types of Cursor in SQL SERVER?
List the data types available in mssql?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Do you know what is replace and stuff function in sql server?
Explain Geography datatype in SQL Server
List out different types of normalizations in sql server and explain each of them?
define and explain the differences between clustered and non-clustered indexes.
What are “lock” hints?
Explain optimistic and pessimistic concurrency?
When would you use it?
What is sql sandbox in sql server?
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)