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

Oracle General Interview Questions

Questions Answers Views Company eMail

12 RULES OF RDBMS

1 4360

How do we know whether an index is created on a table ???

TCS,

2 5787

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 6019

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

Oracle,

1991

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

Oracle,

1 4486

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 3398

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

HCL,

3 5321

HCL,

2 5156

select * from emp what happened internally when we write this query in the sql prompt?

5 7459

can you explain performance tunning in oracle(sql,PL/SQL)

2 4565

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 4055

DBMS vs. RDBMS

TCS,

2 5319

Which database is better for os platform dependency?

1 3626

Why we choose emp number as primarykey?

4 6441

am completed mca2011 how get certification in oracle

1 2889

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a snapshot log?

958

How to name query output columns in oracle?

1135

How to test null values?

1044

Difference between inner join vs where ?

983

What are the attributes that are found in a cursor?

1015

Explain the importance of .pll extension in oracle?

958

what are bitmap indexes? How does they work?

2186

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2252

What are the differences between char and nchar in oracle?

1023

What is oracle update statement with inner join ?

998

What are the limitations of check constraint?

966

What is a parameter file in oracle?

1057

What is oracle thin client?

979

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1902

How to create a table index in oracle?

1086

For More Un-Answered { Oracle General } Questions Click Here