Oralce Interview Questions – Year 2009 Part – II

1. Give one method for transferring a table from one schema to another: There are several possible methods, export-import, CREATE TABLE… AS SELECT, or COPY
 
2. What is the purpose of the IMPORT option IGNORE? What is it?s default setting The IMPORT IGNORE option tells import to ignore “already exists” errors. If it is not specified [...]

Read Full Post »

Oracle Interview Questions – Year 2009 – Part I

1. Explain the difference between a hot backup and a cold backup and the benefits associated with each.
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it [...]

Read Full Post »

Oracle Databse Questions and Answers

What is Log Switch? – The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
What is On-line Redo Log? – The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the [...]

Read Full Post »