Home » Other » Training & Certification » enable UNDO feature (oracle 10g)
enable UNDO feature [message #420336] Fri, 28 August 2009 07:24 Go to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
If u want to create your database with the Automatic Undo Management feature enabled which 2 tasks u perform to acheive this ?

a)set UNDO_RETENTION to AUTO

b)create an initial undo segment in undo tablespace

c)set UNDO_RETENTION TO 900 or more

d)set the parameter UNDO_MANAGEMENT to AUTO

e)set the UNDO_MANAGEMENT parameter to name of an undo tablespace

Answers :C,E

But i think C,D is the answer.what do u say ?

plese reply .....



Re: enable UNDO feature [message #420346 is a reply to message #420336] Fri, 28 August 2009 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On what do you base your opinion?

Regards
Michel
Re: enable UNDO feature [message #420347 is a reply to message #420346] Fri, 28 August 2009 08:30 Go to previous messageGo to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
Hi,

UNDO_MANAGEMENT can be either AUTO/MANUAL but can't be the name of a undo_tablespace.

That's the region i say C,D as answers.

Please post the correct answers.
Re: enable UNDO feature [message #420352 is a reply to message #420347] Fri, 28 August 2009 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why C?

Regards
Michel
Re: enable UNDO feature [message #420373 is a reply to message #420352] Fri, 28 August 2009 12:27 Go to previous messageGo to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
please post the answer ....
Re: enable UNDO feature [message #420374 is a reply to message #420373] Fri, 28 August 2009 12:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please answer.

Regards
Michel
Previous Topic: Embedded Systems Training
Next Topic: OCA
Goto Forum:
  


Current Time: Thu Mar 28 04:12:48 CDT 2024