Oracle Apps DBAs - How would you check if the

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

(Continued from previous question...)

Oracle Apps DBAs - How would you check if the tablespace is in backup mode ?

- Check in v$backup
SQL> SELECT d.tablespace_name, b.status FROM dba_data_files d, v$backup b WHERE d.file_id = b.FILE# and b.STATUS = ‘ACTIVE’ ;

(Continued on next question...)

Other Job Interview Questions

• How do you troubleshoot problems in your current role?
• Oracle Apps DBAs - When Database is up, listener is up. listener.ora and tnsnames.ora both are configured properly, still client is not being able to make a connection to the database. What may be the possible issues ?
• What frustrated you most at your previous job?
• Why do You Want to be a DBA?
• How do you troubleshoot problems in your current role?
• Oracle Apps DBAs - How would you know that your applications setup is a using shared APPL_TOP configuration ?
• What is the most important job function for a database administrator?
• How do you troubleshoot problems in your current role?
• SQL Server - Explain why DBAs don’t like cursors.
• Oracle Apps DBAs - How to create staging area
• More...