Oracle General Interview Questions
Questions Answers Views Company eMail

how to hide the stored procedure inside a package

1 1239

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

Oracle,

614

What is the difference between online and offline backups?

MCN Solutions,

554

what is the difference between restoring and recovering?

MCN Solutions,

544

What are the most common interview questions on ETL Testing for experience?

585

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

Aricent,

539

State any two functions of oracle?

Aricent,

628

What is Virtual Private Database in Oracle?

MCN Solutions,

607

Can we create database in oracle using command line ?

MCN Solutions,

575

Why use resource manager in Oracle?

MCN Solutions,

654

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

MCN Solutions,

596

What is Undo Management Advisor in Oracle?

MCN Solutions,

601

What is Redo Log Buffer in Oracle?

MCN Solutions,

616

What is clustered table in Oracle?

MCN Solutions,

629

What is data block in Oracle?

MCN Solutions,

610


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What privilege is needed for a user to delete rows from tables in another schema?

557


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1353


Explain about integrity constraint?

594


How to set up autotrace for a user account?

584


How to export your own schema?

558






What is a subquery in oracle?

572


How can you use check constraints for self referential integrity?

513


How to define a procedure inside another procedure?

537


How to rename a column in an existing table?

609


Where do you use decode and case statements?

542


What is primefaces used for?

549


What is ordinary table in oracle?

643


What are the different types of record groups in oracle? Explain each of them

592


What is the difference between substr & instr functions?

590


What happens if the imported table already exists?

539