adspace


How many types of tables are there?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is inner join faster than left join?

1286


How do I remove duplicates in two columns?

1201


Is primary key always clustered index?

1101


how many tables will create when we create table, what are they? : Sql dba

1153


how to use regular expression in pattern match conditions? : Sql dba

1122


how to escape special characters in sql statements? : Sql dba

1124


what are the advantages of sql ? : Sql dba

1151


what is sql server agent? : Sql dba

1188


Can we rollback truncate?

1082


what is schema? : Sql dba

1160


what is collation? : Sql dba

1239


how to start mysql server? : Sql dba

1278


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099


What is the current version of postgresql?

1187


Is primary key clustered index?

1025