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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to turn on or off recycle bin for the session?

1038

What are the logical operations?

1066

How to list all indexes in your schema?

1034

What is the data pump export utility?

1023

How to create a new table in your schema?

1035

What happens to the data files if a tablespace is dropped?

996

How to see free space of each tablespace?

969

How to use "out" parameter properly?

1028

Can you drop an index associated with a unique or primary key constraint?

970

What are data pump export and import modes?

1019

How to generate query output in html format?

1036

Can sub procedure/function be called recursively?

948

What happens if recursive calls get out of control?

1000

How to get a list of all background sessions in the database?

946

How to get execution statistics reports on query statements?

1009

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2248

material view and view disadvantages?

1020

How to connect ms access to oracle servers?

947

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

953

What is control file used for?

1102

Differentiate between function and procedure in oracle.

1022

master table and child table performances and comparisons in Oracle ?

2071

What happens if the imported table already exists?

974

What is the quickest way to fetch the data from a table?

1001

What are the advantages of oracle 12c?

1121

What are the uses of a database trigger?

931

what are the advantages of running a database in archive log mode?

2144

What is catalog in Oracle?

1266

how to join query for one source type is oracle another source type is sql server ?

2379

what is the use of system.effective.date variable in oracle?

1056

For More Un-Answered { Oracle General } Questions Click Here