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 5894

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,

2043

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 5443

HCL,

2 5263

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

5 7651

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

2 4673

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 4139

DBMS vs. RDBMS

TCS,

2 5428

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 2967

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the advantages of oracle?

1028

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

What to do if the startbd.bat failed to start the xe instance?

1083

Is java required for oracle client?

1001

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291

What is the exact use of Collections?

2143

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

1029

What is blob data type in oracle?

1123

Whats the benefit of dbms_stats over analyze?

2003

What happens to indexes if you drop a table?

1171

What is Redo Log Buffer in Oracle?

1209

How to invoke the data pump import utility?

1165

How are extents allocated to a segment?

1125

What is concurrency in oracle?

1008

How different is ms access and oracle?

1040

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