[JobsAssist] Top 50 DBA Interview Questions & Answers

 

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

__._,_.___

---

Posted by: Pooja <dial2pooja@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Your New Favourite Group is Waiting for You!

If you enjoy this group, we have suggestions for others you might like to join.

---

Yahoo Groups

Control your view and sort preferences per Yahoo Group

You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.

---

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FREE JOB RESOURCES
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

http://www.vyoms.com/

EMPLOYERS SEARCH FROM OVER LAKHS OF FRESH QUALITY RESUMES FOR FREE
http://www.vyoms.com/employers/

Get Thousands Of Relevant Fresher Jobs FREE OF COST
http://www.vyoms.com/jobs/job-types/details/freshers-jobs-1.asp

Get Thousands Of Relevant Experienced Jobs FREE OF COST
http://www.vyoms.com/jobs/job-types/details/experienced-jobs-2.asp

Get Thousands Of Relevant Walk-Ins FREE OF COST
http://www.vyoms.com/jobs/job-types/details/walk-ins-4.asp

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___