Oracle General Interview Questions
Questions Answers Views Company eMail

How can Oracle users be audited?

MCN Solutions,

601

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

624

What is backup in Oracle?

MCN Solutions,

567

What is transaction control statement and how many types of transaction control statement in Oracle?

MCN Solutions,

562

Give syntax for SQL and ORACLE joins.

TCS,

627

What is Segment Advisor in Oracle?

MCN Solutions,

666

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

631

What is MTTR advisor in Oracle?

MCN Solutions,

608

How many types of cluster table in Oracle?

MCN Solutions,

571

How to get the Installed Oracle Version Information ?

MCN Solutions,

620

What is flashback in Oracle?

MCN Solutions,

581

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

576

How to check database size in Oracle?

MCN Solutions,

635

What is catalog in Oracle?

MCN Solutions,

642

What is archive log in Oracle?

MCN Solutions,

595


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between formal parameters and actual parameters?

541


Can you create a synonym without having a table?

553


Give the constructs of a package, function or a procedure.

534


How to sort the query output in oracle?

608


How to create tables for odbc connection testing?

485






How oracle handles dead locks?

598


How to use subqueries with the in operator using oracle?

606


Why oracle is used?

578


Explain implicit cursor.

553


What is instant client oracle?

538


How to define a sub function?

660


What is a proxy object?

579


What is Data Dictionary Cache in Oracle?

657


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

598


What is logical backup in oracle?

574