Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to assign values to variables?

565

How to retrieve data from an cursor to a record?

552

How to save query output to a local file?

548

How to export your own schema?

558

How to convert character types to numeric types?

564

What are the system predefined user roles?

579

How to create a table in a specific tablespace?

530

How to create a table interactively?

542

How to drop a stored function?

666

How to export data to a csv file?

608

What are the differences between interval year to month and interval day to second?

539

How to bring a tablespace offline?

528

What is the order of defining local variables and sub procedures/functions?

587

How to retrieve data from an explicit cursor?

549

What are the arithmetic operations?

569

Un-Answered Questions { Oracle }

How to invoke the data pump import utility?

636

State and explain the different types of data models?

522

Explain master-detail relationship with some examples.

571

What are named parameters?

602

in the package one interface got failed how to know which interface got failed if we no access to operator?

308

What is the most common database language that a db administrator needs to know?

259

Explain the use of indexes option in exp command.

581

How would you change old and new values in an insert, delete and update triggers?

532

Can we convert a date to char in oracle and if so, what would be the syntax?

540

What is a connect identifier?

532

What are triggers in oracle?

548

as a technical developer in oracle applications which type errors feced in your experience sofar

1758

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1598

What if your ocr (oracle cluster registry) is corrupted?

How a tablespace is related to data files?

573

For More Un-Answered { Oracle } Questions Click Here