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 |
Define union all operator and union.
What is the maximum size of the page ?
What are different types of joins in sql?
What is tuple with example?
Enlist the advantages of dbms.
Can we update table which is created from view?
2 Answers IBM, Punjab National Bank,
What is authorization and integrity manager?
The use of LAST_VALUE() AND FIRST_VALUE() with an example
What are the objectives of rdbms?
Why would someone use a database?
what is scan listener.
How do you delete a table from database?
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)