Answered Questions
Asked By: shanthiavari
| Asked On: Jul 18th, 2008
Should you take the backup of logfiles if the database is running in archivelog mode?
Asked By: shanthiavari
| Asked On: Jul 18th, 2008
Can you take online backup of a control file if yes, how? Explain about logical backup?
Answered by: bapiora on: Jun 29th, 2009
During database online you perform logical online backup for control file. ALTER DATABASE CONTROLFILE TO TRACE Through this command you perform control file trace backup which is logical.
Answered by: impalor on: Dec 9th, 2008
You could use alter database backup controlfile for a binary copy of control file.
Asked By: Interview Candidate
| Asked On: Jun 1st, 2005
Answered by: SHIMAR on: Apr 16th, 2012
DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop
Answered by: Venki on: Dec 19th, 2011
DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
Yes We can Take of Controlfile Online Mode Just
Fire The Command alter database backup controlfile trace And
alter database backup controlfile as trace '/Location where u want 2 take backup of ctlfile/';
No, we can not take backup of redo log files even database is running in archive log mode because of inconsistency