What is database partitioning?
Partitioning divides a large table into smaller, more manageable pieces.
Types of partitioning:
• Range Partitioning – Divides data based on a range of values.
• List Partitioning – Divides data based on a predefined list of values.
• Hash Partitioning – Distributes data based on a hash function.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a key field?
What are the characteristics of database?
what are the different kinds of indexing?
Explain the scenarios or situations under which progress database creates new index entry for a record?
How is data stored in a database?
If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains
What is type of end users?
What is use of foreign key?
What is a Data Warehouse and How is it Different from a Traditional Database?
Which dbms is best?
What is 3 level architecture dbms?
What is the full form of rdbms?
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)