Friday , July 21 2017
Home / Oracle DBA Interview Questions / ORACLE MISCELLANEOUS INTERVIEW QUESTIONS

ORACLE MISCELLANEOUS INTERVIEW QUESTIONS

MISCELLANEOUS

  1. What are your daily activities?
    1. Checking the alertlog file, backup status, performing any refreshes, resolving tickets and handling application team requests etc
  2. What is your typical day? Or What is the biggest problem you faced till now?
    1. Explain any one problem you faced during practise or any error you observed
  1. Why should we hire you?
    1. With my experience and knowledge, i can deliver some optimized solutions to the client where it would benefit client and company as well to get much more projects
  1. Are you a nuts-n-bolts DBA or tools-n-props DBA?
    1. Nuts-n-bolts DBA means who uses command line interface and tools-n-props means who is fine with GUI’s like EM etc. So tell the answer as both
  1. Which other teams you will interact daily?
    1. Unix team, application team and incident management team mostly
  1. What is the difference between hard link and soft link?
    1. Hard link carries same permissions and size as original file where as soft link doesn’t
  1. How to perform RMAN cloning? Brief the steps
    1. Explain the steps and mentioned in the document
  1. We are getting “recovery successful but database cannot be opened with resetlogs” error. Why this will occur and what could be the solution?
    1. It will occur during HOT backup cloning. During this, we need to either generate an archive in source database and apply it on target or can provide the path of redolog file
  1. You have installed oracle and creating a database manually. Its been a hour, still script is executing. What is the first thing you will check here?
    1. We need to check if archive destination is full
  1. How to find dead process?
    1. Using top command. Here we need to look for zombie processes
  1. You used a query with order by asc clause and that column contains NULL values. Will they appear on top or bottom?
    1. bottom
  2. Can we have multiplexing for datafiles?if so, how?
    1. Not directly. But we can achieve similar using ASM or RAID levels which provides striping and mirroring
  1. What is the difference between truncate and delete?
    1. Delete can be rolled back where as truncate cannot
  1. What is normalization? How it is related to E.F.Codd rules?
    1. It is the process of applying rules on tables to achieve consistency and to avoid/reduce redundancy
  1. Explain the steps for performing database upgradation
    1. Tell them as per the procedure you followed
  1. What is the difference between patchset and interim patch?
    1. Patchset is a group of patches and when applied version of database will change. Interim patch is some security bug fix release
  1. How you will find the latest patchset or patch installed on your database?
    1. Using “opatch –lsinventory” command
  1. Do we require to shutdown all databases to apply a critical patch?
    1. Yes
  1. For upgrading a database, which method you will opt? DBUA or manual method? Why?
    1. Manual as we can perform upgrade multiple times even if it fails. DBUA can be used only once
  1. What are advantages and disadvantages of DBUA and manual method of upgradation?
    1. It can be used only once
  1. What are important pre-upgradation steps?
    1. Taking full database cold backup (if approved), backing up oracle home and oracle inventory
  2. What is dataguard?
    1. Providing a disaster recovery solution to a database by having a standby database in another location is called dataguard
  1. How many types of standby databases are there?
    1. Two. Physical and logical
  1. In how many modes a physical standby will work?
    1. Maximum performance
    2. Max protection
    3. Max availability
  1. What is the use of FAL_SERVER and FAL_CLIENT parameters?
    1. They can fix the archive gap occurred due to network failure between primary and standby
  1. Explain how to setup physical standby database
    1. Describe the steps as per the document
  1. What factors to be considered before configuring dataguard?
    1. We need to choose which mode to be enabled and also clearly analyze the client requirement
  1. What is the difference between RAC and Dataguard? Which is efficient?
    1. RAC is a multiple instance, single database concept. Both are having their own adv and disadv.
  1. Is it good to use dataguard broker or not? Why?
    1. Yes. We can automate failover if required and also it helps in monitoring the sites
  1. What is observer’s role in dataguard setup?
    1. It checks the heartbeat between primary and standby sites and in case of any failure it will report to us
  2. What is the difference between switchover and failover?
    1. Switchover means testing the standby environment by manually doing it. Failover means failure of primary site
  3. Which parameters should be use in case primary and standby servers are not having same file systems?
    1. db_file_name_convert and log_file_name_convert
  1. What is the command to switchover a standby to primary?
    1. SQL> alter database commit to swicthover to primary;
  1. You observed archive logs are not shipping to standby, where you will check for the reason?
    1. In the alert log of the primary database
  1. You observed archive logs are shipping, but not applying at standby, where to check?
    1. We will check in alert log of standby database
  1. Which parameter defines the mode of standby database?
    log_archive_dest_2 in which we mention LGWR ASYNC/LGWR SYNC AFFIRM/LGWR SYNC NOAFFIRM
  1. How you will check if database is primary or standby?
    1. SQL> select database_role,protection_mode from v$database;
  1. For a given database, How to know if there is standby database or not?
    1. By checking database role from v$database. Also we can check in alert log file of primary
  1. How to apply a patch for a database which is having a physical standby?
    1. Explain the steps what you performed
  1. Brief the steps for upgrading a standby database along with primary. Can we do both the environments at same time?
    1. Yes we can do both provided we have approval for shutting down primary
  1. My database performance is bad, can I opt RAC as solution?
    1. RAC is not a solution for improving performance. It should be used only as disaster recovery
  1. What is RAC? What is its benefit?
    1. It is a multiple instance, single database architecture. If one instance fails, users can still work with database using another instance
  1. What is ASM? What is the benefit it gives us?
    1. It provides benefit in performance with the use of raw devices as it has striping and mirroring concept as RAID do at OS level
  1. What is grid? Its benefits
    1. It allows to share the resources of multiple databases by bringing them into a single pool
  1. What are the different environments you worked in?
    1. Production, development, quality, test and staging
  1. How can we guarantee that you will join if offered with a job?
    1. If you offer a significant role with the monetary benefit that I am expecting, there is no reason for me to reject the offer
  1. Share your happiest moment of your career
    1. Explain that you resolved some crtitical performance issue which helped your client alot and you got good appreciation for that from top level executives
  1. Share the saddest moment of your career and how you overcome that?
    1. If you want tell them nothing i faced like that till now
  1. Are you an active team member? Which you believe yields best results? Individual work or team?
    1. Tell them that you are both, but you believe mostly in team work as it yields wonderful results than individual work.

PERFORMANCE TUNING INTERVIEW QUESTIONS

View More:
ORACLE EXP/IMP &DATAPUMP INTERVIEW QUESTIONS
ORACLE NETWORKING INTERVIEW QUESTIONS
USER MANAGEMENT INTERVIEW QUESTIONS

Comments

comments

Check Also

ORACLE EXP/IMP &DATAPUMP INTERVIEW QUESTIONS

ORACLE EXP/IMP & DATAPUMP INTERVIEW QUESTIONS How can i make export faster? By using DIRECT=Y …

Leave a Reply

Your email address will not be published. Required fields are marked *