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 |
How is sql server used?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the difference between getdate and sysdatetime?
Explain the benefits of user-defined functions?
What is difference between Datepart() and Datename() in SqlServer?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is SQL Profiler and the use of it?
What is the process of normalising?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Define full outer join in sql server joins?
Define candidate key, alternate key, and composite key.
What is merge statement?
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)