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

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

Oracle Interview Questions

Questions Answers Views Company eMail

What is an oracle data file?

1103

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

1018

What is a database table in oracle?

1021

What is an oracle recycle bin?

1009

How to use existing values in update statements using oracle?

1067

Can multiple columns be used in group by in oracle?

988

How to write a query with a left outer join in oracle?

1065

How many categories of data types in oracle?

1029

What are the oracle built-in data types?

1064

What is a read write transaction in oracle?

1093

How to create an oracle database?

1041

How to count groups returned with the group by clause in oracle?

1075

What is an oracle tablespace?

1043

What is a dynamic performance view in oracle?

991

How to execute a stored procedure in oracle?

1091

Un-Answered Questions { Oracle }

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1159

What are parameter files? Where do we use them?

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

How to drop an existing table in oracle?

1058

what is oracle forms?

1104

What are a collation and state the different types of collation sensitivity?

1170

What is oracle thin client?

1023

When should the default values for oracle initialization parameters be used as is?

672

How to empty your oracle recycle bin?

1021

Can a View based on another View in Oracle?

1028

Explain the use of analyse option in exp command.

1128

Define oracle database

1043

Explain the use of record length option in exp command.

1067

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

601

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

997

For More Un-Answered { Oracle } Questions Click Here