3 Replies Latest reply: Aug 7, 2012 2:03 AM by 953429 RSS

    Datapumb exporting

    953429
      Hello all,

      This is my first post in OTN. I am beginner in ORACLE ( just completed my Oracle 10g DBA course and waiting for certification exams.) . I have come across my first interview (infact i couldnt do well as I do not have enough knowledge to answer). Find below few questions asked by the interviewer:

      1. after taking the backups of redolog files, suppose I give the command "Delete input". What will happen?

      2. In windows, using Datapumb, we are exporting the data and we are not giving any directory, by default in windows machine where the data will be exported?

      3. What happens in Oracle Architecture, after a insert command is fired. ie;, Flow in architecture, like how data is stored in database. (asked to draw the architecture and explain)

      4. How to take one day old backup & command used?

      Kindly help me out. I knw these questions are basic still for my knowledge.

      Regards,
      Sathik
        • 1. Re: Datapumb exporting
          952768
          When you completed a Oracle 10g DBA Course then

          Question 1: Will be part of your next course RMAN Backup and Recovery
          Question 2: Never trust on defaults, the best answer is: check the view DBA_DIRECTORIES
          Question 3: If you completed your course, you should be able to answer this, if not start reading your books again and again.
          Question 4: see Question 1.

          It is not a problem to be a beginner but you can act like a professional.
          This means try to study hard, proof for yourself how things work and do a lot of research before asking questions.
          • 2. Re: Datapumb exporting
            Tareq Alkhateeb
            1. after taking the backups of redolog files, suppose I give the command "Delete input". What will happen?
            you can not take a backup of online redolog files.
            but if you mean archived redologs, bakcup archivelog delete input : means take a backup of existing archivelogs as backupset and delete them

            2. In windows, using Datapumb, we are exporting the data and we are not giving any directory, by default in windows machine where the data will be exported?
            use the following SQL query to find the default location of data pump:
            select owner, directory_name, directory_path from dba_directories where directory_name like 'DATA_PU%';


            3. What happens in Oracle Architecture, after a insert command is fired. ie;, Flow in architecture, like how data is stored in database. (asked to draw the architecture and explain)
            actually this is very long question, and can not be explain in just words.

            4. How to take one day old backup & command used?
            I don't understand you question.

            Kindly help me out. I knw these questions are basic still for my knowledge.
            • 3. Re: Datapumb exporting
              953429
              Dear Sir,

              Thank you very much.


              Regards,
              Sathik