What are the database administrators utilities a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

207. What are the database administrators utilities available?

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

(Continued on next question...)

Other Job Interview Questions

• Differentiate simple and complex, snapshots?
• Can a field be used in a report without it appearing in any data group?
• What does ROLLBACK do?
• What are the Built-ins to display the user-named editor?
• What is Database Link?
• What are the different default triggers created when Master Deletes Property is set to Non-isolated?
• How can you determine if an index needs to be dropped and rebuilt?
• What is Mirrored on-line Redo Log?
• What are the two panes that Appear in the design time pl/SQL interpreter?
• Is it possible to modify an external query in a report which contains it?
• More...