Bookmark

Forum | Directory | Blog |

Oracle DBA Interview Questions and Answers

» Oracle Database » Oracle DBA

Oracle DBA questions updated at 29 Jan 13 in Category Oracle and visited 69776 Times

Select Question To View Answers

	Download Oracle DBA Interview Questions And Answers PDF

Oracle DBA Questions and Answers:

1 :: When using Oracle export/import what character set concerns might come up? How do you handle them?

Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters. Also be wary of multi-byte characters sets as those may require extra attention. Also watch export/import for messages about any "character set conversions" which may occur.

Is This Answer Correct?

12 Yes

1 No

2 :: How do you use automatic PGA memory management with Oracle 9i and above?

Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET

Is This Answer Correct?

10 Yes

2 No

3 :: Explain two easy SQL optimizations.

a. EXISTS can be better than IN under various conditions
b. UNION ALL is faster than UNION (not sorting)

Is This Answer Correct?

7 Yes

1 No

4 :: Name three SQL operations that perform a SORT.

a. CREATE INDEX
b. DISTINCT
c. GROUP BY
d. ORDER BY
f. INTERSECT
g. MINUS
h. UNION
i. UNINDEXED TABLE JOIN

Is This Answer Correct?

5 Yes

2 No

5 :: What is your favorite tool for day-to-day Oracle operation?

Hopefully we hear some use of command line as the answer!

Is This Answer Correct?

7 Yes

0 No

Oracle DBA Interview Questions and Answers

« previous12 3 4 5 6 7 8 9 10 next »

Select appropriate Question to view its more answers in this category of Oracle DBA.

Do you find any Answer incorrect or incomplete? Please e-mail us or place your comment and mention the number of question or if you have correct answer then open the appropriate question by clicking on question and then place your answer in comment regarding particular question in this category "Oracle DBA Interview Questions and Answers" To ensure quality, each change is checked by our team, before it enters the main website database. If you desire so, the changes will be credited to your name.

Subscribe your email to receive free updates:

Enter your email address and get free web tutorials, job hunting tips, career advices, job vacancies and interview questions updates directly delivered to your email inbox

Hot Oracle DBA Frequently Asked Questions

►	When using Oracle export/import what character set concerns might come up? How do you handle them?

►	What is the difference between RMAN and a traditional hotbackup?

►	What is your favorite tool for day-to-day Oracle operation?

►	Name three SQL operations that perform a SORT.

►	How do you use automatic PGA memory management with Oracle 9i and above?

Hot Oracle DBA Frequently Asked Questions

Hot Interview Categories in Oracle

►	Oracle Database Frequently Asked Interview Questions and Answers

►	Oracle DBA Frequently Asked Interview Questions and Answers

►	Oracle PL-SQL Frequently Asked Interview Questions and Answers

►	Oracle GL Frequently Asked Interview Questions and Answers

►	Oracle ETL Frequently Asked Interview Questions and Answers

Comments (On Oracle DBA Interview Questions and Answers)

Your email is required but won't be published any where else. Personal information will be kept confidential; we do not sell or release private information.

Webmaster Said:

May 21 2013

Your comments will be instantly published after webmaster review. All visitors can submit their comments on Oracle DBA Interview Questions and Answers no registration is required to post your comments. You are welcome to share your ideas, experiences, suggestions questions and answers, but please be respectful of others when commenting. Insulting, self-promotional, website promotion, marketing, SEO Techniques, SMS-style and off-topic comments will not be published. Share your comments regarding Oracle DBA Interview Questions and Answers
Thank you.

Rate this Interview Question and Answer page by placing your comments here please...

SIVA Said:

Dec 25 2010

how can get dba job.please inform me

SIVA Said:

Dec 25 2010

I will take 3 years exp oracle dba.how can i prepare interview questions. please tell me

chowdary Said:

Feb 23 2011

hi i need resumes

Amarnath reddy K Said:

Mar 17 2011

Hi
I have 3 exp in oracle dba .Please send me some importent questions ans answers for preparing interviews .ple....

RAmesh Ranjan Said:

May 15 2011

Hi..
I have 3 years exp... i wanna model technical interview questions and answers... please send me some important questions and answers fro preparing interview...

ashim Said:

May 25 2011

Hi..
I have 3 years exp... i wanna model technical interview questions and answers... please send me some important questions and answers fro preparing interview...

Sachin Said:

Mar 27 2012

Hello friends, As per my recommendation, prepare Oracle DBA interview using following book by Gitesh Trivedi which published by Kendba.com. It is most useful because contains all tricky Oracle DBA interview questions answers with explanation about real time scenario based. It covers latest Oracle 11g.

Oracle Interview Questions Said:

Apr 11 2012

all the questions is very simple, better id we have some more tougher questions along with this.. hope this will help all the people who attend interview... thanks for the above questions and all answers, this site is very sportive and gives confidence in candidates who attends interview\'s

thanks

vijaykumarreddy Said:

Jan 10 2013

Hello everyone can you send to me 3 yrs exp resumes samples, interview questions for ORACLE DBA

sruti Said:

Feb 12 2013

Hello,
I didn\'t get any mail for download Gitesh Trvedi book .Resend me.

Pruthwiraj Samal Said:

Mar 25 2013

there are very tricky questions.

pravin kumar Said:

Apr 14 2013

hello Sir,
i need oracle core dba 3 yr RESUME......
plz send me ...AS SOON AS POSSIBLE.....

pravindba [at] outlook [dot] com
pravinmcabr [at] gmail [dot] com

send me plz....

Feel Free To Leave Your Comment

Enter Your Name: [Required]

Email Address: [Required] (will not be published)

Website: [Optional]

Enter Image Verification Code: [Must Required] Entering this code helps stop the bad guys.

Comments: [Required]

Limit: HTML Tags <center> are allowed
Subscribe for newsletter/Feeds?

In order to link this page as Reference, click on below text area and pres (CTRL-C) to copy the code in clipboard or pres right click then copy the following lines after that past into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)

HTML Rendering of above code:

[ Free Web Directory ] [ Global Web Forum ] [ Contact ] [ Links ] [ Site Map ] [ Statistics ] [ Services ] [ Privacy ]
Learn [ HTML ] [ XML ] [ JavaScript ] [ CSS ] [ SQL ]

Home

Subscribe for email:

Delivered by Feed Burner

Please Like our Facebook Page!

Please give us a +1 !