Oracle Interview Questions
Questions Answers Views Company eMail

Does oracle database need java?

604

How do I uninstall oracle client from windows?

622

What is oracle thin client?

629

Does oracle charge for java?

691

What is oracle database client?

655

What is java oracle used for?

631

What is a table in oracle?

629

What is oracle datasource?

639

What is the sid in oracle?

612

How do I connect to oracle?

658

What is difference between sid and service name in oracle?

597

How do I manually create a database in oracle?

618

How do I find my oracle client driver version?

614

Is java required for oracle client?

632

What is oracle in java?

630


Un-Answered Questions { Oracle }

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1675


What is a proxy class?

643


Why more redos are generated when the oracle database is in begin backup mode?

751


How would you best determine why your MVIEW couldnt FAST REFRESH?

1519


Explain a data segment?

751






Which process writes data from data files to database buffer cache?

347


How to lock and unlock a user account in oracle?

723


How to bring a tablespace online?

616


How do I know if oracle client is installed on windows?

588


Whats the benefit of dbms_stats over analyze?

1591


What are advantages of dateset in datastage?

1876


Where are the settings stored for each instance in oracle?

742


What is hash cluster in oracle?

694


What are the skills required for oracle dba?

365


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

947