What are the two types of periodical indexes?
Answer / Amit Kumar Tamrakar
"The two types of periodical indexes (also known as scheduled indexes) in SQL/PLSQL are:n1. Fast Full Index Rebuild: Rebuilds an index quickly but can lock the table during the operation.n2. Slow Full Index Rebuild: Rebuilds an index slowly but does not lock the table, allowing concurrent DML operations."
| Is This Answer Correct ? | 0 Yes | 0 No |
how are rank and dense rank being alloted for column with same values over a particular column
What are the types of functions in sql?
What is the requirement of self-join?
What is blind sql injection?
Which table is left in left join?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is the difference between a database and a relational database?
what is the difference between join and union? : Sql dba
What is data definition language?
How do I start pl sql?
What are the query optimization techniques?
How do I truncate a sql log file?
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)