What are the two types of periodical indexes?



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:
1. Fast Full Index Rebuild: Rebuilds an index quickly but can lock the table during the operation.
2. 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

Post New Answer

More SQL PLSQL Interview Questions

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,


Which software is used for pl sql programming?

1 Answers  


what is Complex index. how to create it?

2 Answers  


Is sql port 1433 encrypted?

1 Answers  


What is meant by temporal data?

1 Answers  


What are the indexing methods?

1 Answers  


What is the best free sql database?

1 Answers  


How many functions are there in sql?

1 Answers  


What is the primary key?

1 Answers  


What Is a Trigger? How Do You Use It?

3 Answers  


What are the types of sql commands?

1 Answers  


What is a call statement? Explain with an example.

1 Answers  


Categories