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?

1102

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

1056

How to handle a single quote in oracle sql?

1053

Is there a function to split a string in plsql?

1055

How to speed up webrick?

1076

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

1048

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

1020

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

1024

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

1090

How do I escape a reserved word in oracle?

1197

How to best split csv strings in oracle 9i?

1041

What is different types of joins?

1022

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

1000

How to get last row id?

992

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

1029

Un-Answered Questions { Oracle }

What is hot backup and logical backup?

1051

Does oracle charge for java?

1055

does odi support web services?

560

Explain each trigger related to mouse.

How to see free space of each tablespace?

1034

What is the difference between a database and instance?

693

What is control file used for?

1209

Explain oracle instance.

1175

Explain the types of record group.

How to display row numbers with the records?

1079

What is the data pump export utility?

1081

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1023

How can you merge two tables in oracle?

1001

What does a senior database administrator do?

608

For More Un-Answered { Oracle } Questions Click Here