Oracle Interview Questions
Questions Answers Views Company eMail

Explain integrity constraint?

633

In which language oracle has been developed?

633

Difference between varchar and varchar2 data types?

650

What is hash cluster in oracle?

586

What is the parameter mode that can be passed to a procedure?

561

How many memory layers are in the oracle shared pool?

628

What are nested tables?

661

How do we get field detail of a table?

611

What are the roles of dba?

600

Differentiate between pre-select and pre-query?

603

What is save point in oracle database?

714

What is hot backup and logical backup?

594

What is the fastest query method to fetch data from the table?

833

can you convert or reverse engineer a fmx back to a fmb file?

683

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

583


Un-Answered Questions { Oracle }

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

430


What are the types of Generic profiles types in ODI?

432


Explain the difference between repeating frame and frame.

1


Explain the types of record group.

1


What are the original export and import utilities?

556






Explain drop constraint oracle?

578


What is auto invoicing? : oracle accounts receivable

643


What is the difference between sharding and replication?

467


How to build data dictionary view an new database?

520


You see multiple fragments in the system tablespace, what should you check first?

275


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1731


What is Trigger in Oracle?

563


Mention in rac what files should be created on shared storage?

1


Can i create more than one Master Repository in ODI?

296


What is instant client oracle?

531