Topic :: Oracle





Oracle Interview Questions
Questions Answers Views Company eMail

I have configured oracle goldengate integrated capture process using the default values. As the data load increases I see that extract starts lagging behind by an hour (or more) and database performance degrades. How you will resolve this performance issue?

Oracle,

5

what are the various ways to kick-off a workflow you can either use wf_engine.start_process or you can attach a runnable process such ghat it subscribes to a workflow event.when starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?

Oracle,

736

how will you add a new column to a list of values ( lov ) in oracle applications framework? Can this be done without customization?

Oracle,

695

how to debug a document manager in oracle apps?

Oracle,

676

you have written a java concurrent program in oracle apps. You want to modify the classpath such that new class classpath is effective just for this program?

Oracle,

687

does oracle support running of gather states on sys schema in oracle apps?

Oracle,

639

can you do fnd_request.submit_request from sql plus in oracle?

Oracle,

665

how do you know if a specific oracle patch has been applied in apps to your environment?

Oracle,

639

What is the optimization being performed in oracle and SQL Server?

Cap Gemini,

632

In oracle there is column command, how will you explain that?

Aricent,

554

State any two functions of oracle?

Aricent,

640

What is Virtual Private Database in Oracle?

MCN Solutions,

629

Can we create database in oracle using command line ?

MCN Solutions,

584

Why use resource manager in Oracle?

MCN Solutions,

667

What is the difference between view and materialized view in Oracle?

MCN Solutions,

616



Related Topics


Un-Answered Questions { Oracle }

Can we install Oracle database in VT100 Server?

1971

How primary key is implemented in Oracle?

1920

What are the Oracle specific tuning should be done?

1326

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6749

Where in the Oracle directory tree structure are audit traces placed?

2131




Is it possible to call oracle database through ADO control or Object?

1381

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1728

Explain about the Optimizer values passed in Oracle?

2458

How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?

2566

How do you rate yourself in c#,vb.net,Asp.net,oracle,sql server ?

4984

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1833

what is the difference between oracle 8i vs 9i

1767

What are file in oracle.

1816

Why Non-blob column in table required to perform operation with Oracle ?

3572

Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..

1523