Oracle DBA Interview Questions and Answers

All Categories >> Oracle >> Oracle DBA >> ▼

Oracle DBA Interview Questions and Answers will guide us now that the Oracle Database commonly referred to as Oracle RDBMS or simply Oracle is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. As of 2009, Oracle remains a major presence in database computing. So get preparation of Oracle DBA Jobs with this Oracle DBA Interview Questions with Answers guide

  1. Oracle DBA questions updated at 01 Jul 10 in Category Oracle and visited 1975 Times

Oracle DBA Questions and Answers:

1 :: Explain FORCE LOGGING feature in 9i.

By setting FORCE LOGGING to TRUE, all transactions will generate REDO. This is used for Data Guard, so no data will be missed (i.e. transactions that were run with NOLOGGING option) in Standby database
0/5 Rating (0 vote)
Is This Answer Correct?    2 Yes 0 No
Place Your Answer

2 :: How can you tell if an index on particular table is USED or NOT USED in 9i?

By turning MONITORING ON that index and querying into INDEX_USAGE table
4/5 Rating (1 vote)
Is This Answer Correct?    2 Yes 0 No
Place Your Answer

3 :: How do you put database is ARCHIVELOG mode, explain procedure?

1. Modify init.ora parameter START_ARCHIVE=TRUE
2. SQL> SHUTDOWN IMMEDIATE;
3. STARTUP MOUNT;
4. ALTER DATAVASE ARCHIVELOG;
5. ALTER DATABASE OPEN;
4/5 Rating (1 vote)
Is This Answer Correct?    2 Yes 2 No
Place Your Answer

5 :: Explain procedure to Change CHARACTERSET of a database.

Can't change CHARACTERSET of a database, you will need to re-create the database with
appropriate CHARACTERSET.
0/5 Rating (0 vote)
Is This Answer Correct?    1 Yes 1 No
Place Your Answer

Rate This Category:
4/5 Rating (1 vote)
 Place Your Question



Top: Oracle DBA Interview Questions and Answers
Oracle DBA Interview Questions and Answers

Top Frequently Asked Oracle DBA Question
Frequently Asked Oracle DBA Job Interview Question


Top Frequently opened Oracle Job Interview categories
Most popular Oracle Job Interview categories

Comments About Oracle DBA Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about Oracle DBA Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 22nd of May 2012

    Webmaster Said

    Tell us what you feel about Oracle DBA Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on Oracle DBA Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding Oracle DBA Interview Questions and Answers
    Thank you.

    Reply

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: Oracle DBA Interview Questions and Answers
Comments on Oracle DBA Interview Questions and Answers

 
Top of Link batk to Oracle DBA Interview Questions and Answers
Link batk to Oracle DBA Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »