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
Backup and Recovery 

АвторSubject: Q52
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
To reduce redo logs generating a DBA would load a table during a direct loaded operation using the NOLOGGING options. Specifying the NOLOGGING clause means that the creation of the table or index, as well data loaded into the table or index, will not generate any redo information. This enhances performance of data load or object creation operations, but leaves you with dilemma later if the database fails and you haven't taken a backup. Even if you archive your redo logs, you still will not be able to recover data, because no redo was generated for operations related to that object. Use NOLOGGING very sparingly, and only with table data load or index creation operations when you plan to take a backup very soon anyway.
Incorrect Answers:
1: Using the NOLOGGING option does not eliminate further backup, quite the contrary it requires DBA to take backup as soon as possible after load operations completion.
2: This option disable temporarily redo log generation, not collecting statistics.
4: The NOLOGGING option has nothing to do with the least recently-used end of the buffer cache.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 590-591
Chapter 12: Overview of Backup and Recovery

Current tread:
back to list

Q52 - Go to question 10:10 19.01.08

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