Database Administrator (dba) interview questions – page 26

If the business entity has 5 operating units how many times do you have to implement in apps?

What is a SNAPSHOT LOG ?

What are the advantages of having a Package ?

How do I create an Index?

What is the difference between a Function Key Trigger and Key Function Trigger ?

How do I create a table?

Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?

How do I switch between languages (proof text in different languages)?

What is snapshots?

What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?

How to remove duplicates in server job

What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

What is Two-Phase Commit ?

When is PRE-QUERY trigger executed ?

What is a SQL * NET?

What are the various type of snapshots?

Where actually the flat files store?what is the path?

What is a SNAPSHOT ?

Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible?

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

How dou you enable trace/debug in apps?

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

What is difference between Merge stage and Join stage?

What is the mechanism provided by ORACLE for table replication ?

Why are my columns not lined up when I print?

Security rules don't seem to work on all forms when performing a query.

How do I tell the Speller to skip the parts of my document that are not in English?

How do I set tabs?

How to implement type2 slowly changing dimenstion in datastage? give me with example?