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

Explain about achiever in sql?

985

What are a query and state the different types of queries and their uses?

967

What are temporal data types in oracle?

1084

What is a relational database management system?

1082

What is difference between cartesian join and cross join?

1041

Explain the difference between a procedure and a function? What do you understand by those terms?

1036

Are truncate and delete commands same? If so why?

1095

How do we get field details of a table?

943

What is varray?

1057

What is a cursor variable?

1063

Can we store pictures in the database and if so, how it can be done?

999

How do we display rows from the table without duplicates?

940

What are the differences between lov and list item?

1015

How do we represent comments in oracle?

1009

What do you mean by group by clause?

998

Un-Answered Questions { Oracle }

Is oracle an open source?

1035

What is transactional trigger property?

How do you install statspack?

646

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1808

What is an oracle database?

1005

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2155

What is bulk collect in oracle?

966

What is a procedure in oracle?

1102

How do I become an administrator?

540

Which are the five query types available in oracle?

919

What is proxy method?

940

Why we use bulk collect in oracle?

989

What is Memos?

543

What are dml statements in oracle?

1057

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1982

For More Un-Answered { Oracle } Questions Click Here