One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #2028

Top DBA Interview Questions & Answers by "Meghana" a.maheshi

Message

1 Top DBA Interview Questions & Answers

Wed Mar 25, 2015 8:58 pm (PDT) . Posted by:

"Meghana" a.maheshi

|
|
| DBA INTERVIEW QUESTIONS |
|

| | Download Free Interview Questions eBook of 500 Questions

(If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolInterview-Subscribe@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.) |

|
| DBA Interview Questions |
|
- You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
http://www.coolinterview.com/interview/28073/

- What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
http://www.coolinterview.com/interview/28068/

- A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
http://www.coolinterview.com/interview/25986/

- How can you tell if a database object is invalid?
http://www.coolinterview.com/interview/28077/

- How can you find out how many users are currently logged into the database? How can you find their operating system id?
http://www.coolinterview.com/interview/28084/

- What is the proper method for disabling and re-enabling a primary key constraint?
http://www.coolinterview.com/interview/28065/

- What causes the "snapshot too old" error? How can this be prevented or mitigated?
http://www.coolinterview.com/interview/28075/

- Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
http://www.coolinterview.com/interview/26020/

- How can you determine if an index needs to be dropped and rebuilt?
http://www.coolinterview.com/interview/28089/

- What happens if the constraint name is left out of a constraint clause?
http://www.coolinterview.com/interview/28059/

- What is WHEN-Database-record trigger?
http://www.coolinterview.com/interview/27996/

- What is the purpose of the IMPORT option IGNORE? What is it's default setting?
http://www.coolinterview.com/interview/28045/

- A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
http://www.coolinterview.com/interview/28078/

- What happens if a tablespace clause is left off of a primary key constraint clause?
http://www.coolinterview.com/interview/28063/

- Give one method for transferring a table from one schema to another?
http://www.coolinterview.com/interview/28041/

- What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
http://www.coolinterview.com/interview/26045/

- What are the trigger associated with image items?
http://www.coolinterview.com/interview/26122/

- What use of command line parameter cmd file?
http://www.coolinterview.com/interview/28005/

- What are some of the Oracle provided packages that DBAs should be aware of?
http://www.coolinterview.com/interview/28055/

- Explain materialized views and how they are used?
http://www.coolinterview.com/interview/26026/

|

|

|