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 insert multiple rows with one insert statement in oracle?

1027

How to connect ms access to oracle servers?

947

How to delete all rows a table in oracle?

1016

What is a parameter file in oracle?

1060

Can the query output be sorted by multiple columns in oracle?

940

Can group functions be used in the order by clause in oracle?

947

What is a static data dictionary in oracle?

1038

How to assign a tablespace to a users in oracle?

1001

How to drop an existing table in oracle?

1017

What is an oracle data file?

1047

How to revoke create session privilege from a user in oracle?

966

What is a database table in oracle?

968

What is an oracle recycle bin?

941

How to use existing values in update statements using oracle?

1017

Can multiple columns be used in group by in oracle?

936

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Segment Advisor in Oracle?

1055

How do I find my oracle client driver version?

982

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

979

What operating systems are supported by oracle database 10g xe?

989

What is literal?

960

How to connect to a remote server?

1063

Explain what are the type of synonyms?

1062

What are privileges and grants?

1009

How to use "startup" command to start default instance?

969

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1911

What is merge statement used for?

978

What are the oracle differences between nvl and coalesce

1076

State some uses of redo log files?

951

How to find out what oracle odbc drivers are installed?

983

How to view all columns in an existing table?

880

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