How many types of tables are there?



How many types of tables are there?..

Answer / Vartika Gupta

In SQL, there are two main types of tables: base tables (also known as normal tables) and index-organized tables. Base tables can store regular data using rows and columns while index-organized tables use the B-tree structure similar to that of an index.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is RAC in oracle?

7 Answers   MCN Solutions,


Explain the components of sql?

1 Answers  


Why is there a need for sqlcode and sqlerrm variables?

1 Answers  


how to check the 3rd max salary from an employee table?

23 Answers   IBM,


Does a user_objects view have an entry for a trigger?

1 Answers  


What is a record in pl/sql?

1 Answers  


what is try_catch block in procedure

1 Answers  


What is an emotional trigger?

1 Answers  


What are the advantages of the packages

6 Answers   Oracle,


how to enter binary numbers in sql statements? : Sql dba

1 Answers  


What is the non-clustered index in sql?

1 Answers  


How do you optimize a query?

1 Answers  


Categories