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

How to compare dates in oracle sql?

1061

What is the sql query to concatenate column values from multiple rows in oracle?

1007

How to handle a single quote in oracle sql?

984

Is there a function to split a string in plsql?

997

How to speed up webrick?

1014

How can I get column names from a table in oracle?

1002

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

976

How to connect to oracle using service name instead of sid?

970

When do I need to use a semicolon vs a slash in oracle sql?

1040

How do I escape a reserved word in oracle?

1144

How to best split csv strings in oracle 9i?

999

What is different types of joins?

978

How to fetch the row which has the max value for a column?

959

How to get last row id?

947

How to put more than 1000 values into an oracle in clause?

982

Un-Answered Questions { Oracle }

Why do you create or replace procedures rather that drop and recreate.

959

What is a table in oracle?

938

How can I learn oracle dba?

509

How do I become an administrator?

539

What is StandAlone Agent and default port number?

659

How would you identify the shared_pool_size parameter that needs to be adjusted?

What is an Oracle Data Dictionary?

1056

Explain how one can iterate through items and records in a specified block?

1040

What is the meaning of database backup?

573

What is the scope of a local variable?

1011

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2106

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2429

Use of an integrity constraint is better to validate data. Explain

992

What is the difference between a database and instance? What is the relation between them?

541

What is meant by recursive hints in oracle?

1045

For More Un-Answered { Oracle } Questions Click Here