Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-497 Topic 3 Question 86 Discussion

Actual exam question for Oracle's 1Z0-497 exam
Question #: 86
Topic #: 3
[All 1Z0-497 Questions]

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

Show Suggested Answer Hide Answer
Suggested Answer: F

http://docs.oracle.com/cd/E16655_01/server.121/e17633/datadict.htm#CNCPT1213 (overview of dynamic performance views)

Contribute your Thoughts:

Casie
1 months ago
Ah, the age-old question: which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility? It's like asking which came first, the chicken or the egg. The answer is always 42.
upvoted 0 times
...
Lashandra
1 months ago
Wait, there's a DBNEWID utility? I thought we just used a magic wand and a few mumbled incantations to change the database name. Looks like I've been doing it wrong all this time!
upvoted 0 times
Kirk
18 days ago
A) db_name
upvoted 0 times
...
...
Audria
2 months ago
D) instance_name is the correct answer. The control file and DBNEWID utility are used to change the database identifier, not the instance name. Easy peasy!
upvoted 0 times
Latrice
4 days ago
D) instance_name
upvoted 0 times
...
Reita
7 days ago
C) control_files
upvoted 0 times
...
Raul
19 days ago
B) maxdatafiles
upvoted 0 times
...
Ma
1 months ago
A) db_name
upvoted 0 times
...
...
Gladys
2 months ago
A) db_name seems like the obvious choice here. Why else would we have the DBNEWID utility if it couldn't change the database name?
upvoted 0 times
...
Mariann
2 months ago
Hmm, I'm not sure about this one. It's tricky to know which parameter can be changed by both methods. I'll have to think this through carefully.
upvoted 0 times
Carin
12 days ago
Let me double check, I think it's instance_name.
upvoted 0 times
...
Lavonda
29 days ago
I believe it's db_name that can be changed using both methods.
upvoted 0 times
...
Vanesa
1 months ago
I think it might be control_files.
upvoted 0 times
...
...
Floyd
2 months ago
I think the answer is D) instance_name. The control file and DBNEWID utility are used to change the database identifier, not the instance name.
upvoted 0 times
Ashlee
19 days ago
D) instance_name
upvoted 0 times
...
Nelida
28 days ago
C) control_files
upvoted 0 times
...
Matthew
1 months ago
B) maxdatafiles
upvoted 0 times
...
Chana
2 months ago
A) db_name
upvoted 0 times
...
...
Margot
2 months ago
I agree with Gwen, control_files is the parameter that can be changed in this scenario.
upvoted 0 times
...
Gwen
2 months ago
I believe it's control_files that can be changed by explicitly re-creating the control file or using DBNEWID utility.
upvoted 0 times
...
Caitlin
3 months ago
I think the parameter that can be changed is db_name.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77