Explain what partitioning is and what its benefit is.
- 2 Answers
- 6737 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 3 Yes | 0 No |
And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability
2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations
| Is This Answer Correct ? | 2 Yes | 0 No |
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different ways you can create databases in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
What are the different sql server versions you have worked on? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
by issuing "alter tablespace begin backup;" what happens to tablespace?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
