CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS ORACLE DETAILS
Question :
What is the best method to rename a control file?
Category Oracle Interview Questions
Rating (0.0) By 0 users
Added on 7/7/2005
Views 761
Rate it!
Answers:

a. Use the ALTER DATABASE RENAME FILE command.
b. Shut down the database, rename the control file by using an OS command, and restart the database after changing the CONTROL_FILES parameter.
c. Put the database in RESTRICTED mode and issue the ALTER DATABASE RENAME FILE command.
d. Shut down the database, change the CONTROL_FILES parameter, and start up the database.
e. Re-create the control file using the new name.





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?
View Answer
Which clauses in the CREATE DATABASE command specify limits for the database?
View Answer
Which clauses in the CREATE DATABASE command specify limits for the database?
View Answer
What is the prefix for dynamic performance views?
View Answer
Which data dictionary view provides information on the version of the database and installed components?
View Answer
What is the default password for the SYS user?
View Answer
Who owns the data dictionary?
View Answer
How many data files can be specified in the DATAFILE clause when creating a database?
View Answer
Which event trigger from the following cannot be created at the database level?
View Answer
How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL Oracle Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/4673/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.64