Topic :: Oracle





Oracle Interview Questions
Questions Answers Views Company eMail

Is oracle an operator?

 536

What is not equal to in oracle?

 534

What is set operator oracle?

 532

What is where clause in oracle?

 534

Which is faster join or subquery in oracle?

 537

What is difference between sybase and oracle?

 473

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

 489

What is a lookup table in oracle?

 544

Is java part of oracle?

 478

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

 571

How can we increase the loading performance of oracle table in AbInitio?

 646

How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base

 1 879

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

 964



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