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 SYSTEM tablespace and when is it Created?

1082

What is the use of Oracle Control File?

1035

What are the common oracle dba tasks?

1089

What is the difference between pre-select and pre-query?

1150

What is raw datatype?

1090

What is a subquery?

1072

Explain coalesce function?

1140

What is a package ? What are the advantages of package ?

1051

Will you be able to store pictures in the database?

1079

Whether any commands are used for months calculation? If so, what are they?

1055

What is difference between truncate and delete?

994

What are the benefits of ordbms?

1049

What is a oracle database?

1012

What are the various oracle database objects?

1106

Explain the characteristics of oracle dba?

1082

Un-Answered Questions { Oracle }

Explain about your project and its relation to the current job position you are applying to?

961

what is the difference between functional dependecy and multilevel dependency?

2429

Can you tell me how to add new column in existing views?how?How is possible?

1392

What privilege is needed for a user to create indexes in oracle?

982

How to grant create session privilege to a user in oracle?

962

What are the differences between char and nchar in oracle?

1039

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2323

How to name query output columns in oracle?

1147

how to remove the duplicate in odi?

591

What is blob data type in oracle?

1063

What is Virtual Private Database in Oracle?

1034

Can we create database in oracle using command line ?

1041

Mention what are the key characteristics of rac or why to use rac?

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2099

How to create an oracle database manually?

1041

For More Un-Answered { Oracle } Questions Click Here