Data Warehouse Developer interview questions – page 28

What is the difference between GL date and GL posted date in GL module ?

What are the triggers associated with a check box?

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

How do I create additional pre-set color fills?

What are the different type of Segments ?

Describe Oracle architecture in brief.

What is version Control?

Explain the relationship among Database, Tablespace and Data file.

What is an SQL *FORMS ?

Explain the areas of memory used by oracle, i.e. Software code area, system global area (SGA), program global area(PGA), sort area.

What is a project? Specify its various components?

What does a Control file Contain ?

How can you achieve ZOOM functionality using personalization?

How much would be the size of the database in DataStage ?

What are the system resources that can be controlled through Profile ?

What is the maximum size of a form ?

What are validations you perform after creating jobs in designer.What r the different type of errors u faced during loading and how u solve them

What is the maximum number of CHECK constraints that can be defined on a column ?

How to use timestamp datatypes?

Any way to seamlessly run slide shows sequentially?

How can I change the speed of the transitions?

What is user Account in Oracle database?

How do I share a document with someone who doesn't have my version of Word?

What is a profile ?

Any way to have OLE objects update automatically in slide show?

What is a Procedure ?

If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan

What is a Layout Editor?

List the windows event triggers available in Forms 4.0?

How do I show a deletion of a word in Track Changes?