What are all parameter used in data pump in your environment with details? What is use of compress parameter? How to take multiple table in export? How to reduce the dump file in data pump? How to move dump from testing env to prod env? What is use of nw link? One job running in data pump for while? Explain about Roles and profiles? However, this can happen only if the database is open. If the database is in shutdown mode, then these tables cannot be accessed and hence password file will be used by the database administrators to log in and open the database.

Q 9 What are the different types of backups that are available in Oracle? This can be achieved using either operating system utilities or RMAN. In contrast, logical backup allows taking a backup of the database objects like tables, views, indexes, stored procedures, etc. Ans: Hot backup is the process of taking database backup while the database is in running mode. Hence, it is also known as Online Backup. While cold backup can be taken only when the database is in shut down mode and hence it is known as Offline Backup as well.

Hence, DBAs need to take the backup in online mode only. Q 11 What is the difference between restoring a database and recovering a database? Ans: During the restoration process, backup files are copied from the hard disk, media or tapes to the restoration location and later make the database operational. Recovery has an additional step of updating these data files by applying redo logs so as to recover the changes which are not backed up. We can restore the lost files using the 11 PM full backup which is Restoration.

In order to do the same, redo logs can be applied which will bring the database to the point of failure. Q 12 What do you understand by Redo Log file mirroring? Ans: Redo log is the most crucial component of database architecture which records all of the transactions within the database even before it goes to the data file. Hence, the mirroring of these files will be done to protect them. Redo Log file mirroring allows redo logs to be copied to different disks simultaneously. And this can be achieved using Data Guard and other utilities.

Oracle apps DBA interview questions

Q 13 How is incremental backup different from differential backup? Ans: Incremental Backup backs up only the changed data files since the last backup, which might be full or incremental. The second incremental backup will only have the transactions occurred after Friday at 10 AM.

Further, if the differential backup is taken on Sunday 10 AM, it will take the backup of the files changed since Friday, 10 AM. Q 14 What is a Flashback Query and when should it be used? Ans: Oracle has introduced a Flashback technology to recover the past states of database objects. It can recover the accidental changes, which got committed as well. In user-managed backups, the user needs to perform backup manually. RMAN does incremental backup rather than taking full file backups which are done by user-managed backups, which again saves time. RMAN creates backup and recovery scripts that can be re-used and scheduled and does not need manual intervention.

Oracle Apps DBA Interview Questions And Answers

Ans: Recovery Catalog is a database schema that holds the metadata used by RMAN for restoration and recovery processes. Q 17 How do you recover a lost control file? Which package will be used for the user validation by plsql agent? Ans: oraclemypage What are adadmin utilities? What are the location of JaVA Files? What is the name of the xml file of Apps and its location? Ans: Context Name.

• 54042017 Interview Questions for Oracle Apps DBA?
• brand new iphone 5 price in india.
• Popular Posts.
• Important Apps DBA Interview Questions.
• Wanna say something?.

Ans: contextname. In how many way Jar files are generated? Ans: Normal and Force Once Jar files are generated what files get effected? How do you see the files in zip file? Ans: unzip -v How do you generate jar files? Ans: Using adadmin and option 5 How do you start the apps services? What is the executable to generate jar files? Ans: adjava How do you relink a executable of a product Ans: by relinking option in adadmin or adrelink How do you relink AD product executable? Ans: adrelink.

When do you relinking? Ans: 1. When there is a problem with any executable file 3.

When any product executable get currupted What is DAD? Ans: It is a file which stores apps passwords in hard coded format. How do you relink OS files and libraries? Ans: using make command What is compile scheman option in adadmin? Where do you get the info about invalid objects? How do you compile an obect? How do you see the errors of a table or view? How do you see the errors in the db? Ans: show error How do you compile a schema? Ans: using utlrp.

How do you know how many invalid objects are in specific schema? How do you know the package version? How do you load java class to database? Ans: loadjava What are restart files? Ans: These files contains the previouse session info about adadmin.. How do you validate apps schema? Ans: To validate synonyms, missing sysnonyms and all grant. You can do it in adadmin. How do you enable maintainance mode?

Ans: using adadmin or running a script called "adsetmmd. Ans: It is used for multi language support. How to see the version of a script or form or report or etc? Ans: grep Header adsetmmd. What is the location of adadmin log? What are the oracle homes in Apps? Ans: 8. How do you configure you ipaddress at client side?

What is the location of Datbase server related scripts?

VANDU ORACLE DBA & APPS DBA Blog: oracle apps dba interview questions for 3+ years of experience

Ans: cmclean. How do you stage the Ans: using adautostg.

• breaking bad iphone 4 wallpaper hd?
• windows phone 7 ogg vorbis?
• religious wallpapers for nokia 5233.

What is the location of the source files of forms? What is the executable to generate forms? Ans: f60gen. Read Free For 30 Days. Many times we know the answer for the questions but unintentionall. Flag for inappropriate content. Related titles. Carousel Previous Carousel Next. Jump to Page. Search inside document. Ans: This is one of the basic question asked in interview.