English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 9i: New Features For Administrators 

АвторSubject: Q54
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Before the issuing the dbms_redefinition_start_redef table procedure call it’s recommended to invoke the dbms_redefinition.can_redef_table procedure and create an empty interim table with all the desired characteristics. Dbms_redefinition_start_redef procedure verifies that the table can be redefined online.
Incorrect Answers:
1: You don’t need to grant privileges on the interim table.
3: It is recommended to periodically synchronize the interim table with the source one when a large amount of DML is executed on the table while the re-organization is taking place by calling the dbms_redefinition.sync_interim_table() procedure. But this step is not required.
4: You don’t need to create any triggers, indexes, or constraints on the interim table.
Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 78-80
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 46-53
Chapter 2: Oracle9i Architecture Changes

Current tread:
back to list

Q54 - Go to question 10:10 19.01.08

back to list
Up ^ gen. 0.087 Server date 11:17 09-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments