One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #1948

Latest 50 DBA Interview Questions & Answers by "R .Ronak" a.maheshi

Message

1 Latest 50 DBA Interview Questions & Answers

Tue Jul 1, 2014 8:40 pm (PDT) . Posted by:

"R .Ronak" 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 causes the "snapshot too old" error? How can this be prevented or mitigated?
http://www.coolinterview.com/interview/28075/

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

* 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/

* What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?
http://www.coolinterview.com/interview/27929/

* What does a Control file Contain?
http://www.coolinterview.com/interview/26028/

* If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?
http://www.coolinterview.com/interview/28053/

* Describe what redo logs are.
http://www.coolinterview.com/interview/26038/

* What is the use of ANALYZE command?
http://www.coolinterview.com/interview/26070/

* How would you go about generating an EXPLAIN plan?
http://www.coolinterview.com/interview/26004/

* Do you consider yourself a development DBA or a production DBA and why?
http://www.coolinterview.com/interview/27931/

* You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
http://www.coolinterview.com/interview/28048/

* What is difference between open_form and call_form?
http://www.coolinterview.com/interview/26130/

* Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
http://www.coolinterview.com/interview/26010/

* When should more than one DB writer process be used? How many should be used?
http://www.coolinterview.com/interview/28071/

* What is a database schema?
http://www.coolinterview.com/interview/26047/

* What are the vbx controls?
http://www.coolinterview.com/interview/26133/

* What are the built-ins that are used for setting the LOV properties at runtime?
http://www.coolinterview.com/interview/28003/

* What does coalescing a tablespace do?
http://www.coolinterview.com/interview/26041/

* Give the two types of tables involved in producing a star schema and the type of data they hold?
http://www.coolinterview.com/interview/25981/

* What are the different windows events activated at runtimes?
http://www.coolinterview.com/interview/26125/

* Use the add_group_column function to add a column to record group that was created at a design time?
http://www.coolinterview.com/interview/27990/

* Explain the use of table functions.
http://www.coolinterview.com/interview/26024/

* What DBA activities did you to do today?
http://www.coolinterview.com/interview/25950/

* Compare and contrast TRUNCATE and DELETE for a table.
http://www.coolinterview.com/interview/25979/

* What is an object group?
http://www.coolinterview.com/interview/27950/

* What are the built-ins used for Creating and deleting groups?
http://www.coolinterview.com/interview/27981/

* Give the sequence of execution of the various report triggers?
http://www.coolinterview.com/interview/27969/

* What is the advantage of the library?
http://www.coolinterview.com/interview/28006/

* Do View contain Data?
http://www.coolinterview.com/interview/27944/

* What is lexical reference?

http://www.coolinterview.com/interview/28007/

* What are the two phases of block coordination?
http://www.coolinterview.com/interview/46499/

* Give two methods you could use to determine what DDL changes have been made.
http://www.coolinterview.com/interview/46510/

* When do you use data parameter type?
http://www.coolinterview.com/interview/26128/