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 4433

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

TCS,

2 5895

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 6111

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

Oracle,

2044

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

Oracle,

1 4595

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

1 3490

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 5444

HCL,

2 5264

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

5 7652

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

2 4674

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 4140

DBMS vs. RDBMS

TCS,

2 5430

Which database is better for os platform dependency?

1 3742

Why we choose emp number as primarykey?

4 6622

am completed mca2011 how get certification in oracle

1 2968

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are data pump export and import modes?

1069

Can we write dml statement in function in oracle?

1082

What is format trigger?

2074

How to use "in" parameter properly?

1072

How to compare dates in oracle sql?

1105

Explain the difference between replace() and translate() functions in oracle?

1036

What are the extensions used by oracle reports?

1038

What is BBED in Oracle?

1155

Explain rename?

984

How to rename an existing table?

1129

How to filter out duplications in the returning rows using oracle?

1018

Explain compound trigger in oracle?

1040

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

What is backup in Oracle?

1005

What is an oracle cursor variable?

1076

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