Should you take the backup of logfiles if the database is running in archivelog mode?
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
Logical online backup
Can you take online backup of a control file if yes, how? Explain about logical backup?
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.
You could use alter database backup controlfile for a binary copy of control file.
What is DDL, dml?
DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop
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.
What is your way of building rapport with a person you just met?
Do you like working in a team or alone? Explain.
Have you gone above and beyond your job description?
What was the most important decision you ever had to make?
Provide an example of a goal that you successfully attained.
Tell me three things about you, which are not found in your resume
Describe a time when you had to listen to someone.
What do you do when someone criticizes you?
How do you approach a problem?
What is the role of a mechanical engineer in the Software Industry?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.